Show/Hide Only definitions are applied differently for each methodology used:
Show/Hide Only Calculations shows or hides all calculated members.
Show/Hide Only Members shows or hides dimension members of the dimension header right-clicked in the document.
Show/Hide Only Values shows or hides dimension members on the axis opposite the dimension header right-clicked in the document.
Show/Hide Only Colors shows or hides dimension members on the axis opposite the dimension header right-clicked in the document.
Show/Hide Only definitions are created in the Show/Hide Only dialog box:
Control | Description |
|---|---|
Select Method | Show - Displays only items satisfying the Show/Hide Only definition criteria. Hide - Hides only items satisfying the Show/Hide Only definition criteria. |
Where | |
Calculations | Shows or Hides all calculated members. |
Member | Bases the Show/Hide Only definition on specified dimension members of the current axis. |
Values | Tests whether members of the opposite axis contain values satisfying criteria of the current axis. |
All Values | Tests whether all members of the opposite axis contain values satisfying criteria of the current axis. |
Colors | Tests whether members of the opposite axis contain colors satisfying criteria of the current axis. |
All Colors | Tests whether all members of the opposite axis contain colors satisfying criteria of the current axis. |
Set Condition | |
Operator drop-down list | Select an operator for your criteria: Greater than (>), Greater Than or Equal To (>=), Equal to (=), Less Than or Equal To (<=), Less Than (<), Not Equal To (<>). |
Value Text box | Enables you to enter the value for Show/Hide Only Values conditions. |
Color | Opens the Select Color dialog box to set the condition color. |
Members | Lists available dimension members and attributes to which the Show/Hide Only definition is applied. |
Advanced | Aggregates or separates dimension member combinations. |
Apply | Applies the definition to the document. |