SQLServerCentral / Reporting Services / Reporting Services / In one SSRS report, can we sync data from both table and SSAS cube? / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 09:40:30 GMT20RE: In one SSRS report, can we sync data from both table and SSAS cube?http://www.sqlservercentral.com/Forums/Topic1370073-150-1.aspxHi, yes you can use two datasource SSAS and TSQL see these two links http://www.bi-rootdata.com/2012/09/execute-mdx-query-with-tsql.htmlhttp://www.bi-rootdata.com/2012/10/passing-multi-value-tsql-parameter-to.htmlTue, 09 Oct 2012 04:14:50 GMTsanjeewan99RE: In one SSRS report, can we sync data from both table and SSAS cube?http://www.sqlservercentral.com/Forums/Topic1370073-150-1.aspx[quote][b]kothakeerthi (10/8/2012)[/b][hr]1. can I take 1 source from table and other source from SSAS cube and do the "Report Server Project"2. can I take 1 source from table and other source from SSAS cube and do the "Report Model Project" (for users to create Ad hoc Reports)[/quote]In the report you can create two different datasets one pointing to relational and other to OLAP. And then you can use Lookup/LookupSet function to join data from those two datasets.OR In the stored procedure, you can write an MDX query in a variable (say @mdx) to get the OLAP data and save it to a temp table. For that you need to create a Linked server (to OLAP DB). And use this @mdx variable in an OPENQUERY command (alongwith insert and select statements to fill the temp table). Then you can join the temp table along with relation table to get the appropriate data.Tue, 09 Oct 2012 04:14:40 GMTH4KRE: In one SSRS report, can we sync data from both table and SSAS cube?http://www.sqlservercentral.com/Forums/Topic1370073-150-1.aspxHave you tried it? What did you find? Go to your test environment and try some test examples in SSRS.RobOne thought is that you could do an OPENROWSET to get the cube data and union with your relational data.Mon, 08 Oct 2012 17:52:23 GMTrobert.gerald.taylorIn one SSRS report, can we sync data from both table and SSAS cube?http://www.sqlservercentral.com/Forums/Topic1370073-150-1.aspx1. can I take 1 source from table and other source from SSAS cube and do the "Report Server Project"2. can I take 1 source from table and other source from SSAS cube and do the "Report Model Project" (for users to create Ad hoc Reports)Mon, 08 Oct 2012 15:08:01 GMTKKottha