Member Formulas
Member formulas allow you to create and execute formulas and calculations on dimension members.
Prerequisites
The Enable Member Formulas option is selected for the dimension to which you are applying the member formula. See Dimension Properties.
Features
Use the following guidelines when implementing formulas:
-
The system calculates formulas at retrieval time. Formulas can slow retrieval performance if used incorrectly.
-
Implement member formulas only for members that need calculating after aggregations, such as ratios. Do not use formulas on members that need to aggregate.
-
Use 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 logic scripts to write the results to the database.
You cannot reference MDX functions, also known as user-defined functions, from a library file.
For information about restrictions pertaining to member formulas, see
1356081 
.
Activities
You can view the member formulas added to a dimension in the administration panel, by choosing Member Formulas, under the Rules section, and then choosing the name of a dimension.
You can add a formula to a dimension, as well as edit and delete a formula assigned to a dimension.