Tag Archives: Cube Rules
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
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
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
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.