1. Working with Oracle Smart View for Office
  2. Dimensions and Members
  3. Filtering by Attribute

Filtering by Attribute

In an ad hoc grid, you can filter by attributes in dimensions that contain attribute members.

Data source types: Oracle Analytics Cloud - Essbase, Oracle Planning and Budgeting Cloud Ad Hoc, Oracle Financial Consolidation and Close Cloud Ad Hoc

To filter by attribute:

  1. Select an attribute dimension on the grid, and then open Member Selection as described in Selecting Members from the Member Selector.
  2. Click Member Selection View button and select Attribute.
  3. From Attribute, click Select Attribute button.
  4. From Subset, in Dimension, select a dimension; for example, Ounces.
  5. In Member, select an attribute member, for example, Ounces_16.
  6. Click Add button to display the attribute.
  7. Optional: to change the displayed attribute, change the selections in Dimension and Attribute and click Set.
  8. Click OK.

    Your selections are displayed in the tree list in Member Selection, where you can select from among them for inclusion in the grid.