Cascading Picklists in TM1 are a great way to limit long lists from being displayed to users for selection. Here we explain exactly how to create them.
Have you ever needed to calculate the value “as at” a point in time? For example, you have an inventory cube and want to show the volume of stock at
Need to get a primary element name from an alias in a TM1 Excel report or TM1 Rule? Simple solution for deriving an element principal name in Rules or Excel.
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.
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.
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.
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.
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.
Explanation and Example of “AND” and “OR” Operators in IF statements in TM1 Rules.
Forcing TM1 to reprocess Feeders using CubeProcessFeeders on a cube with Conditional Feeders in a TI process. Why used, Syntax and Examples.
How do you derive an element ID from an alias or attribute in TM1?
IF Function for use in Rules in TM1 and Planning Analytics, full syntax and examples of how to use nesting and alternative to nesting in Rules
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
Every wondered how to comment out a Rule or Turbo Integrator process in TM1? Well today I needed a method of commenting out text from a rule and, although I
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.
Using STET and CONTINUE in TM1 rules to indicate if the rule sheet should continue to execute for the current intersection. This is really useful to place at the top of the rules to limit what intersections are calculated.
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
Here is a downloadable Notepad++ language file for TM1 and Plannign Analytics. Use it to view syntax of TM1 Rules and Turbo Integrator processes in Notepad++.
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
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
