PERSPECTIVE

The Essbase Report Writer PERSPECTIVE command sets the perspective, a tuple or REALITY, for a varying attribute dimension for a report.

Syntax

<PERSPECTIVE(tuple, attrDim)

Parameters

tuple

(m1, m2, ..., mX) | REALITY

The perspective tuple to be applied for the given attribute dimension.

(m1, m2, ..., mN)

Level-0 members from one or more independent dimensions for attrDim may be part of the input tuple.
REALITY

The REALITY keyword indicates using independent members from the current query-calculation context. When explicit perspectives are missing for an attribute dimension, the default usage for the perspective is REALITY.

attrdim

The varying attribute dimension to which the perspective applies. May be any member from attribute dimension hierarchy.

Notes

Without the use of the perspective command, the default perspective will be used.
The perspective specified for an attribute dimension influences the attribute calculations in the query. The following Report Writer commands involving attributes honor the prevailing perspective:
- <Attribute attMbrName
- <WithAttr(dimName,"operator",value)
Only the first the perspective command in a report is honored. Any other perspective commands are ignored.

Example

<PERSPECTIVE((Jan), Ounces)

<PERSPECTIVE((Jan, California), Ounces)