Category Archives: Cognos BI

Integrating TM1 with Cognos Workspace

One of the really cool features of the integration between TM1 and Cognos is the ability to import views of Perspectives worksheets from TM1 into Cognos BI where they can then be used for both analyses and for write-back. Imagine you had a simple variance analysis TM1 Perspectives form. GL accounts, Actuals for this month and last month, variance calculations for both value and percentage and an explanation column for … Continue Reading

This entry was posted in Administration, BI Admin, Cognos BI and tagged Atom, Cognos Workspace. Bookmark the permalink. | Tagged Atom, Cognos Workspace | 1 Comment

TM1/Cognos Security Integration Gremlin

Weird. That’s all I can say. We have been doing a significant project with complex calculations done in TM1 and a front end with Cognos BI reports. We now have the integration working perfectly with TM1 cubes performing brilliantly in BI, TM1 cubes able to have data entered into them from Cognos Workspace and security integrated from multiple AD servers via Cognos groups and roles to both Cognos and TM1. Integrated … Continue Reading

This entry was posted in Administration, Cognos BI, Errors, Security, TM1 Admin and tagged active directory, Cognos, Security. Bookmark the permalink. | Tagged active directory, Cognos, Security | Leave a comment

How to Rename a TM1 Model

Renaming a TM1 model is relatively easy. To change the name of a TM1 model (or instance or server name) do the following: Open tm1s.cfg for the model concerned. Find “ServerName” Edit the value after the equals sign to reflect the new model name Save tm1s.cfg Open Cognos Configuration for TM1 Change the name of the TM1 Server Save Cognos Configuration Start the TM1 Server (right click, start) in Cognos Configuration … Continue Reading

This entry was posted in Cognos BI, TM1 Administration and tagged Cognos, Cognos TM1, IBM Cognos, TM1 Server, Windows Service. Bookmark the permalink. | Tagged Cognos, Cognos TM1, IBM Cognos, TM1 Server, Windows Service | Leave a comment

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 I have my elements of my PnL appearing in the right order.  All good.  Now I look at the resulting report and there is no formatting of different elements.  Simple formatting like a single line above subtotals and a double underline below the grand total.  What accountants really want in a … Continue Reading

This entry was posted in Cognos BI. Bookmark the permalink. | Leave a comment

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 couldn’t work out how to sort a dimension the way I wanted it.  For example, in TM1 I have a PnL dimension and is viewed normally with Net Profit after Tax at the bottom, Tax Expense just up from it, Net Profit before Tax above that and then all the way up … Continue Reading

This entry was posted in Cognos BI. Bookmark the permalink. | Leave a comment

Add a TM1 cube to BI in Cognos Express

This is quite easy. Just go to Cognos Express Manager (http://servername:19300/cognos_express/manager/), click on Data, Select the Data Source Type as TM1, then enter the name you want to call it in BI, the servername as the Administration Host, the TM1 server name (“CXMD”), the TM1 cube name you want to add to BI and finally the namespace (“CognosExpress”).    

This entry was posted in BI Admin, Cognos BI. Bookmark the permalink. | Leave a comment

Using TM1 Aliases in Cognos BI

Often we build a TM1 dimension using codes or ID’s from another system.  For example Product ID’s or Customer Codes.  These are not particularly usable to most people, so we then usually create Aliases in TM1 as well.  Those aliases are visible through in Cognos BI.  Therefore when defining a dimension in TM1 when it is likely that it will be used in Cognos BI, also add an alias with … Continue Reading

This entry was posted in BI Admin, Cognos BI. Bookmark the permalink. | Leave a comment

Setting Up Level Names in TM1 for use in Cognos BI

I am in the middle of setting TM1 up for use with Cognos BI.  One of the things I like in BI is being able to present levels with business names rather than just level numbers.  To define these level names, open the control cube }HierarchyProperties and then orient it so that dimensions are listed as rows and HierarchyProperties are columns.  Then enter the default Member and the names to describe … Continue Reading

This entry was posted in BI Admin, Cognos BI. Bookmark the permalink. | Leave a comment

How to import MSAS Cubes in Cognos Express 10.2.1

One of the new features with IBM Cognos Express (CX) 10.2.1 is that it supports Microsoft Analysis Services (MSAS) cubes. So we are going to demonstrate how you can import MSAS cubes in Cognos Express. Of course the process is the same for IBM Cognos Enterprise.

This entry was posted in BI Admin, Cognos BI and tagged Microsoft Analysis Services, MSAS. Bookmark the permalink. | Tagged Microsoft Analysis Services, MSAS | Leave a comment

How to Import the New Visualisation Charts into IBM Cognos BI

The new visualisation engine from IBM (RAVE) looks amazing and within this article we will show you how to access the charts and use them within report studio. Note that they can be used in traditional reporting and active reports. First step is to go to Analytics Zone. This is an IBM site where you can download all the new visualisation charts, plus Cognos Insight, demos and much more.

This entry was posted in Cognos BI, Cognos Express and tagged Active Report, Bubble Chart, IBM Cognos BI, IBM Cognos Express, RAVE, RAVE Charts, Report Studio, Tag Cloud, Visualisation Chart, Waterfall Chart. Bookmark the permalink. | Tagged Active Report, Bubble Chart, IBM Cognos BI, IBM Cognos Express, RAVE, RAVE Charts, Report Studio, Tag Cloud, Visualisation Chart, Waterfall Chart | Leave a comment