Defining Member Subset Selections

  To define a member subset selection:

  1. Right-click a dimension member in the Dimension Browser, and select Select Subset.

    The Subset dialog box is displayed. At the top, it indicates dimension members against which the rule is applied. Use the Individual Selection Rule control to compose a rule by selecting components from drop-down lists.

  2. Select a subset type: UDA, Generation, Level, Expression, or Attribute.

  3. Select an operand for the subset rule: is (=) or is not (not equal).

  4. Select a value for the subset rule from the last drop-down list.

  5. Click Add to augment the Total Subset Definition.

    You must add the individual rule to the Total Subset Definition for it to be used. You can define compound and conditional rules by adding multiple rules to the definition, and using Advanced options to connect them:

    Advanced Subset Option

    Sub menu

    Description

    Add

    		 

    Add the current rule to the Total Subset Definition.

    Update

    		 

    Replace the selected rule with the current rule.

    Validate

    		 

    Verifies the parenthetical syntax of the Total Subset Definition.

    Remove

    		 

    Remove the current rule from the Total Subset Definition.

    Remove All

    		 

    Remove all rules from the Total Subset Definition.

    Connect

    And

    Inserts the AND operand at the end of the currently selected rule. The AND operand is used by default when multiple rules are added to the Definition.

     

    Or

    Inserts the OR operand at the end of the currently selected rule.

    Move

    Move Up

    Moves up the currently selected rule in the Total Subset Definition.

     

    Move Down

    Move the currently selected rule down in the Total Subset Definition.

    Parenthesis

    Add (

    Inserts an open parenthesis at the beginning of the currently selected rule.

     

    Add )

    Inserts a close parenthesis at the end of the currently selected rule, but before an operand.

     

    Remove (

    Deletes the open parenthesis from the beginning of the currently selected rule.

     

    Remove )

    Deletes the close parenthesis from the end of the currently selected rule.

     

    Remove All ()

    Removes all parentheses from the Total Subset Definition.

    Substitution Variable

    		 

    Presents the Substitution Variable dialog box, enabling you to select a pre-defined substitution variable for the subset rule value.

  6. Optional: To compose a compound subset definition, repeat steps 3 through 6, and click Add to augment the Total Subset Definition.

  7. Click OK to finish your subset selection and return to Dimension Browser.