TM1 and dymanic cube

[gbehel]

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

[declanr]

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?

[gbehel]

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

[David Usherwood]

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?

[gbehel]

Thanks David

This helps!!

Regards
Gbehel