How to format MDX statements

Once the MDX list is used in a report, you can format, you can format the created MDX statement by creating the rules and applying them to different levels and members of the dimensions.

To create

Image Removedthe rule, you should click on the Rules button above the list.

Image Added

Define a condition, to which the rule will be applied:

Image RemovedImage Added

• Account level stands for dimension level
• Account name stands for dimension member
• Is last item stands for the last item in the list
• Index stands for the serial number of the item in the list

Define an action to be applied to the condition:

Image RemovedImage Added

• Apply Format - allows to select a specific format to be applied to the condition
• Apply Drill - allows to select a specific drill to be applied to the condition
• Set Custom Description - allows to select a specific description to be applied to the condition
• Set Empty - select this option, if you want to leave the condition empty
• Set Visible - select this option, if you want to make the condition visible
• Apply Header Format - allows to select a specific format, to be applied to the header
• Set Reverse Valuation - makes the negative values positive and vice versa
• Set Reverse Sign - flips the sign
• Set Suppress Value - sets automatic row suppression (e.g. suppresses rows with no data and zeros)

Example:

Let's consider an example of a report, where in the rows we want to include all members from Account dimension.

The MDX statement in this case will look as follows:

[ACC].[ACC].AllMembers

Then we will set three rules to be applied to different levels of Account dimension:

1. Account level equals 01 - apply Default Total format
2. Account level equals 02 - apply Base Inclusive Drill
3. Account name equals GrossMargin - apply Default Highlighted Header format

As a result we will get the following formatted report:

See also

• MDX List