
Recently my team and I had some issues with the performance of some packages in our project. So I wanted to share with you my tiny little experience (we can read a lot of information, but a pratical example is always the best way to understand the impact).
Scenario: implementing the /CPMB/LOAD_INFOPROVIDER_UI between two BPC infocubes (from different environments), to transfer data.
I can tell you that after we implemented the Light Optimize process chain (/CPMB/LIGHT_OPTIMIZE) in the source infocube, the package execution time decreased from 5 hours to 15 minutes.
It is impressive the influence that this little "optimization" has on your BPC infocubes performance. So I gattered all the information I found, and wrote this blog.
Hope you enjoy it!
Characteristics
Light Optimization compresses and indexes the stored records and updates infocube statistics for system processing. It is one of the tasks that belong to the BW InfoCube performance maintenance tasks.
Recommendations
From SAP 1508929 “There is no rule of thumb for how often to run optimizations. The need can vary depending on the characteristics of your hardware environment and your application.” There is no set recommendation as to the frequency, however it is generally recommended that these under some specific circunstances:
FAQ's and Note's
You might have some problems during the configuration of this process chain if the model/application has too many records (in our case we only scheduled this process chain after 1 year and half).
1. Symptom: Dump Time Out
Implement the SAP Note 1947726 - UJ0_EXCEPTION during a Light Optimize with large number of request
After a new execution of the process chain, you can always use the following note, to be sure that the Light Optimization was sucessuful: 1626814 - How to determine if a BPC Lite Optimization was successful
Also related: Optimizing Performance
You can try to prevent or analyze some performance issues. Please read the following documentation, provided by our forum:
Business Planning and Consolidation 5.x Performance Tuning Guide (PDF 458 KB)
This guide is an update to a previously posted document regarding BPC 5.x performance tuning guide.
Performance Analysis and Tuning Guide for SBO Planning and Consolidation version for Netweaver 7.x (PDF 1 MB)
This guide describes different aspect of performance relevant topics in the context of customer defined functions of SAP BusinessObjects Planning and Consolidation version for Netweaver application. It highlights some of the design aspects that can influence the performance of a specific application as well as providing general guidelines, recommendations and best practices.
Thank you for your attention!
Happy learning :smile:
Best regards,
Raquel Oliveira
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 | |
1 |