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

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

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

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

This entry was posted in Attributes, Cubes, Dimensions, MDX and tagged Picklists, TM1. Bookmark the permalink. | Tagged Picklists, TM1 | Leave a comment

The definitive guide to TM1 security. How to configure different ways of managing security in TM1 with examples and screenshots that you can follow.

| 5 Comments

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.

This entry was posted in Code Sample - Downloadable, Cognos Express, IBM Cognos TM1, TM1 10.1, TM1 10.2, Training Material and tagged Datasource, ODBO, TM1, Turbo Integrator. Bookmark the permalink. | Tagged Datasource, ODBO, TM1, Turbo Integrator | 3 Comments

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

This entry was posted in SPSS and tagged Analytics, Cognos BI, Forecast Revenues, IBM SPSS Modeler, Predictive, SPSS, Time Series, Time Series Forecast, TM1. Bookmark the permalink. | Tagged Analytics, Cognos BI, Forecast Revenues, IBM SPSS Modeler, Predictive, SPSS, Time Series, Time Series Forecast, TM1 | Leave a comment

The Infocube 10 Point TM1 Health-Check: Part 2

This is Part 2 of the Infocube TM1 Health Check.

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged Health Check, TM1. Bookmark the permalink. | Tagged Health Check, TM1 | 1 Comment

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.

This entry was posted in Cognos Express, IBM Cognos TM1 and tagged Health Check, TM1. Bookmark the permalink. | Tagged Health Check, TM1 | 1 Comment

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

This entry was posted in Code Sample - Downloadable, Cognos Express, Cognos Insight, IBM Cognos TM1, TM1 10.1, TM1 pre 10.1 and tagged ABS, ASCIIOUTPUT, Code Sample, DataSourceAsciiQuoteCharacter, FILL, IBM Cognos TM1, Journal, LONG, NUMBERTOSTRING, TEXTOUTPUT, TM1, TRIM, Turbo Integrator. Bookmark the permalink. | Tagged ABS, ASCIIOUTPUT, Code Sample, DataSourceAsciiQuoteCharacter, FILL, IBM Cognos TM1, Journal, LONG, NUMBERTOSTRING, TEXTOUTPUT, TM1, TRIM, Turbo Integrator | Leave a comment

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

This entry was posted in Cognos Express, Cognos Insight, TM1 10.1 and tagged Cognos Insight, Monte Carlo simulation, TM1. Bookmark the permalink. | Tagged Cognos Insight, Monte Carlo simulation, TM1 | 2 Comments