Specifying Member Perspective

Use the Varying Attribute filter to specify member perspective for varying attributes when selecting members.

Cloud data source types: Oracle Essbase

On-premises data source types: Oracle Essbase

Note:

Member perspective may not be enabled in your Oracle Smart View for Office system. Your options for member perspective are enabled and configured by the Administrator.

To specify member perspective:

  1. From Member Selection, under Filter, select Varying Attribute.
  2. In Filter Arguments, click Attribute button.
  3. Specify an attribute to set the perspective, and then click OK.
  4. In Varying Attribute Args under Varying Attribute, click the ellipsis button.
  5. In Subset, in Dimension, enter an attribute dimension.
  6. In Member, enter an attribute member, and then click Set.
  7. Click OK.
  8. In Varying Attribute Args, under Perspective, click the ellipsis button.
  9. From Perspective, select one of the following:
    • Snapshot. One set of independent dimension members to identify the members of base dimension associated with the varying attribute. Here the start and end tuple are same.

    • Range. A finite range of independent dimension members. A range can be specified only for continuous independent dimensions ("Year" is an example). For discrete independent dimensions, you can make only one selection.

  10. Click OK.