NOW() TM1 Function: Syntax and Use
The now() function returns a value corresponding with the number of days from either 1 January 1960 or 1 January 1900. It’s the same as the Excel now() function.
The now() function returns a value corresponding with the number of days from either 1 January 1960 or 1 January 1900. It’s the same as the Excel now() function.
I got a “cell type is real” error this afternoon and was somewhat confounded! “cell type is real” was in the TM1 error log when I after I ran a TI process
How to use indents to layout Rules and Turbo Integrator processes in TM1 so they are easier to read.
So I just added my first ever Feeder in TM1. Woah, that was confusing. But I’ll get over it and it worked first go! Let me explain. I have a
NUMBR Function for use in Rules and TI Processes in TM1 and Planning Analytics to convert a string of text to a value in the same way the Value function works in an Excel formula. Fully explained with examples.
ELISANC Function for use in Rules and TI Processes in TM1 and Planning Analytics to test if one element is an ancestor of another. In other words, if one element is higher in a hierarchy than another element.
The DB rule function in TM1 and Planning Analytics to retrieve the contents (either text or numeric) of a specific intersection of a cube. Similar to CellGetS or CellGetN in a TI process.
ATTRS Function for use in Rules and Turbo Integrator Processes in TM1 and Planning Analytics to retrieve the value of a string attribute.
I have been battling with opening Performance Modeler for a couple of weeks where I would start the application, get the “log on as” screen, put my details in (that
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.
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
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
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.
The purpose of this article is to describe how to add a Local/Group Currency system to a new TM1 cube; this can be core requirement for International Companies and is
Conditional feeders can be used to minimise the save time and storage impact of feeders. This post goes through the various ways to utilise conditional feeders and workaround to issues that can arise implementing them.
© 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