Solved

Can I use two datascources in the same report

Posted on 2012-04-03
3
345 Views
Last Modified: 2016-02-14
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
Comment
Question by:himabindu_nvn
  • 2
3 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
Comment Utility
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
 

Author Closing Comment

by:himabindu_nvn
Comment Utility
Thanks!
0
 
LVL 37

Expert Comment

by:ValentinoV
Comment Utility
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

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now