CHECK FEEDERS;

[appleglaze28]

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

Code: Select all

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.

[kpk]

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