Hyperion Essbase (MOSC)

MOSC Banner

The @PRIOR ISSUE

edited Jun 22, 2012 12:44AM in Hyperion Essbase (MOSC) 3 commentsAnswered
Maybe some can help with the @PRIOR command. Please explain why it does not work.  Examples below.

This way works with no @PRIOR

FIX("Jan":"Dec","FY12","Budget","Dollars","Input","System","0000","000","UHC")

"12310" ( ; 

IF(@ISMBR("FY12", "UHC") ) ;
       "12310"= "42000" -> "FY11";  <--------------- This works.
ENDIF
) ;
ENDFIX

================================================================

This one does not work using @PRIOR.

FIX("Jan":"Dec","FY12","Budget","Dollars","Input","System","0000","000","UHC")

"12310" ( ; 

IF(@ISMBR("FY12", "UHC") ) ;
       "12310"= @PRIOR("42000", 1, "Year") ; <--------------This will not work.
ENDIF
) ;
ENDFIX


Thanks 
TC

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