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
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;