Cognos BI and TM1

[CognosFPM]

Dear Cognos Experts,

I would really appreciate your suggestions to an issue that I have trying to report TM1 data via BI.

This is the issue that I am facing.

• I have 3 BI queries that query a TM1 cube. The difference between the 3 queries is that each queries a different version and date.
• When run independently, each of these queries take less than a second to return a result set (6 rows of records each)
• However, when I combine these 3 queries using a Union in Cognos BI to stitch the 3 result sets into 1 set of 18 records, instead of performing a simple append, the union fires a new query to TM1 which causes TM1 to generate a huge view (2 gb+) before returning the combined result set.

Any pointers much appreciated.

Thanks in advance,

C

[jim wood]

I think you missed out the versions you were trying to connect??

[CognosFPM]

Right you are Sir!

I'm using Cognos Express 9.5. So I believe its Report Studio 8.4 and TM1 9.5.1.

[PlanningDev]

Do any of your dimensions contain a lot of items that might have no data?

If so then try adding the filter function to that dimension for each query and see what happens. Sometimes you get a lot of zero values coming back from TM1 to BI and it has to crunch a ton of useless data.