i am new to SQL server 2008 and i am investigating the possible use of SSAS and report builder for my task. i was wondering wether the following scenarion is possible;
Breaking down my db into several small cubes made up of different business model; ex Sales, Budget, Stocks, etc. Then using report builder creating my different reports. My reports could be based on one specific cube(ex sales).
Is it possible with report builder to create a report which will take measures and dimensions from more than one cube?
for example i have to get a report for one specific outlet giving me the actual sales per product but also the forecasted sales from my budget. In this case i have my actual sales information coming from my Sales cube and the forecasted sales comes from
my Budget cube. How do i link my cubes in report builder so that i can do such a report.
thanking you in advance,
View Complete Post