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
Yes, or you can use reports.
http://www.ibm.com/developerworks/data/library/cognos/modeling/transformer/page512.html
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.
Quote from: cognostechie on 04 Jun 2012 01:30:12 PM
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!
Thank you Grim !