Selecting Members Using Attributes

  To select members using attributes:

1. In Essbase Member Selection, select a dimension containing attributes in Rules.

2. Right-click to display a shortcut menu.

3. Select Subset from the shortcut menu.

4. In Subset, scroll down the left list box and select an attribute.

   For example, in the Product dimension, you can select Caffeinated_True.

   The maximum number of conditions you can set in the Subset dialog box is 50 items.

5. Select NOT if you want the selection to include only the members without the value.

6. Select the value from Subsetting Value, and then click Add as AND Condition.

7. Repeat step 4 and step 5 for each set of criteria, and then click Add as AND Condition or Add as OR Condition.

   • AND—Selection must meet the current criteria and the one before it.

   • OR—Selection must meet the current criteria or the one before it.

   To group two or more subsetting values, select the first value and click Add, and then select the next value and click Add .

   Each item in the Conditions list box can contain the left or right parenthesis, but not both. An error message displays if parentheses are unmatched.

8. To preview the list of criteria you selected to display in the worksheet, click Preview.

9. Click OK.

10. To view the results of the member selection, click OK.