SAP BPC Optimizing applications
When you create new application sets and applications, only a small amount of data exists. As the amount of data you maintain grows over time, we recommend you periodically run the optimize function to improve performance.
Two types of optimization exist — Light and Full.
Light Optimization compresses and indexes the stored data and updates database statistics for system processing.
Lite Optimization
Is a maintenance process similar to the BW InfoCube performance maintenance tasks of index rebuild, statistics rebuilds, and compression.
This process deletes the infocube indexes and moves records from the F to the E fact tables.
This process compresses/collapses the records with the same key
Additional zero suppression is possible (manually adjusted in process chain)
Updates the infocube statistics
There is no set recommendation as to the frequency, however it is generally recommended that these (index/statistics) tasks be executed after the load process to provide satisfactory performance for reporting and input schedule updates.
“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.”
As best practice:
When new application sets and applications are created run a Full Optimization.
Lite Optimization doesn’t take the system offline, and can be scheduled during normal business activity (e.g. after a data load)
Full Optimization need the system to be offline so they should be run at down-time periods – for example after a month-end close.
• Full Optimization performs the same operations as Light Optimization. In addition, it checks the NetWeaver BI data model and, if the data model can be improved, improves it. Running a full optimization could take a long time when a large volume of data exists.
Full Optimization
This process essentially rebuilds the application in its entirety. The process creates a new application and copies the data to the new application.
This process is a RESTRUCTURING of the BPC application data model
How does the system determine if a full optimization is necessary?
The algorithm looks at the size of the dimensions and the dimension members. If the dimension tables have <20% size of the fact table and as many line item dimensions are used, then the system will give a message “Optimization not required at this time”.
If the InfoCube needs restructuring – do it, then perform lite optimization
if not, perform a lite optimization
why does the infocube technical name change with the Full Optimization?
Optimize an application by choosing Select Optimize Application from the Manage Applications action pane, then choosing one or more applications and a type of optimization to perform.
