@ismbr turning into circular reference
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";
"Beginning Bal";
ELSEIF (@ISMBR("FEB"))
"Ending Balance" ->"JAN";
"Ending Balance" ->"JAN";
0