Tag Archives: Cognos BI

Setting Dimension Order for a TM1 Cube

Dimension order within cubes in TM1 is important not only for performance, but also for usability. When should you set the order for usability and when for performance? And how do you optimise the dimension order for performance? All these questions and more are addressed in this post from ExploringTM1.

This entry was posted in Cognos BI, Cubes, Dimensions, Performance and tagged Cognos BI, dimension order, dimensions, perfomance, TM1 Performance. Bookmark the permalink. | Tagged Cognos BI, dimension order, dimensions, perfomance, TM1 Performance | 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

How to use TM1 Attributes in Report Studio

TM1 best practice guides recommend using codes for creating hierarchies and using names as aliases. With TM1 it is also very common to work with various other attributes. But when you create a package with framework manager you can choose what alias you want to show in reports. So you normally use the name as default to show up in reports. But what if someone asks you to show in … Continue Reading

This entry was posted in Cognos BI, IBM Cognos TM1 and tagged Attribute, Cognos BI, Cognos Business Workspace Advanced, Cognos Report Studio, Report Authoring, Set Filter, TM1 Attribute. Bookmark the permalink. | Tagged Attribute, Cognos BI, Cognos Business Workspace Advanced, Cognos Report Studio, Report Authoring, Set Filter, TM1 Attribute | Leave a comment

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