TM1’s security can be as simple or as complex as you need. We tend to start with the broadest possible definition of security and then refine it down to the
Simple method for cutting down the calculation overhead of TM1 rules for a multi year forecasting model by limiting rule scope.
Accumulating values in TM1 over multiple years. Cumulative values are very useful in a rolling forecast or cash flow calculation model. This shows in detail how to create a cumulative values with colour coded examples.
‘@= is used in TM1 for evaluation of operators in TM1 Rules and TI Processes. Here we explain how it is used and give examples for both rules and processes.
How to create a planning model where users can enter or select variables in one location and TM1 then assigns the data dynamically to all required dimensions. For example, in a budgeting model to plan labour centrally and assign people to cost centres dynamically.
Here we explain how to calculate the number of days in each month with a simple, but easy rule, using the DAYNO function and a Next Month attribute.
A simple solution to enabling and disabling rules for different versions (or scenarios) using either an attribute on the Version dimension or a simple cube, intersecting the }Cube and Version dimensions.
Simple foreign exchange conversion method for use in TM1. Convert multiple currencies to multiple currencies easily using a simple FX rates cube and lookup of a cost centre or entity.
Today I wanted to update a rule so that the processing of the rule was limited only to those scenarios that are “active”. I could have gone through each line in the
Accumulating values in TM1 over multiple years. Cumulative values are very useful in a rolling forecast or cash flow calculation model. This shows in detail how to create a cumulative values with colour coded examples.
Ever wondered why some TM1 rules have empty square brackets (like this [ ] )? Well MafiaMan just explained it to me. Really simple, but also extraordinarily powerful. What it means is
I have been trying to work out how to make rule driven links between two cubes work properly today. One key thing that I have learnt from the Guru is
The TM1 Advanced Rules Editor colour codes different sections of TM1 rules and generally makes editing rules much easier. Here is how to enable the TM1 Advanced Rules editor.
Recently, a client has asked to implement a rolling forecast model to move towards a more dynamic way of forecasting. With this as periods move forward so does your forecast.
Here we discuss how to do three rules, all that should be in your TM1 kitbag. These include Allocation/Phase Rule, Rolling Value Rule and Averaging Rule (C Level). There are full explanations and the code used for the rule examples.
© Copyright Exploring TM1 Pty Ltd | All rights reserved. | Privacy Policy | ABN: 98 122 867 976
© Copyright Exploring TM1 Pty Ltd | All rights reserved. | Privacy Policy | ABN: 98 122 867 976
