SET SCAPERSPECTIVE

The SET SCAPERSPECTIVE calculation command for Essbase sets the perspective for varying attribute calculations.

Syntax

SET SCAPERSPECTIVE (mbrName1) [, (mbrName2)] ... [,(mbrNamen)]) on Attribute_Dimension 
| OFF ;

Parameters

mbrName1 [,...] on Attribute_Dimension

Any valid single member name, or list of member names, on the specified varying attribute dimension.

OFF

Turn off the perspective setting for the calculation block.

Notes

• For use only in applications enabled with varying attributes.

• Only one independent member from each independent dimension is supported.

Example

Once the perspective is specified using this command, @WITHATTR can be used on a varying attribute inside a FIX statement. In the following example, the SET SCAPERSPECTIVE statements indicate that for attribute dimensions TYPE and TITLE, the subsequent FIX statement with @WithATTR will use their attribute association as defined at time FY03 and Jan.

set SCAPerspective ((FY03), (Jan)) on TYPE;
set SCAPerspective ((FY03), (Jan)) on TITLE;

FIX (@WithAttr (TYPE, "==", Contractor), @withattr (Title, "==", Senior_QA_Engineer), Local, "HSP_Historical", "BU Version_1", Target, Local, FY03)
HSP_INPUTVALUE = 100;
ENDFIX;

@ISATTRIBUTE

@ISMBRWITHATTR

@WITHATTR