SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm creating a dashboard in SharePoint 2010. I've got PerformancePoint, Reporting Services, and everything set up. I want to create a report using data that spans multiple tables. Typically, I use LINQ or a stored procedure to query data across them, but it seems like that with dashboards I only have the option to create a data source that maps to a single table, and not to a stored procedure or SQL query. Is there any way to accomplish this? What are my options and which is the best way?

share|improve this question
up vote 1 down vote accepted

While designing your cube you have option to setup DataSourceView. Once you have dropped table there you can right click on it and created NamedQuery. You can specify joins between tables in named query and can get data as your requirement.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.