Report Builder and confirmed dimension

Hi Experts,

I have build a cube and placed report builder on it. I have a Dimensional model with two fact table. When i try to create a report it allows me to select measures from only one fact. It doesnt allow me to create report from two different fact and two different dimensions.

Please help

Regards

Neeraj

Hi, you can't never do that in report builder, because [Report Builder] model does not work with more them one fact table.|||

I believe Loobo is correct in stating that Report Builder doesn't accept more than one measure group/fact table. Report Builder seems to be focused on more of a relational database model which does not always work well with Analysis Services.

Thanks,
Bryan Smith

|||Thank You Guys for that Insight.