Hyperion Essbase (MOSC)

MOSC Banner

FIX equivalent of using crossdimensional operators

edited Sep 12, 2018 4:15AM in Hyperion Essbase (MOSC) 3 commentsAnswered

Hi all,

This is doubt I have always had and now I'm facing a situation where doing this would be very useful.

As you know, you cannot use a crossdim in a FIX, like

FIX (mbrDim1->mbrDim2)

Calcs;

ENDFIX

So what can be used as a workaround instead?

My current calc goes like:

FIX(Scenario1, Scenario2, Version1, Version2)

Large calcs here;

ENDFIX

But the data I want to calculate resides in Scenario1->Version1 and in Scenario2->Version2. Any other combination must be kept out of the calc. The only solution I can see is

FIX(Scenario1, Version1)

Tagged:

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