Hello,
in a project we think about taking a tm1-cube for reporting in cognos 8. Do you have any experience with that? What kind of limitations did you face?
I heard something about limited functions with parallel hierarchies? Do you know something about it? Anything else?
Is there somthing special I have to look at in order to have a good performance with a tm1-cube in Cognos 8?
Thanks a lot for your help!!
Regards,
Toto
C8-reporting on a TM1-cube
-
Olivier
- Community Contributor
- Posts: 159
- Joined: Thu Jun 26, 2008 5:46 am
- OLAP Product: TM1
- Version: Tm1 10.2.2fp4 -> 2.09
- Excel Version: Excel 2013 - 2019
- Location: Sydney
Re: C8-reporting on a TM1-cube
Hi Toto,
Interresting question,
I have to think about interraction between TM1 and Cognos 8 as well.
I have not done a very in depth exploration at this stage but i had a look at the interfacing capability quickly.
There is definetly a specific interraction between Cognos and Tm1 regarding hierarchies/subsets attributes...
but i am not really able to comment on limitations at this stage
I had a quick play with framework manager and managed to produce pretty quickly a simple report from my tm1 source.
My first impression is that you will have to manage metadata/hierarchies in Tm1 in accordance with the behaviour of cognos in order to make them interract properly/efficiently.
This seems to have the potential to trigger quite a bit of work on the tm1 side.
I would love to read feedback from people having a more advance experience in this regard that might have had a cognos / tm1 integration to conduct after having maintained an isolated tm1 application..
Kind regards,
Olivier
Interresting question,
I have to think about interraction between TM1 and Cognos 8 as well.
I have not done a very in depth exploration at this stage but i had a look at the interfacing capability quickly.
There is definetly a specific interraction between Cognos and Tm1 regarding hierarchies/subsets attributes...
but i am not really able to comment on limitations at this stage
I had a quick play with framework manager and managed to produce pretty quickly a simple report from my tm1 source.
My first impression is that you will have to manage metadata/hierarchies in Tm1 in accordance with the behaviour of cognos in order to make them interract properly/efficiently.
This seems to have the potential to trigger quite a bit of work on the tm1 side.
I would love to read feedback from people having a more advance experience in this regard that might have had a cognos / tm1 integration to conduct after having maintained an isolated tm1 application..
Kind regards,
Olivier
HTH
Olivier
Olivier
-
soumya2g
- Posts: 2
- Joined: Tue Dec 15, 2009 3:43 pm
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2000
Re: C8-reporting on a TM1-cube
Hi Toto,
I have done Cognos BI Reporting using TM1 cube as a data source and observed following limitations -
1) the security implemented on a TM1 Hierarchical dimension gets transferred to BI but in a weired fashion. To give you an example, say in a hierarchy A rolls up to B and B rolls upto C and you have used this dimension in a TM1 budgeting cube. If you use this hierarchical dimension in a report or prompt in BI, Ideally what you want is ....when A logs in he should be able to see only A's data, When B logs in he should be able to See A and B's data and C should able to see data corresponding to A, B and C. But using TM1 cube as a data source in BI, A and B will not be able to see any data in the report but C will be able to see all the data.
The workaround to this will be, create a copy of the budgeting cube as a reporting cube but with a Flat dimension containing A,B and C, and replicate the security applied. Then use this reporting cube as a data source in BI.
2) In BI, data doesn't roll up very well along TM1 dimension attributes. What that means is, if you drag a TM1 dimension attribute in a list report and drag some measure from the measure dimension defined in Architect, and you want to group the data by the attribute description....it doesn't get grouped properly.
3) Using the hierarchical levels created in a TM1 dimension for drill up/down in BI report is a pain. It doesn't behave consistently.
The benefit of using TM1 data source in BI being its very fast....Due to its in memory architecture once the cube is loaded in RAM its very quick.
Hope this helps......
Soumya
I have done Cognos BI Reporting using TM1 cube as a data source and observed following limitations -
1) the security implemented on a TM1 Hierarchical dimension gets transferred to BI but in a weired fashion. To give you an example, say in a hierarchy A rolls up to B and B rolls upto C and you have used this dimension in a TM1 budgeting cube. If you use this hierarchical dimension in a report or prompt in BI, Ideally what you want is ....when A logs in he should be able to see only A's data, When B logs in he should be able to See A and B's data and C should able to see data corresponding to A, B and C. But using TM1 cube as a data source in BI, A and B will not be able to see any data in the report but C will be able to see all the data.
The workaround to this will be, create a copy of the budgeting cube as a reporting cube but with a Flat dimension containing A,B and C, and replicate the security applied. Then use this reporting cube as a data source in BI.
2) In BI, data doesn't roll up very well along TM1 dimension attributes. What that means is, if you drag a TM1 dimension attribute in a list report and drag some measure from the measure dimension defined in Architect, and you want to group the data by the attribute description....it doesn't get grouped properly.
3) Using the hierarchical levels created in a TM1 dimension for drill up/down in BI report is a pain. It doesn't behave consistently.
The benefit of using TM1 data source in BI being its very fast....Due to its in memory architecture once the cube is loaded in RAM its very quick.
Hope this helps......
Soumya