Using Attributes to Select Base Dimension Members

  To display the base dimension members associated with an attribute in the spreadsheet report:

1. Under the Row or Column dimension in the navigation panel, select a dimension with which attributes are associated, for example, the Product dimension, to display the member select panel.

2. In Members, select a member.

3. Right-click and select Add to Selection Rules. Alternatively, you can double-click a member or drag the member to add it to the selection.

4. Select a member in Selection Rules.

5. To display the member filter panel, right-click and select New Member Filter.

6. Select an attribute in Method.

7. Select a comparison operator in Operator.

   The choices in the Operator list box change depending on the type of attribute on which you want to filter. Attributes can be one of four types: text, numeric, Boolean, and date.

   The choices for Boolean attribute types are is and is not.

   • is includes members that meet the criteria set in Value. For example, Caffeinated is Caffeinated_True includes all members in the Product base dimension that are caffeinated.

   • is not excludes members that meet the criteria set in Value. For example, Caffeinated is not Caffeinated_True excludes all members in the Product base dimension that are caffeinated.

     The choices for text, numeric and date attribute types are =, !=, <, >, <=, and >=.

   • = returns all members that equals the value. For example, Intro Date = 03_25_1996 includes all products with introduction dates of March 25, 1996.

   • != returns all members that do not equal the value. For example, Intro Date != 03_25_96 includes only products with introduction dates other than March 25, 1996.

   • < returns all members less than the value. For example, Intro Date < 03_25_1996 includes all products introduced before, but not including, March 25, 1996.

   • > returns all members greater than the value. For example, Intro Date > 03_25_1996 includes all products introduced after, but not including, March 25, 1996.

   • <= returns all members less than and equal to the value. For example, Intro Date <= 03_25_1996 includes all products introduced before and including March 25, 1996.

   • >= returns all members greater than and equal to the value. For example, Intro Date >= 03_25_1996 includes all products introduced after and including March 25, 1996.

8. Select from the available values in Value.