Category Archives: Turbo Integrator

Using the DimensionCreate Function to Create a Dimension in TM1

To create a dimension in a TM1 model use the DimensionCreate function in Turbo Integrator processes. Combine with IF and DimensionExists.

This entry was posted in Dimensions, TI Functions and tagged Dimension, DimensionCreate, DimensionExists, IF, TI Process, Turbo Integrator. Bookmark the permalink. | Tagged Dimension, DimensionCreate, DimensionExists, IF, TI Process, Turbo Integrator | Leave a comment

Checking if a DimensionExists in a TM1 Model

To check if a dimension already exists in a TM1 model use the DimensionExists function in Turbo Integrator processes. Combine with IF and DimensionCreate.

This entry was posted in Dimensions, TI Functions and tagged Dimension, DimensionCreate, DimensionExists, IF, TI Process, Turbo Integrator. Bookmark the permalink. | Tagged Dimension, DimensionCreate, DimensionExists, IF, TI Process, Turbo Integrator | Leave a comment

“Joining” Text Files in a TM1 Turbo Integrator Process

How do you join text files in a TI when loading into TM1? In this post we discuss a method to emulate an SQL join in a TI where a csv or text file is the source for the Turbo Integrator process.

This entry was posted in Attributes, Data Connection, TI Data Sources, TI Processes and tagged Attribute, Dimension, TI Process, Turbo Integrator. Bookmark the permalink. | Tagged Attribute, Dimension, TI Process, Turbo Integrator | Leave a comment

Data Export Tool Review – Flyspeed

Ever needed to create a text file from a data source and you have no tools available to interrogate it? We are doing a cloud Planning Analytics project for a client where they are using an ERP called Finance Plus over a database called Visual Foxpro. Mmmm, I hear you read – why is this relevant for me? Well, Visual Foxpro is a very close relative of dBase – a … Continue Reading

This entry was posted in Data Connection, Planning Analytics, TI Data Sources and tagged ETL, TI Process, Turbo Integrator, TurboIntegrator. Bookmark the permalink. | Tagged ETL, TI Process, Turbo Integrator, TurboIntegrator | Leave a comment

How to Create a Secure Gateway for Planning Analytics

There are a couple of elements that must be established to make the secure gateway work. There are server side and local side requirements. This post deals with what has to be done on the IBM server so you can connect it to your local data. For instructions on establishing the local side of the connection, please see this post. Server Side Configuration In the Welcome Kit from IBM, there is a … Continue Reading

This entry was posted in Data Connection, Planning Analytics, TI Data Sources and tagged data connectivity, secure gateway. Bookmark the permalink. | Tagged data connectivity, secure gateway | Leave a comment

AsciiOutput with Pipe Delimiter

Yesterday I needed to export some data from TM1 for loading into SQL Server. I know I can connect directly and publish from TM1 to SQL Server, but I just wanted to use the simple method – create a text file and load it up. Problem with Comma Separated Values My problem was that some of the columns contained text that had random commas, so a regular AsciiOutput wouldn’t work … Continue Reading

This entry was posted in TI Coding and tagged ASCIIOUTPUT, delimiter, SQL Server. Bookmark the permalink. | Tagged ASCIIOUTPUT, delimiter, SQL Server | Leave a comment

AttrDelete TM1 Function: Syntax and Use

To delete an attribute in TM1 or Cognos Express during the execution of a Turbo Integrator process we use the AttrDelete function. Syntax of AttrDelete The syntax is: AttrDelete ( DimName, AttrName); where: DimName – is the name of the dimension that you want to delete an attribute AttrName – is the name of the new attribute you are deleting Example DimName = ‘Employees’; AttrDelete ( DimName, ‘Status’ ); Here we have defined a variable called DimName … Continue Reading

This entry was posted in TI Functions and tagged AttrDelete. Bookmark the permalink. | Tagged AttrDelete | 1 Comment

AttrInsert TM1 Function: Use and Sytax

Sometimes we want to create a new attribute in TM1 dynamically during the execution of a TI process. This function allows us to do that and create either a string, a numeric or an alias attribute. Syntax of AttrInsert The syntax is: AttrInsert ( DimName, PrevAttr, AttrName, Type ); where: DimName – is the name of the dimension that you want to create an attribute on PrevAttr – is the name … Continue Reading

This entry was posted in TI Functions and tagged AttrInsert. Bookmark the permalink. | Tagged AttrInsert | 1 Comment

Concatenating Data in TM1 – How to Concatenate Variables in a TI or Rule

I was asked the other day how to concatenate some information in TM1. Joining two text fields is really easy!  Just use the pipe ( ” | ” ) between two variables and they will joined into one. There is nothing like the Excel Concatenate function in TM1. How to Concatenate Let’s say you have variable 1, sVariable1 = ‘Exploring’; and sVariable2 = ‘TM1’; then using sOutput = sVariable1 | sVariable2; will … Continue Reading

This entry was posted in Rule Functions, TI Functions and tagged concatenate, concatenation. Bookmark the permalink. | Tagged concatenate, concatenation | Leave a comment

CubeProcessFeeders – Forcing TM1 to Reprocess Feeders

In the rules for many cubes we work with there are conditional feeders. These often cause us problems where the evaluated value changes from a zero to a non-zero value and the fed cell does not get initiated and therefore the rule does not calculate. Background on Feeders As you would undoubtedly be aware, TM1 is an in memory application and extremely efficient with utilising that memory. It is also … Continue Reading

This entry was posted in Feeders, Rule Examples, TI Functions and tagged Conditional Feeders, cubeprocessfeeders, Feeders, Rules. Bookmark the permalink. | Tagged Conditional Feeders, cubeprocessfeeders, Feeders, Rules | Leave a comment