What is Rules Editor?

Rules Editor window is used to apply formatting to the members of the "classical" dynamic lists (i.e. DescendantsExclusive, BaseInclusive, etc).

You can format the dynamic list by creating the rules and applying them to different members of the dimensions.

How to format dynamic lists

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 the rule, you should click on the Rules button above the list.

Image Added

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

Image 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 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 multi-column reports, where the rows will be represented by a classical dynamic list with DescendantInclusive type:

Image Added

We will set

one rule to this list:

• If index is 3, than Set Custom Description: Replace "Electronic" with "Modern")

As a result we will get the following formatted report:

Image Added