create a report using relational table and cube data

Question

create a report using relational table and cube data

rupesh.gajjela

SSC Veteran

Points: 255
More actions
October 18, 2012 at 5:41 pm

#283863

Hi ,
Can we create a single report adding some columns from a table and some columns from OLAP cube in SSRS ?Please help.
Thank you.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

tinnusqlserver Ten Centuries Points: 1191 More actions · Answer 1

Hi,

No You can't use both SQL and OLAP data for the same report. Since for a report you will use only one dataset and we cannot combine 2 sources for a single dataset.

The best way you can do is to bring your SQL data into OLAP and use only OLAP as source for the dataset.

robert.gerald.taylor SSChampion Points: 13133 More actions · Answer 2

rupesh.gajjela (10/18/2012)
Hi ,
Can we create a single report adding some columns from a table and some columns from OLAP cube in SSRS ?Please help.

Yes, you can query a SSAS cube through T-SQL using the OpenQuery.

Take a look at: http://sqlblogcasts.com/blogs/drjohn/archive/2008/09/27/mdx-and-sql-combining-relational-and-multi-dimensional-data-into-one-query-result-set.aspx

HTH,

Rob