Can we use FModel as a data source to build Cube

[meeecog]

Hell All

Currently we have FModel ..we want to use this model as a source to build a cube. Can we do that ..

Pls advice.

Thanks

[Lynn]

Yes, or you can use reports.

http://www.ibm.com/developerworks/data/library/cognos/modeling/transformer/page512.html

[cognostechie]

Whoever wrote that document did not realize the downsides. You should never use a DMR as a data source in Transformer. Reason - If the DMR has 20 dimensions and you are using only one of them, it will still generate a massive SQL that will involve all the queries required for those 20 dimensions which makes no sense. Since the DMR is in FM , that means the Business Layer is already ready so there is no point in using a DMR and creating performance issues.

[Grim]

Whoever wrote that document did not realize the downsides. You should never use a DMR as a data source in Transformer. Reason - If the DMR has 20 dimensions and you are using only one of them, it will still generate a massive SQL that will involve all the queries required for those 20 dimensions which makes no sense. Since the DMR is in FM , that means the Business Layer is already ready so there is no point in using a DMR and creating performance issues.

cognostechie is correct. Good on your for pointing that out to folks.
I applaud you sir!

[cognostechie]

Thank you Grim !