Selecting Attribute Members

This task assumes that you followed the steps in Defining Report Layout.

  To display attribute dimension members in the spreadsheet report:

  1. Select an attribute dimension, for example, Caffeinated, under Page, Row, or Column dimension in the navigation panel to view the member select panel.

  2. In Members, select a member, 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.

    The member is added to the Selection Rules list box and is displayed under the dimension in the navigation panel. If the member is a row or column dimension, go on to the next step; otherwise, stop here because you can define only one member per page dimension.

  3. Optional: To apply member filtering, select the attribute in Selection Rules.

    You cannot apply member filtering to page dimensions.

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

  5. In Method, select one option:

    • Pattern Matches enables you to select members based on matching a text string. Pattern matching supports the single character wildcard symbol, ?, and trailing asterisk wildcard symbol, *. Examples of valid wildcard strings are J?n and 100*. Invalid wildcard strings are *-10 and *10*.

    • Generation Name enables you to select members based on generation name.

    • Level Name enables you to select members based on level name.

  6. Select a comparison operator from Operator.

  7. Select a value in Value. If you are doing a pattern match, enter the string to match.

Next, you can preview the results or apply the query now.

Related Topics

Applying Member Filtering Rules

Applying Multiple Member Filters

Deleting Member Selection Rules

Displaying Aliases

Searching for Members

Selecting Query Members

Setting the Maximum Number of Members to Preview

Specifying Latest Period of Time Dimensions

Suppressing Shared Members

Using Attributes to Select Base Dimension Members

Using Operators with Non-Numeric Attributes

Viewing Member Information