Hyperion Essbase (MOSC)

MOSC Banner

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

edited Jan 17, 2023 7:41PM in Hyperion Essbase (MOSC) 2 commentsAnswered ✓

Hello,

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

 A validation error was received from the Planning server.

'Error:The CALC command [IF] can only be used within a CALC Member Block Rule DGAGL.DGAGL.DGAGL.SCRIPT.01.Controler_Level0'

Can someone please give some suggestions ?

   IF( NOT ( @ISLEV("Entity",0)) )

        @RETURN(@CONCATENATE(@CONCATENATE(@CONCATENATE(@CONCATENATE("Cannot select (",@ALIAS(@CURRMBR("Entity"))),"). Select Entity. | selected group ("),@ALIAS(@CURRMBR("Entity"))),"). Please select a specific entity."),ERROR);

     ELSEIF( NOT ( @ISLEV("Niveau",0)) )

        @RETURN(@CONCATENATE(@CONCATENATE(@CONCATENATE(@CONCATENATE("Cannot select (",@ALIAS(@CURRMBR("Niveau"))),"). Select Entity. | selected group ("),@ALIAS(@CURRMBR("Niveau"))),"). Please select a specific level."),ERROR);

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