Cognos Analytics and TM1

Here is a selection of our blog posts on using Cognos Analytics (Cognos BI) over the top of TM1 cubes. Now for over ten years, IBM has owned Cognos and TM1 and only now we are finally getting the integration to a reasonable level. We discuss everything from defining levels and default elements in TM1 for use in Cognos, through the use of aliases and attributes from TM1 in Cognos,  some of the settings to et Cognos to perform when TM1 is the data source and what order you should restart all the Cognos and TM1 servers in your stack.

01.

Attributes | Cognos Analytics | Dimensions | Reporting

Display TM1 Attributes in Cognos Analytics Crosstab

Here is how to create a Cognos Analytics Crosstab and use the contents of a TM1 Attribute for the...

johnv Vaughan

3 min read

Read

02.

Administration | Cognos Analytics | Integration | Reporting | TM1 Management

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...

johnv Vaughan

2 min read

Read

03.

Administration | Cognos Analytics | Integration | Reporting | TM1 Management

Tuning Cognos BI and TM1 for Maximum Performance

Cognos Business Intelligence and TM1 now work well together, however performance can be...

johnv Vaughan

2 min read

Read

04.

Administration | Cognos Analytics | Integration | Reporting | TM1 Management

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...

johnv Vaughan

2 min read

Read

05.

Administration | Cognos Analytics | Integration | Reporting | TM1 Management

Restart Order for Cognos and TM1 Servers

Here is the order to restart a combined Cognos Analytics and TM1 environment to ensure all...

johnv Vaughan

2 min read

Read

06.

Administration | Cognos Analytics | Installation / Configuration | Integration | Reporting

Integrating TM1 with Cognos Workspace

One of the really cool features of the integration between TM1 and Cognos is the ability to import...

johnv Vaughan

5 min read

Read

07.

Cognos Analytics | Reporting

Automatically Add Formatting to a Cognos Report on a TM1 Cube

So I have my TM1 cube successfully published to Cognos BI.  I have the sort order defined so that...

johnv Vaughan

2 min read

Read

08.

Cognos Analytics | Reporting

Sort Order of a TM1 Dimension in Cognos BI

This morning I have been working with Cognos BI over a TM1 cube.  I was frustrated that I...

johnv Vaughan

2 min read

Read

09.

Administration | Cognos Analytics | Integration | Reporting

Using TM1 Aliases in Cognos BI

Often we build a TM1 dimension using codes or ID’s from another system.  For example Product...

johnv Vaughan

1 min read

Read

10.

Administration | Cognos Analytics | Integration | Reporting

Setting Default Element and Level Names in TM1 for use in Cognos BI

How to set the default member and set level names for a TM1 dimension to be used in Cognos...

johnv Vaughan

2 min read

Read

11.

Attributes | Cognos Analytics | Dimensions | Reporting

How to use TM1 Attributes in Report Studio

TM1 best practice guides recommend using codes for creating hierarchies and using names as aliases....

johnv Vaughan

2 min read

Read