“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

Planning Analytics Supported Environment

We are about to start a new project with a client where they will be using Planning Analytics local (i.e. the new version of on premise TM1). They have asked about the server specifications and what needs to be installed. IBM have a great tool that gives all this information, but it can be very large and unwieldy. This post lists the minimum server requirements for Planning Analytics Local. So … Continue Reading

This entry was posted in Installation, Planning Analytics and tagged Installation, Planning Analytics, Server Configuration. Bookmark the permalink. | Tagged Installation, Planning Analytics, Server Configuration | Leave a comment

Operators in TM1 Rule IF Statements

Explanation and Example of “AND” and “OR” Operators in IF statements in TM1 Rules.

This entry was posted in Rule Examples, Rule Functions and tagged IF, operators, Rules. Bookmark the permalink. | Tagged IF, operators, Rules | 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

Setting the Java Virtual Machine (JVM) in Cognos

There are a few settings in Cognos BI that can dramatically improve performance in Cognos BI when using TM1 as a data source. The first of these is to stop Cognos from using the old Bluenose method of querying TM1 and force it to use the native TM1 engine. The next setting that we need to configure is the Java Virtual Machine, or JVM. Wikipedia defines a Java Virtual Machine … Continue Reading

This entry was posted in Administration, BI Admin, TM1 Admin and tagged 10.2.2, Cognos BI, JVM, performance, TM1. Bookmark the permalink. | Tagged 10.2.2, Cognos BI, JVM, performance, TM1 | 1 Comment

Tuning Cognos BI and TM1 for Maximum Performance

Cognos Business Intelligence and TM1 now work well together, however performance can be dramatically improved by changing the out of the box settings. These tuning changes are not difficult and can significantly enhance both the speed and usability of both tools. How can BI and TM1 be Integrated When used together we can use Framework Manager to prepare data from a database before it is loaded into TM1, we can … Continue Reading

This entry was posted in Administration, BI Admin, TM1 Admin and tagged 10.2.2, Cognos BI, performance, TM1. Bookmark the permalink. | Tagged 10.2.2, Cognos BI, performance, TM1 | 2 Comments

Forcing Cognos BI to Use Native TM1 Engine

There are a few settings in Cognos BI that can dramatically improve performance in Cognos BI when using TM1 as a data source. The first of these is to stop Cognos from using the old Bluenose method of querying TM1 and force it to use the native TM1 engine. Bluenose is the default and it is extremely slow on large queries. Anecdotally it appears to want TM1 to return the … Continue Reading

This entry was posted in Administration, BI Admin, TM1 Admin and tagged Cognos BI, performance, qsUseNativeTM1Engine. Bookmark the permalink. | Tagged Cognos BI, performance, qsUseNativeTM1Engine | 2 Comments

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