Tag Archives: Cube Rules

Finding the Rules Editor in Cognos Insight

I was tasked to draft up something on Cognos Insight.  Without going through the Cognos Insight user guide, I have got stuck when trying to link data between cubes.  “How I do edit rules in Insight?”, I asked. Until I have got a reply from a colleague, “Look for the widget toolbars!”. Have you ever been wondering why there are so very few menu options on the main toolbar in … Continue Reading

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

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

3 Types of Rules TM1 Developers Should Know

In this blog we discuss how to do three different rules, all that should be in your TM1 kitbag. These include Allocation/Phase Rule, Rolling Value Rule and Averaging Rule (C Level). There is full explanations and the code used for the rule examples.