Solved

Can I use two datascources in the same report

Posted on 2012-04-03
3
352 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
ID: 37802298
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
ID: 37803135
Thanks!
0
 
LVL 37

Expert Comment

by:ValentinoV
ID: 37804760
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Find control on SSRS report 1 47
How to instal SSRS in visual studio 2010 2 18
Update one rows based on previous row 5 27
SQL- GROUP BY 4 21
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
In this article I will describe the Backup & Restore 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.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

679 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