How to Feed Consolidated Rolling Balance Rule?

Post Reply
GPC
Posts: 51
Joined: Thu Aug 06, 2009 11:09 pm
OLAP Product: TM1
Version: 10.2.20100.123
Excel Version: 365
Location: Sydney

How to Feed Consolidated Rolling Balance Rule?

Post by GPC » Mon May 29, 2017 3:33 am

Hi All,
I have a rule which calculates balances based on the previous month's balance plus the current month's value. The Cube has 2 time dimensions - Year and Day (with consolidations for months). We have an April to March Financial Year.
The rule works fine but there's something wrong with my feeders as when I zero suppress the view it hides all the Years and Months except for the ones with a month value.

Here are my Rules & Feeders;

['Actual TP LTD','2008','Apr'] = C: 0;
['Actual TP LTD'] = C: IF(ELLEV( 'Year', !Year) >0,Continue,IF(ELLEV( 'Day', !Day ) > 0 & ELISANC('Day', 'Total Day', !Day) = 1 & !Year @<= DB( 'System Info', 'Current Fin Year', 'String' ),
IF(ATTRS('Day',!Day,'MONTH')@='Apr',
DB('Cube',!Version, ATTRS('Year',!Year, 'Prev Year'), 'Mar',!BunchofOther Dims...,'Actual TP LTD')+DB('Cube',!Version,!Year, ATTRS('Day', !Day, 'MONTH'),!BunchofOther Dims...,'Actual TP')
,
DB('Cube,!Version,!Year, ATTRS('Month', ATTRS('Day', !Day, 'MONTH'),'PREV MONTH'),!BunchofOther Dims...,'Actual TP LTD')+DB('Cube',!Version,!Year,ATTRS('Day', !Day, 'MONTH'),!BunchofOther Dims...,'Actual TP')
),Continue));

FEEDERS;
['Actual TP']=> ['Actual TP LTD'];
['Actual TP LTD','Mar']=>DB('Cube',!Version, ATTRS('Year', !Year, 'Next Year'), 'Apr', !BunchofOther Dims...,'Actual TP LTD');
['Actual TP LTD']=>DB('Cube',!Version,!Year, ATTRS('Month', ATTRS('Day', !Day, 'MONTH'), 'Next MONTH'),!BunchofOther Dims...,'Actual TP LTD');

Any ideas?

thanks,

Gregory

Post Reply