Tag Archives: performance

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

Multi Threaded Queries (MTQ)

Much Faster Processing with MTQ in TM1 TM1 traditionally uses a single core or thread per task.  What this means is that when a user opens a view for a cube (or a TI or Cognos BI opens a view), that view is created by a single core. Recently IBM changed TM1 so that it now can use multi threaded queries and it is almost a linear improvement in performance, roughly … Continue Reading

This entry was posted in Performance, TM1 Administration and tagged MTQ, multi threaded queries, performance. Bookmark the permalink. | Tagged MTQ, multi threaded queries, performance | 1 Comment