Selecting Members Using Analytic Services Subsets

Analytic Services users can define rules that select dimension member subsets by criterion. These rules are composed of the following items:

You can search all selected member descendants using a maximum of 50 subset conditions. Subset criteria are saved by document in the repository. Because the filter panel cannot accommodate lengthy selection lists, subset member selections made in Filters are summarized with a description.

  To define a member subset selection:

  1. In Dimension Browser, right-click a member.

  2. Select Select Subset.

    The Subset dialog box displays. 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.

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

  4. Select an operand: is (=) or is not (not equal).

  5. From the last list, select a value.

  6. Click Add.

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

    Table 17. Advanced Subset Options  

    Option

    Submenu

    Description

    Add

    		 

    Rule added to Total Subset Definition

    Update

    		 

    Rule replaced by another rule

    Validate

    		 

    Parenthetical syntax of Total Subset Definition verified

    Remove

    		 

    Rule deleted from Total Subset Definition

    Remove All

    		 

    All rules deleted from Total Subset Definition

    Connect

    And

    AND inserted at end (AND is used by default when multiple rules are added to the definition.)

     

    Or

    OR inserted at end

    Move

    Move Up

    Rule moved up in Total Subset Definition

     

    Move Down

    Rule moved down in Total Subset Definition

    Parenthesis

    Add (

    Open parenthesis inserted at beginning

     

    Add )

    Close parenthesis inserted at end

     

    Remove (

    Open parenthesis deleted

     

    Remove )

    Close parenthesis deleted

     

    Remove All ()

    All parentheses deleted from Total Subset Definition

    Substitution Variable

    		 

    Substitution Variable dialog box presented, enabling you to select a predefined substitution variable for the rule value

  7. Optional: To compose a compound subset definition, repeat steps 3 through 6.

  8. Click OK.