Can a Cognos report studio report be used data source

Post Reply
LutherPaul
Posts: 80
Joined: Tue Jun 04, 2013 3:35 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Can a Cognos report studio report be used data source

Post by LutherPaul »

Hi All,
Can a Cognos report studio report 10.2 be used data source in TM1 10.2.2 FP4? I have a requirement and the report is built and maintained by the business.
Any other ideas are welcome.

Thanks in advance,
Paul.
babytiger
Posts: 78
Joined: Wed Jul 31, 2013 4:32 am
OLAP Product: Cognos TM1, EP, Analyst
Version: 10.2.2
Excel Version: 2013
Location: Sydney AU

Re: Can a Cognos report studio report be used data source

Post by babytiger »

Generally, yes.
You can use performance modeller for that instead of the native TI.
From PM, select your data source as your report from bi.
MK
User avatar
qml
MVP
Posts: 1097
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: Can a Cognos report studio report be used data source

Post by qml »

There is a separately distributed component called Cognos TM1 Package Connector which allows you to use Framework Manager packages as data sources for TI.

Another possibility is to schedule the report to run in a CSV format and then use the generated CSV file(s) as the data sources for TM1.

But generally I would advise against doing it this way. Whatever the data source for the BI report, you should get the data straight from there.
Kamil Arendt
LutherPaul
Posts: 80
Joined: Tue Jun 04, 2013 3:35 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: Can a Cognos report studio report be used data source

Post by LutherPaul »

Thanks for your ideas babytiger and qml.
I see a way through Performance modeller.

Thanks again.
Paul.
Post Reply