Hyperion Planning (MOSC)

MOSC Banner

Need to optimize the calc script

edited Oct 6, 2019 5:00AM in Hyperion Planning (MOSC) 3 commentsAnswered

Hello,

We have one clear calculation script which causes application abnormally shutdown and further causes illegal block header in database.

We checked the calc script and found that dense members Accounts and Begbalance using in FIX statement , ideally we should not use dense member in FIX statement (Dense member resides in every data block and while calculation, every block will come into memory , which can crash the database).

Please find below calc script:

SET CACHE High;

SET UPDATECALC OFF;

SET CALCPARALLEL 6;

SET LOCKBLOCK HIGH;

SET AGGMISSG OFF;

SET RUNTIMESUBVARS

{

yrname= "FY17";};

FIX( &yrname)

FIX("BegBalance", @IDESCENDANTS("Account"),  "TARGETOP", @IDESCENDANTS("CostCenter")

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