Hyperion Essbase (MOSC)

MOSC Banner

@ismbr turning into circular reference

edited Apr 16, 2012 6:41AM in Hyperion Essbase (MOSC) 1 commentAnswered
essbase circular reference
in excel it's time consuming to update but doable in essbase its turned into a circular reference even when I try breaking up the process
 
Beginning Bal member takes original data for 2011 Jan
for formula member Beginning Balance to pick up
 
Measures
    Reconciliations   
        Beginning Bal (data is loaded for Jan 2011)
        Beginning Balance formula member
        Total payments
            Payments(+)
            Payment Adjustments(+)
        Total Accruals
           Accruals (+)
           Accrual Adjustments(+)
        Total Payments & Accruals formula member (Total payments + Total Accruals) 
        Ending Balance formula member("Beginning Balance"+ "Total Payments & Accruals")
 
Beginning balance formula
 
IF (@ISMBR("FY 2011") and @ISMBR("JAN"))
     "Beginning Bal";
 
 ELSEIF (@ISMBR("FEB"))
    "Ending Balance" ->"JAN";

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