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.

All Forums  SQL Server 2008 Forums  Analysis Server and Reporting Services (2008)  Two Cubes

Author  Topic  Veda815 Starting Member 5 Posts Posted - 2010-03-26 : 11:54:49 Hello all, I have a question about using Olap cubes in SSRS. I have two OLAP cubes with different data sets and I want to present some data from each cube in one matrix in my SSRS report (there are common fields I could map to). Is this possible? In another scenario I have some data in a cube and the rest of my data in various tables on the same server. Can I write a query that calls data out of the cube and use it in the same query I am using data from normal tables? Thank you for your input.