Hyperion Essbase (MOSC)

MOSC Banner

@CURRMBR() does not work - cache and calclockblock should be ok

edited Sep 28, 2012 12:47AM in Hyperion Essbase (MOSC) 2 commentsAnswered
I have big problems with @CURRMBR() in calcscripts. It takes ages to run or is just not possible.

As this is a key function for several scripts this is a huge problem.

 

I have a simple calc script which works fine and takes about one second.

 

SET UPDATECALC OFF;

SET CLEARUPDATESTATUS OFF;

SET CACHE HIGH;

SET LOCKBLOCK HIGH;

SET CREATENONMISSINGBLK ON;

FIX("Current Month","Scale_1","Segment View","FC_Sep_2012",  @RELATIVE("Time",0), @RELATIVE("Div_S",0),@RELATIVE("Div_I",0),@RELATIVE("Div_O",0),"BU_63")

                "Factor_Value" = "800700s" ->@CURRMBR("Time")  ;

ENDFIX

When I add @CURRMBR()

"Factor_Value" = "800700s";

Becomes

"Factor_Value" = "800700s" ->

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