TM1 replacement for Cognos Controller

Post Reply
rapmaster
Posts: 2
Joined: Fri Dec 23, 2016 12:57 am
OLAP Product: ssas
Version: 10.0.1
Excel Version: 0

TM1 replacement for Cognos Controller

Post by rapmaster »

Hi All,

I'm just wondering if IBM planning analytics could replace Cognos Controller.
Duncan P
MVP
Posts: 600
Joined: Wed Aug 17, 2011 1:19 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2
Excel Version: 2003 2007
Location: York, UK

Re: TM1 replacement for Cognos Controller

Post by Duncan P »

It depends whether you are asking "Could you implement a consolidation package in TM1?" or "Could I just migrate from Controller to PA?"

The answer to the first is yes - various others here can point you at particular offerings. It is even possible to reproduce some exact Controller behaviour in detail in TM1 (one of my last projects while at IBM). However to create a TM1 server with all of Controller's structure and behaviour in TM1 would be a huge amount of work.

If you wanted to do it and you had a lot of time on your hands, one way is to trace the SQL statements that Controller generates whenever it runs one of its reports. If you want to reproduce the report then you can mimic in TM1 what the queries do in SQL Server. However you had better take along a Swedish/English technical dictionary if you, do as all of the SQL schema was written in the original Frango developers' native language.
Post Reply