TI Functions
We’re the experts in corporate financial management and business analytics you’ve been searching for.
Our team of talented accountants can help you find and use the tools you need to make your budgeting, forecasting analysis and reporting world class.
YEAR Function in TM1: Syntax and Use
The Year function in TM1 extracts a numeric version of the year from a text string that represents a date, where the date has been presented in either YYYY-MM-DD or YY-MM-DD…
How to Create Virtual Dimensions in TM1/Planning Analytics
Virtual Dimensions in TM1 and Planning Analytics allow you to use Attributes to create additional analytic capability. Here we briefly discuss what they are and then what you need to…
DimensionElementDelete Function TM1: Syntax and Use
Here is how to simply delete a single element from a dimension in TM1. Note DimensionElementDelete permanently deletes the element from the TM1 dimension and all associated data from any…
How to Turn Cube Logging On & Off: TM1 CubeSetLogChanges
Ever wanted to disable logging while running a TI process? Well here is a simple function, CubeSetLogChanges, to insert into the TI to turn transaction logging off and then turn…
CreateHierarchyByAttribute Function in TM1: Syntax and Use
We once did a project where we needed to create an excel report showing attributes from the same dimension as the rows and columns in a report. Traditionally in TM1,…
DType Function in TM1: Syntax and Use
One of the team were just writing a TI to load a text file into TM1. It was all working swimmingly until he tried to load a string (a 3…
MONTH Function in TM1: Syntax and Use
The Month function in TM1 extracts a numeric version of month from a text string that represents a date, where the date has been presented in either YYYY-MM-DD or YY-MM-DD format….
Checking if an Attribute Exists (essentially an “AttributeExists” Function)
Have you ever looked for a TM1 function that checks if an attribute exists, something like say “AttributeExists” or “AttrExists”. Well there isn’t one. But, don’t dispair, here is a…
How to Convert a Numeric Date to a String using the DATE Function in TM1
The DATE function in TM1 converts a serial date (or numeric date) to a text version of the date in either YYYY-MM-DD or YY-MM-DD format. This is the opposite of…
Date and Time Functions for Easy Date Manipulation
There were three Date and Time formatting functions released with TM1 10.2. These allow you to easily manipulate dates within a TI. Let’s take a closer look at these new…
Need help with TM1?
We're here for you
Keen to chat? Book a discovery call!