Both during and after an SAP BPC implementation, it’s extremely important to make sure that you are addressing critical areas of performance to achieve the highest level of efficiency. Check out the below tip from Scott Cairncross’s presentation at the BI 2011 event that took place this past March that outlines 3 of the key areas you’ll want to focus on.
3 Areas in Which to Address Performance Optimization in SAP BPC
1. Understanding Multidimensional Expressions (MDX)
- MDX is the backbone for calculations within SAP BusinessObjects Planning and Consolidation regardless of which version you leverage
- It is critical that you understand the following:
- What is MDX?
- What are the impacts of leveraging MDX?
2. Financial calculations (Script Logic/T-SQL/BAdIs/business rules)
- In every planning application, be it Microsoft Excel or a different application, there is always some sort of script or formula driving business calculations
- In SAP BusinessObjects Planning and Consolidation there are a few ways to perform calculations
- Using Script Logic – Understand the benefits of leveraging Script Logic and the set backs
- Using table driven logic/business rules – When does it make sense to use an account transformation vs. writing Script Logic?
- Do it yourself/custom logic – Use low-level “logic” that performs the best, however, it is the most complex to maintain
3. Shared Query Engine (SQE) usage
- SAP BusinessObjects Planning and Consolidation always calls the SQE when reading information
- How the SQE is called will impact performance
If you are evaluating BPC or have questions about your BPC implementation options, make sure you check out Scott’s live question and answer forum that is scheduled for Wednesday, May 11, 12:30pm - 1:30pm EST on Insider Learning Network. You can get real-time answers to your most pressing questions. REGISTER TODAY!