• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 420
  • Last Modified:

Can I use two datascources in the same report

I have 4 cubes. I need to generate a report using all the 4 cubes. Is there any way that I could use 4 cubes in the same report?

Thanks!
0
himabindu_nvn
Asked:
himabindu_nvn
  • 2
1 Solution
 
ValentinoVBI ConsultantCommented:
You can use multiple data sources and also multiple datasets in the same report.  What you can't do is use data from two different datasets in the same table/matrix.  If you need to access another dataset from a certain report table, you can use the lookup functions, assuming you're using at least SSRS 2008 R2.

More details on the Lookup: http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/A_3433-Looking-Up-Data-On-Different-Sources.html
0
 
himabindu_nvnAuthor Commented:
Thanks!
0
 
ValentinoVBI ConsultantCommented:
Why the "B" grade?

It is customary to explain any grade that is not an A.
(ref. http://www.experts-exchange.com/help/viewHelpPage.jsp?helpPageID=26)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now