TM1 Forum

Hi,

I have looked at other posts re feeding rules and tried to follow some of the solutions but cannot seem to make one fit my problem. Apologies if a solution to my problem has already been posted and I've just misinterpreted it.

My Problem:

I have 2 cubes:

1. A forecast cube with a measures dimension which holds Total Cost; Months; Month %'s (so no time dimensions as such).
2. A phasing % cube by month

The phasing % cube calculates the monthly % of the total cost of a project based on whatever forecast curve you choose and what time frame you choose the project to be over (you choose the start and end date and the monthly % will get calculated accordingly.

The forecast cube has a rule that populates the Month %'s within the measures dim with the monthly % phasing (from the %phasing cube). The Months in the measures dim then multiplies the total cost of teh project by the monthly % to get a month £ cost.

All of this is currently working and I'm happy with the results.

However, the Month %'s in the forecast cube are not fed. The rule in the forecast cube is:

['Estimate to Complete']=N:
IF(DB('Forecast Cube','Estimate to Complete',!PAAR_AFE,!T3,!Vendor,!PO_No,'Profile Name')@='MANUAL COST',CONTINUE,
IF(ELISCOMP('Forecast_Measures',!Forecast_Measures,'Total Phasing')=0,
CONTINUE,
IF(SUBST(DB('Forecast Cube','Estimate to Complete',!PAAR_AFE,!T3,!Vendor,!PO_No,'Profile Name'),1,6)
@='MANUAL %',STET,
DB('T3 Vendor PO Phasing %','Estimate to Complete','Phasing %',!PAAR_AFE,!T3,!Vendor,!PO_No,ATTRS('Forecast_Measures',!Forecast_Measures,'Months')))));

The Month %'s of the measures dim in the forecast cube are getting populated in this rule by taking the Month from the % phasing cube and matching it to the "Month" attribute of the measures dim in the forecast cube.

The rule in the %Phasing curve to feed is:

FEEDERS;
['Phasing %']=>
DB('Forecast Cube','Estimate to Complete',!PAAR_AFE,!T3,!Vendor,!PO_No,'Total Phasing');

This doesn't work. 'Total Phasing' in the feeder statement above is a consolidation of all month %'s in the measures dim of the forecast cube (the % phasing cube does not have this dim in it - it has a time dim instead). I was hoping that this would feed all of the n levels of this c level.

I have also tried this:

FEEDERS;
['Phasing %']=>
DB('Forecast Cube','Estimate to Complete',!PAAR_AFE,!T3,!Vendor,!PO_No,!Time);

Here the !Time dim is the dim in the % Phasing cube so I was hoping all matching elements would feed. But then I think this would only feed the Months that match as opposed to the Month % attribute "Month".

I have also tried this:

FEEDERS;
['Phasing %']=>
DB('Forecast Cube','Estimate to Complete',!PAAR_AFE,!T3,!Vendor,!PO_No,ATTRS('Tullow_Measures',!Tullow_Measures,'Months'));

Which doesn't work at all! I was hoping here that I could directly feed the attribute. It may just be that I have written the rule incorrectly - or it may be that I am attempting to do something in-appropriate!

Any advice would be welcomed.

Many thanks.

Hi There,

I'm guessing your going to have to look a variable feeder based on your rule. If you search for variable feeders on the site you should find what you need. If your still having trouble please reply again and I'm sure somebody on the forum will be able to help you further,

Jim.