Hyperion Planning (MOSC)

MOSC Banner

CLEARBLOCK Syntax error

edited Jul 13, 2019 6:30AM in Hyperion Planning (MOSC) 4 commentsAnswered ✓

Hello Guys,

I am using CLEARBLOCK to clear block and data but I am getting syntax error:

Code:

SET CACHE High;
SET UPDATECALC OFF;
SET CALCPARALLEL 6;
SET LOCKBLOCK HIGH;
SET AGGMISSG OFF;

FIX("FY19")

CLEARBLOCK "CurrentSubmission";


ENDFIX;

Error:

[Thu Jul 11 15:23:34 2019]Local/DETBUD/Plan1/KUMARH@UNHCRLOCAL/139901266417408/Error(1012001)
Invalid Calc Script syntax [

CLEARBLOCK]

[Thu Jul 11 15:23:34 2019]Local/DETBUD/Plan1/KUMARH@UNHCRLOCAL/139901266417408/Error(1200421)
Error encountered on or after line [11]

[Thu Jul 11 15:23:34 2019]Local/DETBUD/Plan1/KUMARH@UNHCRLOCAL/139901266417408/Warning(1080014)
Transaction [ 0xe024c( 0x5d273856.0xe7823 ) ] aborted due to status [1012001].

where "FY19" and "CurrentSubmission" are sparse dimension level 0 members.

It is working fine with CLEARDATA but not for CLEARBLOCK . I tried with all dimension in FIX statement instead of one (FY19) as above.

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