List of Posts

Get this widget
To get notifications, Please like our Facebook Page >>>>>>

Use Search box to find a topic in this Blog!!!

Performance Issues in SAP BI/BW

Performance can be 
 Reporting Performance
 Load Performance or 
 General Performance.
For improving Report Performance
-Create Aggregates on Infocubes
-Use OLAP Cache for buffering the query result to reduce burden on database
-Pre-caliculated Web templates helps to distribute workload of running report to off-peak hours and can have report result set ready for very fast access to data.
-Use small amount of result data as starting point of any queries and do the drill down
-Avoid reporting on ODS
-If you use exclusion in reporting (<>), the indices are not used, so avoid using the exclusion but use inclusion.
-Use read mode "read when navigating and expanding the hierarchies"
-Use compression of infocube since the E table is optimized for queries
-Create additional indexes at manage data target - performance tab
-Run DB Statistics often

For improving Load Performance
-Check the ABAP Coding at transfer and update rules this would make performance slow
-Keep available of more dialog processes available and do load balance to different servers
-Indexes on source tables
-Use fixed lengh files if you load data from a flat files and put the files on the application server
-Prefer to use SAP delivered standard extractors
-Use PSA and Datatarget parallel option in the infopackage load settings
-Start several infopackages parallel with different selection options
-load master data before loading transaction data

For improving
General Performance
-Archieve and delete the old data
-Use line item dimensions for large data
-Use BW statistics cube to monitor the performance
-If you are not going to use ODS for reporting desable the Bex reporting flag



This blog is solely for the purpose of getting educated in SAP. This blog does not encourage distribution of SAP hold copyright and any other publication and/or materials bearing SAP mark. If you find any copyright materials, please mail me so I can remove them. This blog is not in association with SAP.

ALL Posts

Get this widget