TM1 Forum

I need some assistance with creating the Feeder for the Daily Avg cube for the following rule. Any assistance will greatly appreciated.

['Target', 'Major Mat Pos']=N:DB('Daily Avg','Target', ATTRS('Days',!Days,'Month'),SUBST(ATTRS('Days',!Days,'M/DD'),4,2),!Units,'Major Mat Pos','Daily Avg');

Here are the feeders that I have tried.

#-----------Feeders for the Maintenance Cost Prediction Summary Cube --------------#
['Estimate','Jan', '01','Distribution','Daily Avg'] => DB('Maintenance Cost Prediction Summary','Estimate','2011',!Units,'01','Distributed Costs (from Target Sheet)');

['Estimate','Distribution','Daily Avg'] => DB('Maintenance Cost Prediction Summary','Estimate','2011',!Units,'01','Distributed Costs (from Target Sheet)');

Thanks in advance.

Could you post the dimensionality (in order) of all involved cubes and also state the rule that gets the 'Daily Avg' from the 'Maintenance Cost Prediction Summary Cube'?

Gregor Koch wrote:Could you post the dimensionality (in order) of all involved cubes and also state the rule that gets the 'Daily Avg' from the 'Maintenance Cost Prediction Summary Cube'?

Here is the rule that the 'Maintenance Cost Predict Summary Cube' uses to gets the 'Daily Avg'.

dfrench77 wrote:['Target', 'Major Mat Pos']=N:DB('Daily Avg','Target', ATTRS('Days',!Days,'Month'),SUBST(ATTRS('Days',!Days,'M/DD'),4,2),!Units,'Major Mat Pos','Daily Avg');

Here is the dimensionality (in order) of the cubes involved.

Daily Avg cube
Versions, Months, # of Days, Units, Data Entry, Employee Input

Maintenance Cost Prediction Summary
Versions, Years, Units, Days, Daily Cost

Here is the cube rule used to calculate the 'Daily Avg' for Distribution Cost in the 'Daily Avg cube'.
['Distribution','Daily Avg']=N:IF(DIMIX('# of Days',!# of Days) <= DB('Cost # of Days Data Entry',!Data Entry,!Months,!Versions,!Units,'# of days') ,DB('Cost # of Days Data Entry','Distribution',!Months,!Versions,!Units,'Daily Avg'), 0);

Thanks for your assistance.

In your OP you are saying that you want to feed the Rule in the Daily Avg cube

['Target', 'Major Mat Pos']=N:DB('Daily Avg','Target', ATTRS('Days',!Days,'Month'),SUBST(ATTRS('Days',!Days,'M/DD'),4,2),!Units,'Major Mat Pos','Daily Avg');

The Daily Average in the Daily Avg you get from the "Cost # of Days Data Entry" cube.

I would start by feeding the Daily Avg from "Cost # of Days Data Entry".

Yes, that is correct. Here is the feeder that I have tried to feed the 'Daily Avg' cube. However, the Rule Tracer indicates that the 'Daily Avg' is 'not fed'.

['Daily Avg']=>DB('Daily Avg',!Versions,!Months,'1',!Units,!Data Entry,'Daily Avg');

dfrench77 wrote:Yes, that is correct. Here is the feeder that I have tried to feed the 'Daily Avg' cube. However, the Rule Tracer indicates that the 'Daily Avg' is 'not fed'.

['Daily Avg']=>DB('Daily Avg',!Versions,!Months,'1',!Units,!Data Entry,'Daily Avg');

You can't use the value 'Daily Avg' to feed because it isn't raw data, it's the result of a calculation. You have to go back to the element of the Daily Avg calculation that determines whether or not an account actually has an average and feed from that.

Tomok,

Thanks for you guidance. I have modified the feeder based on your guidance and I have gotten results in the Daily Avg cube.

['# of days']=>DB('Daily Avg',!Versions,!Months,'01',!Units,!Data Entry,'Daily Avg');
['# of days']=>DB('Daily Avg',!Versions,!Months,'02',!Units,!Data Entry,'Daily Avg');

However, this feeder will require a separate feeder rule for each day of the month. Is there another way that I should be doing this to feed everyday of the month in one feeder rule?

Substitue 01, 02 etc for a consolidation that holds all the days you wish to feed

Gregor, Tomok, and Steve,

Thanks for all your guidance with the feeders. Once I added a consolidation element to the '# of Days' dimension and used the consolidation in the feeder, the rules were fed properly.

Cheers!