PEL is the default
language for creating business rules in PerformancePoint. PPS-P then
translates PEL into T-SQL or MDX. You can view the generated code in
the debug window.
However, for certain scenarios, using native MDX code can be much more efficient.
To use native MDX, follow these steps:
- Enable SQL/MDX in the PPS application (use the Admin console to change this setting).
- When creating your rule in the planning business modeler, select 'native MDX script' in the rule implementation field
- in the code window, type your MDX code as if you were in the calculation script of your Analysis Services cube
- set the rule Status field to 'inactive' (you can not deploy a native MDX rule with an 'active' status)
- save your model
- go to the PPS application database and search for the RuleSetsOrRules table
- in that table, set the IsActivated flag to 'True' for the rule you just created in PPS
- go back to the business modeler and deploy your rule. It
should then write your rule to the cube calculation script (you can
check this by generating the script for your PPS cube in Management
Studio)
Using native MDX script is a bit more challenging to deploy, but the gain in performance is worth the effort!
Good luck!
Subscribe