Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hnomani
Starting Member
35 Posts |
 Posted - 2007-08-06 : 10:29:31
|
| I am trying to build a report that access data from multiple cubes. Is it possible to join multiple cubes based on their shared dimensions? Or is it possible for report to display data from multiple cubes properly aligned based on the dimension.Environment: SQL Server Analysis Services 2005 and Reporting Services 2005Example:We have multiple cubes with “Year” as a shared dimension and each one has different Rate info. The cubes have other set of shared dimensions which I am planning to set it up as a parameter. I would like to display the report as YearRate1Rate2Rate3…I really appreciate any suggestion.ThanksHaseeb |
|
|
PatDeV
Posting Yak Master
197 Posts |
Posted - 2007-08-06 : 17:35:39
|
| CREAT REPORT using query onthe cubes!! |
 |
|
|
hnomani
Starting Member
35 Posts |
Posted - 2007-08-07 : 09:50:46
|
| I am not sure what you mean by "CREATE REPORT using query onthe cubes". I can create multiple data sets based on the data from each cube. But how would I "JOIN" these data sets? |
|
|
|
|
|
|
Join data from multiple cubes