Hyperion Essbase (MOSC)

MOSC Banner

@PRIOR Essbase function calculates only one period after each save instead of the 12 periods at once

Dears, this is my essbase code

SET CALCPARALLEL 4;

SET AGGMISSG OFF;

SET UPDATECALC OFF;

SET CACHE HIGH;

SET LOCKBLOCK HIGH;

SET CREATENONMISSINGBLK ON;

FIX (&BudYr, &CurrVersion) 

  FIX ("Plan", "No Department", "No Intercompany", "No Project", "No Detail") 

    FIX (@RELATIVE("YearTotal", 0)) 

      {Entity} (

        IF (@ISMBR("Jan")) 

          "Beginning Cash" = "Net Cash Flow"->"TQF"->"Dec"->&CurrYr;

        ELSE 

      "Beginning Cash" = @PRIOR("Net Cash Flow");

        ENDIF

      ) 

    ENDFIX 

  ENDFIX 

ENDFIX


But instead of calculating the beginning cash for the 12 periods at once , I have to save the data form (which runs the rule) 12 times as it calculates each period separately after each run !!

is there any solution?

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