Tag Archives: TM1 Cube Rules

Back to Basics – Regions in Rules

If there is one basic technical best practise which makes TM1 Solutions more straight-forward thus sustainable which is most often not utilised it is #Regions in cube rules. Regions work the same way as grouping rows within Microsoft Excel, except the grouping is done automatically around a set of key words. This is actually a feature in many scripting environments and is called code folding, it is added to a rule like so: #Region *The title … Continue Reading

This entry was posted in Code Sample - Downloadable, Cognos Express, Cognos Insight, IBM Cognos TM1, TM1 10.1, TM1 pre 10.1, Training Material and tagged Code Folding, Cube Rules, IBM Cognos Express, IBM Cognos TM1, Region, Sales Calculations, TM1 Best Practise, TM1 Cube Rules, TM1 Development. Bookmark the permalink. | Tagged Code Folding, Cube Rules, IBM Cognos Express, IBM Cognos TM1, Region, Sales Calculations, TM1 Best Practise, TM1 Cube Rules, TM1 Development | Leave a comment

Rolling Forecast in IBM Cognos TM1

Recently, a client has asked to implement a rolling forecast model to move towards a more dynamic way of forecasting so as the periods move forward so does your forecast so you are always forecasting 12 / 18 months out in to the future. With a rolling forecast the number of periods remain the same so as each period is traded it drops out of the forecast and another period … Continue Reading

This entry was posted in Code Sample - Downloadable, Cognos Express, IBM Cognos TM1, Training Material and tagged Corporate Planning, Forecasting in TM1, IBM Cognos TM1, Rolling Forecasts, TM1 Cube Rules. Bookmark the permalink. | Tagged Corporate Planning, Forecasting in TM1, IBM Cognos TM1, Rolling Forecasts, TM1 Cube Rules | 1 Comment

3 Types of Rules TM1 Developers should know

We’ve gone through our notes for training our staff and aside from basic equation rules we have listed three classes of common rules which TM1 Developers should be familiar with. If you haven’t ever had to write one of these rules before, you should try it – it would be good practice, because we’ve all seen [‘Sales $’] = N: [‘Units’] * [‘Price’] example far too many times! I’ve boiled … Continue Reading

This entry was posted in IBM Cognos TM1 and tagged Allocation, Developer, IBM Cognos TM1, Phasing, TM1 Consultants, TM1 Cube Rules. Bookmark the permalink. | Tagged Allocation, Developer, IBM Cognos TM1, Phasing, TM1 Consultants, TM1 Cube Rules | 4 Comments