Hyperion Essbase (MOSC)

MOSC Banner

Calc Script: FIX statement @RELATIVE("Projects",0) does not include newly created members without ma

edited Sep 28, 2011 12:37PM in Hyperion Essbase (MOSC) 2 commentsAnswered
Hi all,

I have a problem with the FIX statement in calculation scripts.

In my calc script I have the following FIX statement:

FIX(
     @RELATIVE("BusinessUnit",0),
     "Group View",
     "Calculation",
     @RELATIVE("Scenario",0),
     @RELATIVE("Projects",0)
      @RELATIVE("Time",0)
   )

Within this Fix a calculation of measures should be done.

The whole script works perfectly -

BUT if i create a new (Level 0) member in the outline (for example a new "Projects"-member) the calculation will not be done for this member.

I tried to delete the @RELATIVE("Projects",0) statement - saved - executed.

After that i retyped the statement and it also worked. It seems like the Fix has the level 0 Projects members somehow in cache or whatever and must be refreshed. There must be any possibility that a calc script knows automatically if there are new members which should be within the fix.

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