Tag Archives: TM1
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
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
Picklists in TM1 are a great way for you to ensure that users only “enter” (or in this case select) a value from a standard list of options. For example, you might want a user to enter a three character month like Jan, Feb, Mar etc. You could design your cube to have a text element and then ask users to enter periods in that format. This will work perfectly … Continue Reading
The definitive guide to TM1 security. How to configure different ways of managing security in TM1 with examples and screenshots that you can follow.
This blog shows the steps needed to establish an ODBO connection in order to transfer data between 2 cubes in different server instances.
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
This is Part 2 of the Infocube TM1 Health Check.
Part 1 of the Infocube 10 point guide for giving your TM1 environment a Heath Check. A must read for any TM1 administrator.
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
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