Performance optimizer SAP BO Analysis
Performance issues with the filter function in SAP BO Analysis…? This solution can help you to speed-up SAP BO Analysis!
This optimizer can be used for the filter function on the right panel in SAP BO Analysis (see image below). When you want to filter on an object that contains a lot of records (i.e. 0MATERIAL, 0PRODORDER, etc.), users can wait a long time.
First all posted values are read from the SAP BW infocube. In the properties of an infoobject the standard setting for “Query Execution Filter Val. Selectn” (tab BusinessExplorer) is set to “Only Posted Values for Navigation”. This is the reason why SAP BO Analysis take much time to read the posted values.
To speed up SAP BO Analysis, you can change the setting “Query Execution Filter Val. Selectn” to “Values in Master Data Table” (see image below).
This is not the full solution!!! Read more…
When you changed the setting in your infoobject, SAP BO Analysis is not opitimized, it can even be slower! In this situation all values from the Master Data Table are read from SAP BW, this may result in a time out. To speed-up this process, create a secundary index on the Master Data Table (/BI0/P… or /BIC/P…). In the next steps you’ll learn how you can create an secundary index:
1. Go to the properties of your infoobject, tab “Master data/texts”
2. Double click on the P-table, in my example: “/BI0/PD_MATERIAL”
3. Click on “Indexes…”
4. Create a new index, enter a technical name, for example: Z01. In the lower window select your index field (see image below)
5. Activate your index, the index will not automatically created, only activated!
6. Go to transaction SE14
7. Select your infobject, for example: /BI0/PD_MATERIAL
8. Choose your index, your index ID will change like: /BI0/PD_MATERIAL – Z01
9. Delete database index
10. Create a new index (a background process is recommended)
After these steps, your secundary index is created. If you filter in SAP BO Analysis on your (edited) object, your data for filtering will be much faster on your screen!
Note: indexes are not transported automatically, create your index on each SAP BW environment. (For ABAP programmers….I know, you can build an ABAP code to create the index automatically ;-))