Category Archives: Turbo Integrator

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

TI Connection Error to Cognos BI Report

We sometimes recommend using a Cognos BI Package and BI report as the source for TM1. We usually do this when we have both TM1 and BI deployed at a client and it just makes sense to prepare the data in Framework Manager so it can then be used by any BI report and by TM1 as well. It especially cuts down reconciliation because if it is right in one … Continue Reading

This entry was posted in Errors, TI Errors, TM1 Admin. Bookmark the permalink. | Leave a comment

ItemReject TM1 Function: Syntax and Use

Sometimes we want to put some text directly into the TM1 Message log to record why something is occurring in a TM1 Turbo Integrator process. This function will place the current record into the TM1 message log along side a custom message. ItemReject Syntax The syntax is simply ItemReject(ErrorString); where ErrorString is the message you want put in the TM1 Message log along side the record. Example and Usage of ItemReject … Continue Reading

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

ViewZeroOut TM1 Function: Syntax and Use

I came across this extremely simple method of just zapping the data from a view in a TM1 cube today, ViewZeroOut literally removes all data from a view. . Syntax The syntax is just ViewZeroOut ( cubename, viewname ); where cubename – is the name of the cube you want to remove data from, and viewname – is the name of the view Example sCube = ‘Assumption’; sView = ‘This Year’; … Continue Reading

This entry was posted in TI Functions, TM1 Admin. Bookmark the permalink. | Leave a comment

TODAY TM1 Function: Syntax and Use

TODAY simply returns the current system date as a string in the form ‘yy-mm-dd’, or if you want, in the format ‘yyyy-mm-dd’. Syntax of TODAY The syntax is Today ( FourDigitYearFlag); where: FourDigitYearFlag – can be either omitted or 0 or 1, where omitted or 0 will return the 2 digit year and a 1 will return a 4 digit year. Example Assuming the current system date is 07 June … Continue Reading

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