Page 1 of 1
Can a Cognos report studio report be used data source
Posted: Mon Mar 14, 2016 6:44 pm
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.
Re: Can a Cognos report studio report be used data source
Posted: Mon Mar 14, 2016 7:15 pm
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.
Re: Can a Cognos report studio report be used data source
Posted: Mon Mar 14, 2016 8:46 pm
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.
Re: Can a Cognos report studio report be used data source
Posted: Tue Mar 15, 2016 1:46 pm
by LutherPaul
Thanks for your ideas babytiger and qml.
I see a way through Performance modeller.
Thanks again.
Paul.