First TM1 Feeder!

So I just added my first ever Feeder in TM1.  Woah, that was confusing.  But I’ll get over it and it worked first go!  Let me explain.

I have a cube, Opex, that is to be used in a rolling forecast model for forecasting Operating Expenses.  I have a Scenario dimension with Actual and Current Forecast in it (amongst others).  I have a TI script that is loading Actual values from a very highly detailed cube into this planning cube. There is a System Assumptions cube where current month and year are defined.

I then created a rule that sets the value of Current Forecast to be the same as Actual where the period is less than the current month.  Thus if we are in September, then I want all previous periods to show the Actual value.  The rule was correct, but I was showing no values in Current Forecast.  Then a light bulb moment.  I had a SKIPCHECK inserted at the start of the rule.  I understood that the purpose of a Feeder is to open up cells in a cube (by default the cells are not available for use in calculations and need Feeders to open them up – thus maintaining memory efficiency and speed in TM1).

So I created a Feeder.  I stated on the left side the area of the cube that did have data (ie Actual) and on the right the area that I wanted to have data (Current Forecast) and limited it to my measure.  Thus my feeder was simply:

[‘Actual’,’Amount’] => [‘Current Forecast’,’Amount’];

And bingo. It worked. My first ever Feeder!

If you like this post, please spread the love…

About John

Managing Director of Infocube. We are a management accounting consultancy that specialises in Business Analytics.
This entry was posted in Feeders. Bookmark the permalink.