‘@= in TM1: How to Use it in Rules and Processes
‘@= 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.
‘@= 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.
The AttrClear or ClearAttr function doesn’t exist in TM1. Here is an easy method to replicate what functions like these would do, with a downloadable example
Virtual Dimensions in TM1 and Planning Analytics allow you to use Attributes to create additional analytic capability. Here we explain how to create them with code examples.
CubeClearData: TM1 and Planning Analytics command for clearing all data from a TM1 cube without deleting and recreating the cube. It does not give the flexibility of deleting the data from only a slice of a cube.
This is a short and simple post to help you check for null values. There is no direct TI command to check if values being loaded are null or not, but we have come up with two easy checks to search for a string or numeric null value.
Recently I encountered a situation where we had a SaveDataAll process running every half hour that had started impacting the system performance. The environment is largely for enterprise planning and we
How to use TM1 as a source to export to a database such as SQL Server, Oracle or DB2. Use either Direct Connect or Text Output.
Using variables in a TM1 or Planning Analtyics Turbo Integrator process to dynamically vary the path for datasource for both server and client.
Often we have a situation were we want to create a dimension with the contents of a code from a source system. Sometimes, however the IDs in the source system are
ITEMSKUP is a Turbo Integrator function that forces the current record being read from a data source to be skipped. Syntax of ITEMSKIP The syntax is just ITEMSKIP; – real simple
I asked Mafia Man the other day how I can take a backup on the fly of everything in TM1 so that if I make changes and stuff up, I
In TM1 often we want to have a master process which then calls child processes. There is a Turbo Integrator command that allows us to nest TM1 processes. It is
When you first open up a Turbo Integrator script you will notice the text at the top of the Advanced tab tabs with a “#” in front of each line to show
.pro files are a magic little file that is saved in the TM1 data folder (along with dimensions, models, feeders, cubes etc). You can read them with a text editor
It is good practice to create and destroy a view for clearing rather then leaving a large clear view sitting under the cube waiting for a user to click on
© 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