This task assumes that you followed the steps in Defining Report Layout.
To display attribute dimension members in the spreadsheet report:
Select an attribute dimension, for example, Caffeinated, under Page, Row, or Column dimension in the navigation panel to view the member select panel.
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.
Optional: To apply member filtering, select the attribute in Selection Rules.
To display the member filter panel, right-click and select New Member Filter.
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.
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.
Applying Member Filtering Rules
Applying Multiple Member Filters
Deleting Member Selection Rules
Setting the Maximum Number of Members to Preview
Specifying Latest Period of Time Dimensions
Using Attributes to Select Base Dimension Members