TM1 Forum

Hi I am new to Tm1 and have been having an issue with the feeders in my balance sheet cube. I need to December YTD balance to feed into my Jan Opening balance. The feeders seem to be working for some of my balance sheet line items but not all of them. when i right click on the empty line items it says they aren't being fed. As of now the rule is:

['Manual Input',{'Guidance','Plan'},'Opening Balance'] = N:
IF (NUMBR( !conYear) > 2011
,
IF( !conMonth @= 'Opening Balance'
,
DB('bsPlan',!conBSCompany,'Balance',!conScenario,!bsLineItems, SUBST(DB('}conMonthInfo',!conYear,'Jan','PrevPeriod'),5,4) ,'Dec YTD')
,
CONTINUE
)
,
STET
) ;

['Automated Input',{'Guidance','Plan'} , 'Opening Balance'] = N: 0;

(SUBST(DB('}conMonthInfo',!conYear,'Jan','PrevPeriod'),5,4 is just a referance to a control cube to get the previous year)

and the feeder I have build to go along with this rule is as follows:

['Balance','Plan','Dec YTD'] =>
DB('bsPlan',!conBSCompany,'Manual Input','Plan',!bsLineItems,
SUBST( DB('}conMonthInfo',!conYear,'Jan','NextPeriod'),5,4) ,
'Opening Balance');

['Balance','Guidance','Dec YTD'] =>
DB('bsPlan',!conBSCompany,'Manual Input','Guidance',!bsLineItems,
SUBST( DB('}conMonthInfo',!conYear,'Jan','NextPeriod'),5,4) ,
'Opening Balance');

I can give more information any help would be greatly appreciated!

Hi
Make sure you unload your cube before you move on and keep in mind that the feeders that are set now could come from a previous version of your feeder statements. It could be one of the reasons that some cells are fed and some not. The other reason could be that you have changed values in your control or lookup without re-saving the rule. My number one guess on what your problem might be is the nature of how you carry forward 'Balance' into 'Manual Input'.

Unless Opening Balance is an element in several dimensions I would try this.
Create two attributes on the !conYear dimension, 'Next year' and 'Previous Year'. This is just for simplification, as the next and previous year is not really related to a month for this purpose, and to eliminate anything around your '}' cube. Make sure you populate the attributes for all years in the dimension. What I would do though is have a 'control year' in a 'control' cube (no '}') to be able to replace the hard coded year in your rule (unless maybe this really never changes), it is just good practice to try and avoided hard coded years/numbers in rules.

SKIPCHECK;
['Manual Input',{'Guidance','Plan'},'Opening Balance'] = N:
IF (NUMBR( !conYear) > 2011,
DB('bsPlan',!conBSCompany,'Balance',!conScenario,!bsLineItems, ATTRS(!conYear,'Previous Year'),'Dec YTD')
,STET);

FEEDERS;
['Balance',{'Guidance','Plan'},'Dec YTD'] =>
DB('bsPlan',!conBSCompany,'Manual Input',!conScenario,!bsLineItems, ATTRS(!conYear,'Next Year'), 'Opening Balance');

['Manual Input',{'Guidance','Plan'},'Dec YTD'] =>
DB('bsPlan',!conBSCompany,!dimname,!conScenario,!bsLineItems, ATTRS(!conYear,'Next Year'), 'Opening Balance');

As you probably don't have 'Balance' as data or fed calculated cell in 2012 the feeder you wrote won't fire in subsequent years. The second feeder should take care of this.
The !dimname could also just be 'Manual Input'. Obviously it would be advisable to limit the years accordingly in your feeder with a condition as well but I won't complicate things for now.

Cheers

Thank you for the reply

The rule and feeder are actually referancing the previous year with SUBST(DB('}conMonthInfo',!conYear,'Jan','PrevPeriod'),5,4). That is a control cube where the value in PrevPeriod attribute for Jan 2012 is 'Dec-2011' and then it is saying start with the 5th character and use the next four characters as my value.

That being said I updated my feeders to the following:

['Balance',{'Guidance','Plan'},'Dec YTD'] =>
DB('bsPlan',!conBSCompany,'Manual Input','Guidance',!bsLineItems,
SUBST( DB('}conMonthInfo',!conYear,'Jan','NextPeriod'),5,4) ,
'Opening Balance');

['Manual Input',{'Guidance','Plan'},''Dec YTD'] =>
DB('bsPlan',!conBSCompany,'bsbook','Guidance',!bsLineItems,
SUBST( DB('}conMonthInfo',!conYear,'Jan','NextPeriod'),5,4) ,
'Opening Balance');

['Automated Input',{'Guidance','Plan'},''Dec YTD'] =>
DB('bsPlan',!conBSCompany,'bsbook','Guidance',!bsLineItems,
SUBST( DB('}conMonthInfo',!conYear,'Jan','NextPeriod'),5,4) ,
'Opening Balance');

['Adjustment',{'Guidance','Plan'},''Dec YTD'] =>
DB('bsPlan',!conBSCompany,'bsbook','Guidance',!bsLineItems,
SUBST( DB('}conMonthInfo',!conYear,'Jan','NextPeriod'),5,4) ,
'Opening Balance');

I am still having the same issue with some of the elements not being fed. Manual Input, Automated input, and adjustment are all children of balance if that helps at all. I also have unloaded the cube and re-started my server without any success. Could it have anything to do with the fact that I am trying to rule a value that is consolidated twice (both in the month and book dim) to a N-level element? Any other suggestions would be helpful greatly appreciated!

I was aware how you are referencing the prev and next year it just seems easier with a simple attribute an maybe not as confusing.... more below

Which of the elements are consolidations is key information.
e.g. what is 'bsbook' ?

Please note that the 'error checking' on the right hand side on a feeder won't throw an error if is 'bsbook' is not an element in the (seemingly) second dimension in your cube. Is bsbook actually the dimension name and you meant to feed !bsbook? Or is it a consolidation in the second dimension?

With what you have you are only feeding 'Guidance' so your calc on 'Plan' would not be fed at all. You would need a !conScenario on the RHS for it to feed from 'Guidance' to 'Guidance' and 'Plan' to 'Plan'.

With what I know

['Balance',{'Guidance','Plan'},'Dec YTD'] =>
DB('bsPlan',!conBSCompany,'Manual Input',!conScenario,!bsLineItems,
SUBST( DB('}conMonthInfo',!conYear,'Jan','NextPeriod'),5,4) ,
'Opening Balance');

should actually do the job, given that DB('}conMonthInfo',!conYear,'Jan','NextPeriod') for !conYear '2011' returns something like 'mmm-2012' which logically it wouldn't.
With your way of doing it in the control cube wouldn't you logically use DB('}conMonthInfo',!conYear,'Dec','NextPeriod') and that would store the string 'Jan-2012'?

Also you have two single quotes in front of YTD Dec. Not sure whether that is a typo. Does it actually compile like that?