Category Archives: Feeders
How, in TM1/Planning Analytics, to feed from a consolidated element in one cube to a leaf element in another cube using a single consolidation feeder with a worked example.
Persistent Feeders can dramatically decrease the time required to restart a TM1 model. Here is an explanation of what Persistent Feeders are and instructions on how to implement them in your TM1 model.
Overfeeding is where TM1 feeders are targetting more cells than are required. This can lead to excess memory consumption and reduce performance. Here we explain over feeding and how to avoid it.
Skipcheck in TM1 forces the TM1 engine to “skip the checking” of empty cells in a cube. So if you had 30 days in a month and data in only 9 of them, only 9 cells would be aggregated to get the total for the month. With the the skipping of blank cells disabled, all 30 cells would be checked to get the month total – three times more inefficient. … Continue Reading
In the rules for many cubes we work with there are conditional feeders. These often cause us problems where the evaluated value changes from a zero to a non-zero value and the fed cell does not get initiated and therefore the rule does not calculate. Background on Feeders As you would undoubtedly be aware, TM1 is an in memory application and extremely efficient with utilising that memory. It is also … Continue Reading
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 … Continue Reading
Conditional feeders can be used to minimize the storage impact of rule feeders. The typical situation occurs when rule values are calculated by multiplying factors, any of which may be zero. This means that the value should be fed only when all the factors are non-zero. Example Given a cube SalesBySalesperson with dimensions: Salesperson, Product, Month, Measures (‘Sales’ and ‘Commissions’) If you calculate Commissions based on Sales using a commission … Continue Reading