Order to Restart Cognos and TM1 Servers

What order do I use to restart Cognos BI and TM1 servers in a distributed environment? We are currently doing a project where there is a TM1 server, two Cognos BI application servers and a gateway server. The fundamental approach is to stop people from accessing the environment and then stop the applications themselves. The order to stop and start them is the exact reverse of each other. To stop the … Continue Reading

This entry was posted in Administration, BI Admin, TM1 Admin and tagged restart, Server Restart, services. Bookmark the permalink. | Tagged restart, Server Restart, services | Leave a comment

Using “cmplst” files to find the Exact Version and Fix Pack of TM1 Installed?

Sometimes we need to go further than just knowing the version of TM1 installed. We might need to know, for example, the exact version, fix pack and possibly even interim fix that has been installed. To get this information we need to find the “cmplst” file. Where to find the cmplst files for TM1 The cmplst file (for Component List) is usually found in Program Files/IBM/Cognos/TM1_64/. This file lists all … Continue Reading

This entry was posted in Administration, TM1 Admin and tagged cmplst, version. Bookmark the permalink. | Tagged cmplst, version | 1 Comment

How to Determine the TM1 Perspectives Version Installed

Finding out the version of TM1 Perspectives is easy. TM1 Perspectives is an Excel Addin that gives great functionality for using TM1 information in Excel to create forms and reports that refresh automatically with the latest data from TM1. Here is what you need to do to determine what version of Perspectives you have installed: Navigate to the Program Files/TM1/bin folder. Find the file tm1prc.dll (for Perspectives). Right click on … Continue Reading

This entry was posted in Administration, Perspectives, TM1 Admin and tagged TM1 Perspectives, version. Bookmark the permalink. | Tagged TM1 Perspectives, version | 1 Comment

How to Determine the TM1 Version Installed on a Server

We are often asked how do I know what version of TM1 I am using? Well here is how you determine the TM1 version you have installed on a server (if you are looking for the version of TM1 Perspectives, follow this link). So here is the method to find out what version of TM1 you have installed on your server: Go to your TM1 installation directory. This is usually Program … Continue Reading

This entry was posted in TM1 Admin and tagged TM1 Server, version. Bookmark the permalink. | Tagged TM1 Server, version | 2 Comments

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

Integrating TM1 with Cognos Workspace

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

This entry was posted in Administration, BI Admin, Cognos BI and tagged Atom, Cognos Workspace. Bookmark the permalink. | Tagged Atom, Cognos Workspace | 1 Comment

TM1/Cognos Security Integration Gremlin

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

This entry was posted in Administration, Cognos BI, Errors, Security, TM1 Admin and tagged active directory, Cognos, Security. Bookmark the permalink. | Tagged active directory, Cognos, Security | Leave a comment

How to Rename a TM1 Model

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

This entry was posted in Cognos BI, TM1 Administration and tagged Cognos, Cognos TM1, IBM Cognos, TM1 Server, Windows Service. Bookmark the permalink. | Tagged Cognos, Cognos TM1, IBM Cognos, TM1 Server, Windows Service | Leave a comment

How do Delete a TM1 Service

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.

This entry was posted in TM1 Administration and tagged NT Service, TM1 Server, Windows Service. Bookmark the permalink. | Tagged NT Service, TM1 Server, Windows Service | 1 Comment

What is Skipcheck in TM1?

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

This entry was posted in Feeders, Rule Functions and tagged skipcheck. Bookmark the permalink. | Tagged skipcheck | 1 Comment