PERSPECTIVE

Sets the perspective, a tuple or REALITY, for a varying attribute dimension for a report.

Syntax

<PERSPECTIVE(tuple, attrDim)

Parameter	Description
tuple	(m1, m2, ..., mX) \| REALITY This is 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.

Parameter

Description

tuple

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

This is 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)