Tag Archives: TM1

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

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

The Pick List – How to Create and Use Picklists in TM1

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.

Transfering Data between TM1 Servers using ODBO (i.e. Without CSV’s)

This blog shows the steps needed to establish an ODBO connection in order to  transfer data between 2 cubes in different server instances.

How to use SPSS Modeler and Time Series Algorithms to Forecast Revenues

A planning exercise typically involves a batch of spreadsheets, which probably look chaotic and consumes a lot of time to maintain. A much better, more efficient and optimised option is to use specialised software for this work, like TM1. Using TM1, speeds up the process considerably and the planning process is a lot more efficient. But still you have to rely to some arbitrary decisions regarding next years budget, like … Continue Reading

The Infocube 10 Point TM1 Health-Check: Part 2

This is Part 2 of the Infocube TM1 Health Check.

The Infocube 10 Point TM1 Health-Check: Part 1

Part 1 of the Infocube 10 point guide for giving your TM1 environment a Heath Check. A must read for any TM1 administrator.

Fixed Width File Format from TM1

When outputting data from TM1 usually we can get away with comma separated values format. Which is standard functionality from a Turbo Integrator process [See ASCIIOutput, TextOutput functions]. Every now and then we need to interface with a ERP system which requires Fixes Width Fields. This presents a few problems, not insurmountable but still not expressly easy either. The tips below will make things easier for you. ASCII Quote Character Options To start your extract process … Continue Reading

Monte Carlo simulation with TM1

A bit about Vangelis: Hi, I am Vangelis, I am from Greece and now I live in Sydney Australia. Currently, I’m working as a consultant at Infocube Consulting. I have expertise in IBM Cognos products, BI and TM1 and also in mathematics and statistics. My academic background consists of a BSc in Mathematics, MSc in Finance & Banking, MSc in Information & Telecommunications Technologies and a couple of certifications on … Continue Reading

Removing old TM1 Servers from "Services"

When upgrading a clients environment to IBM Cognos TM1 10.1 I noticed a bunch of older TM1 Services. A quick google reveals that you can remove services by using the following command line: sc delete “Service Name” Note: If you have a TM1 Service setup as: “TM1 Server x64 / Production Server” you will use the following command sc delete “Production Server” Is it about time you cleaned up the … Continue Reading

/* THIS WAS THE CODE USED FOR EMBEDDING A SURVEYMONKEY POPUP */