members based on other member values.
They are commonly used for calculated key figures, such as costs per unit, percent of sales, growth rates and other ratios.
Dimension formulas should only be used for formulas that need to be calculated after aggregations (e.g. ratios).
Dimension formulas should not be used on members that need to aggregate. We recommend that you use hierarchies, rather than formulas, to define aggregate (or sub-total) dimension member levels.
Familiarity with the Multidimensional Expressions (MDX) language may be helpful when creating more complex dimension member formulas.
However, fewer MDX keywords are supported in SAP NetWeaver Business Intelligence (BI) than were available in SAP Business Planning and Consolidation 5.x using SQL Server.
Benefits of Dimension Member Formulas
Benefits related to dimension member formulas include:
- Speed
- Consistency
Considerations:
- Lack flexibility
- Shared by all applications in the App Set
- Retrieval performance
No comments:
Post a Comment