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
One of the really cool features of the integration between TM1 and Cognos is the ability to import views of Perspectives worksheets from TM1 into Cognos BI where they can then be used for both analyses and for write-back. Imagine you had a simple variance analysis TM1 Perspectives form. GL accounts, Actuals for this month and last month, variance calculations for both value and percentage and an explanation column for … Continue Reading
Weird. That’s all I can say. We have been doing a significant project with complex calculations done in TM1 and a front end with Cognos BI reports. We now have the integration working perfectly with TM1 cubes performing brilliantly in BI, TM1 cubes able to have data entered into them from Cognos Workspace and security integrated from multiple AD servers via Cognos groups and roles to both Cognos and TM1. Integrated … Continue Reading
Renaming a TM1 model is relatively easy. To change the name of a TM1 model (or instance or server name) do the following: Open tm1s.cfg for the model concerned. Find “ServerName” Edit the value after the equals sign to reflect the new model name Save tm1s.cfg Open Cognos Configuration for TM1 Change the name of the TM1 Server Save Cognos Configuration Start the TM1 Server (right click, start) in Cognos Configuration … Continue Reading
How to delete a redundant TM1 service from Windows. Sometimes we need to delete a TM1 service. After changing the name for a TM1 model, for example, we may be left with a Windows Service still existing for the old model. This explains how to remove a redundant TM1 server.
Skipcheck in TM1 forces the TM1 engine to “skip the checking” of empty cells in a cube. So if you had 30 days in a month and data in only 9 of them, only 9 cells would be aggregated to get the total for the month. With the the skipping of blank cells disabled, all 30 cells would be checked to get the month total – three times more inefficient. … Continue Reading
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
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
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
Using Picklists in TM1 is a great way of ensuring data quality. We explain different types of pick lists, why you use & how to create each type of pick list so you can have in cell drop downs active inside TM1.