Hello All,
One question : can we use TM1(one or multiple cubes) as source to Dynamic cube?
Any advise/document will be appreciated.
Regards
Gbehel
TM1 and dymanic cube
-
- MVP
- Posts: 1817
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: TM1 and dymanic cube
Dynamic Cubes are a way of transforming relational data into an olap style analytical object (ROLAP technology.)
TM1 is already MOLAP technology... why would you want to use it as a source?
TM1 is already MOLAP technology... why would you want to use it as a source?
Declan Rodger
-
- Posts: 49
- Joined: Fri Dec 27, 2013 8:35 am
- OLAP Product: TM1, Cognos EP, Contributor
- Version: 10.2.2
- Excel Version: 2013
- Location: India
Re: TM1 and dymanic cube
Hi Rodger
I was trying to see if using TM1 as source to Dynamic cube, will we be able to use the virtual cube capability of Dynamic cube and thus handling large volume of data with ease
TM1 is very well capable of handling large data volumes but the large data becomes difficult to handle in perspective/cafe/insight.. hence was looking at option of putting TM1 on BI platform via FM package and also explore possibility to using Dynamic cube
can you let me know if this is possible?
regards
Gbehel
I was trying to see if using TM1 as source to Dynamic cube, will we be able to use the virtual cube capability of Dynamic cube and thus handling large volume of data with ease
TM1 is very well capable of handling large data volumes but the large data becomes difficult to handle in perspective/cafe/insight.. hence was looking at option of putting TM1 on BI platform via FM package and also explore possibility to using Dynamic cube
can you let me know if this is possible?
regards
Gbehel
-
- Site Admin
- Posts: 1457
- Joined: Wed May 28, 2008 9:09 am
Re: TM1 and dymanic cube
Dynamic cubes requires a star or snowflake schema over relational tables.
But there's nothing stopping you publishing one or more TM1 cubes to BI, either through FM or directly and you can then use Dynamic Query to speed up reporting.
Having worked through an IBM session on DCs they do genuinely sit in a different space from TM1 providing fast delivery of relational data with tunable, experience based cacheing. For a given set of content that wasn't hundreds of billions of data points I think I'd still back TM1 against DC if it were done right by someone who understood the content and the product - but that's what I know, so I would, wouldn't I?
But there's nothing stopping you publishing one or more TM1 cubes to BI, either through FM or directly and you can then use Dynamic Query to speed up reporting.
Having worked through an IBM session on DCs they do genuinely sit in a different space from TM1 providing fast delivery of relational data with tunable, experience based cacheing. For a given set of content that wasn't hundreds of billions of data points I think I'd still back TM1 against DC if it were done right by someone who understood the content and the product - but that's what I know, so I would, wouldn't I?
-
- Posts: 49
- Joined: Fri Dec 27, 2013 8:35 am
- OLAP Product: TM1, Cognos EP, Contributor
- Version: 10.2.2
- Excel Version: 2013
- Location: India
Re: TM1 and dymanic cube
Thanks David
This helps!!
Regards
Gbehel
This helps!!
Regards
Gbehel