Home > WORKING WITH EXCEPTIONS > Defining an Exception

Defining an Exception

Exceptions can be defined using one of the following methods:

·         Simple – This method is used to highlight cell values that meet a simple condition.

·         Bubble up – This method is used to look for exceptions in levels below the current level displayed in the grid. It enables you to find anomalies in the data without having to search each branch of detailed data individually.

·         Free MDX formula – With this method, an exception condition can be defined using MDX syntax.

To define an exception:

1.      From the Measures dropdown list, choose the measure for which you want to define exceptions. The current measure in the grid is selected by default.

2.      Click the Add button to open a new exception panel.

3.      In Enter Name, enter a name for the exception. In Description, enter the description that you want to appear in the tooltip for the highlighted values.

4.      From the markers dropdown, choose a marker. For example, you can use the Up Triangle to mark exceptions that are higher and the Down Triangle to mark exceptions that are lower than a specified value.

5.      Choose the color of the marker from the palette. For example, you can highlight an exception value with a red square marker.

6.      If you have selected Forecolor, you can choose a font style.

7.      To apply the exceptions to specific rows and columns, select Selected members.

Drag the relevant member(s) from the grid to the members box. To select more than one item at a time, select them in the grid while holding the Ctrl key, and then drag them to the list.

You can also use the Member Selection  button to select dimension members.

Use the remove buttons on the right to remove a selected member or all members. Use the reordering arrows to move members up or down in the list.

8.      In Select type, choose a method and enter the definitions. See Simple Exception, Bubble Up Exception, or Free MDX Formula.

9.      Click Apply to apply the exception.

Selecting Members

Use the Member Selection button to open the selection dialog box.

The dimension dropdown at the top lists the dimensions on the grid. Select a dimension.

You can use the Filter  button to search for members. To filter the search to a specific level of the dimension, click the Search in Level  button. From the menu that opens, select the level.

Then, perform the search.

To return the search to all levels, select All Levels in the menu. Selecting Reset All Dimensions returns the search in all the dimensions to All Levels.

Select the members you want and click OK. The selected members will appear in the members list box.