Hyperion Essbase (MOSC)

MOSC Banner

Fix statement in an IF condition: Error: 1012061 The CALC command [IF] can only be used within a CAL

edited Sep 12, 2019 3:28PM in Hyperion Essbase (MOSC) 3 commentsAnswered

Hello,

Below is my calculation script and when I try to validate it, I am getting

Error: 1012061 The CALC command [IF] can only be used within a CALC Member Block

I know I cannot use a FIX inside an IF statement.

Can someone please give some suggestions ?

//ESS_LOCALE English_UnitedStates.Latin1@Binary
SET AGGMISSG ON;
SET LOCKBLOCK HIGH;
SET UPDATECALC OFF;
SET MSG SUMMARY;
SET CALCPARALLEL 6;
SET CALCTASKDIMS 6;

FIX ("Plan","Final","USD","US Common","Working")

IF(&Depreciation_Data_Start_Year==&Depreciation_Data_End_Year)
FIX(&Depreciation_Data_Start_Year,&Depreciation_Data_Start_Month:&Depreciation_Data_End_Month)
AGG("Resource","LegalEntity", "CostCenter","Project");

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center