Buy

Buy

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

2 comments:

Note

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