TM1 Forum

Posted: **Wed Jul 28, 2010 12:00 pm**

Hi all,
I'm still new to the rules aspect of TM1, so excuse my ignorance..
I need some help with the logic and writing of rules. I'm busy working on a forecast model, where a tool is used to generate a forecast, and then pulled into Tm1.
Then using Excel the users input their view of the forecast, this is where the problem comes in, they want to do it "bottom up", and "top down". So in some cases they want to input at a consolidated level on some of the dimensions.
I.e. a customer group (C) for all brands (C) on all warehouses (C) and for Wholesalers (N).

Using DBS functions I send their input to unspecified elements in the specific dimensions, where it is a consolidation and not a n-level element.
As far as i know, what has to happen is; I have to work out how much (%) is the users forecast to the total, and then split if according to the forecast that was generated by the tool.

So my question is:
1) What does the rule look like to do this?
2) Will it work for different variations of consolidations and elements?

Your help is greatly appreciated!!

Posted: **Wed Jul 28, 2010 5:12 pm**

Have you thought about using any of the Spreading (like Proportional, Equal etc)?

Posted: **Wed Jul 28, 2010 5:28 pm**

I have, and I tried it out in Excel, but it didn't work exactly as I wanted.
And they want it as "Idiot Proof" as possible, so the user should just input his forecast and TM1 has to do the rest from there. I suggested to them to do it in a view but they want it all in Excel.

Posted: **Wed Jul 28, 2010 5:52 pm**

I got it right!!!!

Code: Select all

SKIPCHECK;

['Forecast','Split']=C:['Forecast','Unspecified_Warehouse','Unspecified_Week','Unspecified_Division','Unspecified_Channel','Marketing']/              
   ## these will be the ones that are consolidated - set them to unspecified
           ['FCP Forecast','All Warehouses','Weeks','All Divisions','All Channels','Statistical Forecast']                                                                       ## devided by the total for the consolidations
	*['FCP Forecast','Statistical Forecast'];                                                                                                                                        ## multiplied by what the tool generated

FEEDERS;
['Forecast','All Months','All Warehouses','All Brands','All Segmentations','All Regions','Years','Weeks','All Items','All Divisions','All Channels','Customer']=>
	['Forecast','WH Split'];
['FCP Forecast','Statistical Forecast']=>
	['Forecast','WH Split'];

And this works out for all the levels of the hierarchy what is the contribution to the total and splits the input accordingly.

TM1 Forum

Rules

Rules

Re: Rules

Re: Rules

Re: Rules