Export Cognos BI report using TM1 TI

[rsnrekha]

Hello,

In my current assignment, there are processes to import Cognos BI report data in to TM1 Cube, and then Cube export to CSV, lastly load in to database table using SQL Loader.

Now the question is can we directly export the data from Cognos BI report to CSV and load in DB using SQL Loader?

This is to skip the first step and get rid of TM1 cube in between as a staging area.

thanks and Regards
Rekha

[David Usherwood]

I suggest you go behind the BI report to the source and use that to load into your SQL database.

[rsnrekha]

Thanks David for the reply.

Here it is the case of two different systems residing in different DBs. Due to the timeline issue it is not possible to connect two different DBs directly.
Hence they have some quick fixes, BI reports.

Source DB --> FM Package Provided global use --> BI Report as per the requirement --> Import in TM1 Cube --> Write back to Target DB.

I am not able to export the BI report directly to csv due to some issues in package connector. May be i am doing something wrong.

So, has it been the case anytime for you or to all in this forum to come accross such requirement.

Thanks

[tomok]

Considering this is a TM1 forum and you're asking how to bypass TM1 I don't know that there will be that many people with that specific experience. Looks to me me like you should be asking this in a Cognos BI forum. Those guys probably do this type of stuff all the time.

[rsnrekha]

Hello Tom,

The question is, is it possible to export Bi report to CSV using TI process. The bypass is only the TM1 cube. TI will still remain there.
And yes, as per your suggestion will post the question in BI forum as well.

Thank you.

[declanr]

Hello Tom,

The question is, is it possible to export Bi report to CSV using TI process. The bypass is only the TM1 cube. TI will still remain there.
And yes, as per your suggestion will post the question in BI forum as well.

Thank you.

This is of course possible. At the moment you have a TI that has a BI datasource and outputs to a cube; then another with the cube source and outputs to a file/db. You can have one that goes straight from BI to file/DB.

Your problem is that the staging cube is most likely in place to do some form of transformation... you can probably do this in TI but without knowing what it is, I can not say that for certain.
It would seem unusual to use a staging cube if no changes were made... even just using it to consolidate data perhaps.