Creating Show/Hide Only Definitions

  To create a Show/Hide Only definition:

1. Right-click a dimension member header and select Analysis Tools, then Show/Hide Only.

   The Show/Hide Only dialog box is displayed.

2. From Select Method, select Show or Hide.

3. Define one option:

   • To show or hide only calculated members, click the Where group Calculations option.

   • To show or hide specified members, click the Where group Members option and select dimension members from Members.

   • To show or hide only dimension members if dimension member value satisfies a condition, perform these actions:

     1. Click the Where group Values option.

     2. Select dimension members from Members.

     3. Use the operator list and the value area to define a condition.

   • To show or hide only dimension members when all dimension member values satisfy a condition, perform these actions:

     1. Click the Where group All Values option.

     2. Select dimension members from Members.

     3. Use the operator list and the value area to define a condition.

   • To show or hide only dimension members if dimension member value satisfies a traffic lighting color condition, perform these actions:

     1. Click the Where group Colors option.

     2. Select dimension members from Members.

     3. From the operator list, select Equal To (=) or Not Equal To (<>).

     4. Click Color. The Select Color dialog box is displayed. Select one defined traffic lighting range color. The color displays in the large square. Click OK. The button displays the selected color.

   • To show or hide only dimension members if all dimension member values satisfy a traffic lighting color condition, perform these actions:

     1. Click the Where group All Colors option.

     2. Select dimension members from Members.

     3. From the operator list, select Equal To (=) or Not Equal To (<>).

     4. Click Color. The Select Color dialog box is displayed. Select one defined traffic lighting range color. The color displays in the large square. Click OK. The button displays the selected color.

        Note:

        Show/Hide Only Members is applied to the named dimension member, and Show/Hide Only Values and Show/Hide Only Colors is applied to the opposite axis, using the values in the selected axis.

        Color options are only enabled when the data object features an active traffic lighting definition. An Advanced option specifies conditions for dimension member combinations. Apply enables you to apply the definition to the current data object, without exiting the dialog box. Drag the dialog box title bar to see the data object underneath.

4. Click OK.

   The current definition is added to the Analysis Tools Manager.

5. Click Close.