TM1 Forum

Posted: **Thu Feb 18, 2010 10:31 am**

How is the check Feeders checked to determine what is not being fed? Cause I'm not sure what I'm not feeding right.

This rule is for retrieving data from another cube and doing further proportional breakdown - worksheet
['Adjusted Unit Price']=N:(((['TOTAL COST']\['TOTAL ITEM NUMBER','TOTAL COST'])*DB('general_so_setting',!base_sales_personnel,!base_so_number,'Total Selling Price'))\['Quantity']);

Code: Select all

This is the rule for the averaging of the value from a cube whose value is taken from another cube - worksheet:
['>>>Adjusted Unit Price Hold Value']=N:['Adjusted Unit Price'];
['>>>Adjusted Unit Price Count']=N: IF(['Adjusted Unit Price']<>0,1,0);

Code: Select all

This is feeders in worksheet cube
FEEDERS;
['>>>Adjusted Unit Price Hold Value']=>['Adjusted Unit Price'];
['>>>Adjusted Unit Price Count']=>['Adjusted Unit Price'];
['Adjusted Unit Price']=>['TOTAL SELLING PRICE'];
['Adjusted Unit Price']=>['>>>Adjusted Unit Price Hold Value'],['>>>Adjusted Unit Price Count'];

This is feeders in general_so_setting
FEEDERS; 
['Total Selling Price']=>DB('worksheet','TOTAL CUSTOMERS','TOTAL','TOTAL ITEM NUMBER',!base_sales_personnel,!base_so_number,'Quantity');

Somebody please help me out...I keep knocking on my brain to figure out where I went wrong, or missed out.

Thanks in advance.

Posted: **Thu Feb 18, 2010 3:08 pm**

Hi,

I do not really understand your business logic but the following 2 lines are strange:
['>>>Adjusted Unit Price Hold Value']=N:['Adjusted Unit Price'];
['>>>Adjusted Unit Price Hold Value']=>['Adjusted Unit Price'];
If '>>>Adjusted Unit Price Hold Value' depends on the 'Adjusted Unit Price' element then the feeder should be:
['Adjusted Unit Price']=>['>>>Adjusted Unit Price Hold Value'];

On the other hand it seems to me that most of your "Price" measures depends on the Quantity so probably it would be better to feed them from that measure:
e.g.: ['Quantity']=>['Adjusted Unit Price'],['>>>Adjusted Unit Price Hold Value'],['>>>Adjusted Unit Price Count'];

Regards,

Peter

TM1 Forum

CHECK FEEDERS;

CHECK FEEDERS;

Re: CHECK FEEDERS;