Print Page - Can we create a report using two or more cubes

Title: Can we create a report using two or more cubes
Post by: Dineshpullagura on 20 Feb 2015 09:45:57 AM

Hello,

We have a scenario, where we identified 8 dimensions and 7 measures. We need to create a report on these measures and dimensions. Here, all the measures are not applicable for all the dimensions. I have 3 measures which are applicable for 4 dimensions and another 4 measures applicable for 5 dimensions and 1measure applicable for only 1 dimension.

Is it efficient to build one cube for all these measures and dimensions. If not, can we build two or more cubes and create a report on these cubes.

Please suggest.

Thank you.

Title: Re: Can we create a report using two or more cubes
Post by: bdbits on 20 Feb 2015 05:15:38 PM

It sounds to me like in reality, you actually have three fact tables. In which case three cubes would seem appropriate.

Title: Re: Can we create a report using two or more cubes
Post by: Dineshpullagura on 22 Feb 2015 10:02:05 PM

Hi,

Thanks for your reply. Is it possible to build a report using two or more cubes.

Title: Re: Can we create a report using two or more cubes
Post by: MFGF on 23 Feb 2015 05:58:13 AM

Quote from: Dineshpullagura on 22 Feb 2015 10:02:05 PM
Hi,

Thanks for your reply. Is it possible to build a report using two or more cubes.

Does this post help answer your question?

http://www.cognoise.com/index.php/topic,27087.msg86610.html#msg86610

MF.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Dineshpullagura on 20 Feb 2015 09:45:57 AM