Simple and Advanced MDX/Rules Explained

There are 2 types of rules you can build; simple and advanced.

Simple

To build simple rules, you'll use the Simple Rule page. Using the Simple Rule page, you'll setup references to dimensional members.

Advanced

Using the Advanced Rule page, you can create calculated formula members with arithmetic operations on dimensional members. You can also use formulas and functions.

As stated earlier, you can select dimension members to set up line references.

• Report Set Lines - Select the lines you want to populate with dimension formulas.

• Multiple Dimension - Associate the report set lines with more than one dimension.

• Search for a dimension in the dimension hierarchy.

• Click a member in the hierarchy to view the associated formula. For example: [Measures].[MTD]

• Left Formula Pane- The current rule. To compose a member definition with more than one dimension, wrap the members in parentheses. For example; ([Scenario].&[1],[Measures].[MTD])

• Right Formula Pane- A text explanation of the formula.

• Cube - The cube on which the formula is built.

• Clear Rule - Delete the formula.

• Check Syntax - Check for formula errors.

To create a formula, select a member from the left selection pane and click Add Member. Or, use Rule functions to create a dynamic formula.