Show TOC

Function documentationDimension Logic Locate this document in the navigation structure

 

Dimension logic, which is also known as member formulas, allows you to create and execute formulas and calculations on dimension members.

Features

Use the following guidelines when implementing formulas:

  • The system calculates dimension formulas at retrieval time. Formulas can slow retrieval performance if you use them incorrectly.

  • Implement dimension formulas only for members that need calculating after aggregations, such as ratios. Do not use formulas on members that need to aggregate.

  • Use dimension formulas only for ratios that need to be calculated at both the base and parent level. If the resulting value is aggregated to the parent, use script logic to write the results to the database.

Defining dimension logic

To use dimension logic, you must add the property FORMULA to a dimension by choosing Maintain dimension property. FORMULA then appears as a column in the dimension member sheet, which is where you define the calculation you need Planning and Consolidation to execute.

Note Note

The dimension property SOLVE_ORDER is required when you use the property FORMULA; the system automatically adds the property SOLVE_ORDER (see Member Behavior Using Dimension Properties.

End of the note.

You cannot reference MDX functions, also known as user-defined functions, from a library file.

For information about restrictions pertaining to dimension logic, see SAP Note 1356081.