Hyperion Essbase (MOSC)

MOSC Banner

Block Creation taking longer

edited Mar 13, 2019 3:19PM in Hyperion Essbase (MOSC) 4 commentsAnswered

Hello All,

I have a calculation script in essbase where I am trying to create blocks . the below calculation takes 4 mins to run

Current scenario

SET UPDATECALC OFF;

SET AGGMISSG ON;

SET EMPTYMEMBERSETS ON;

/*SET FRMLRTDYNAMIC OFF;*/

SET CACHE HIGH;

FIX( 1 dense member (acc), period(dense), @DESCEndants(sparse dim 1 = 1 member)

FIX(@DESCEndants(sparse dim 1 = 10 member) @DESCEndants(sparse dim 1 = 50 member) @DESCEndants(sparse dim 1 = 500 member))

FIXparallel ("sparse" = 200 member)

"sparse member"

if conditions

@createblock(sparse)

Change : With the below change the calcukation takes 30 mins or more. I understand that there are more members to create blocks but this seems to take a lot longer than expected.

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