Tip Doctor, Insider Learning Network
This SAP BusinessObjects Planning and Consolidation tip comes from an article written by Pravin Datar, director of SAP BusinessObjects Planning and Consolidation Solution Management at SAP. The advice was posted in September 2011 to BI Expert, the leading independent online knowledgebase for professionals who manage and support SAP NetWeaver BW activities.
SAP BusinessObjects Planning and Consolidation gives the option to optimize a data model from the front end.
In SAP BusinessObjects Planning and Consolidation’s action pane, there are two options to optimize: Lite Optimize and Full Optimize (Figure 1). Optimize in this sense means changing the dimension assignments to improve performance.
Figure 1 Options to optimize the data model
The Lite Optimize option does not make any changes to the data model. It just closes the open request, compresses and indexes the cube, and updates database statistics.
However, the Full Optimize option can rearrange the characteristics among 13 user-defined SAP NetWeaver BW dimensions.
The Full Optimize process checks if the size of the dimension table is less than 20 percent of the fact table and creates as many line item dimensions as possible (20 percent is the standard optimization logic built in).
To do this reconfiguration, the Full Optimize process:
• Takes the application set offline
• Creates a shadow cube with optimal data model
• Links the new optimal cube to the MultiProvider for the application
• Moves data to the shadow cube
• Deletes the original cube
• Closes the open request
• Compresses and indexes the cube
• Updates database statistics
• Brings the app set online again
Though this results in creating a new InfoCube, the MultiProvider remains the same and all the SAP BusinessObjects Planning and Consolidation reports are built on the MultiProvider and not the underlying InfoCube. Hence, this optimization does not affect the SAP BusinessObjects Planning and Consolidation reports on this data.