Possible to Join Datasets ?

[thermidor]

Hi All -

I would like to have a report where I can join data from a cube with data from a relational store. Can this be done in SSRS?

TIA -
Sven

 

[xlbo]

Can't be done in the report itself - datasets in reports are distinct

Not good enough in SQL to tell you whether it could be done there....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[RiverGuy]

You can add SSAS as a linked server in SQL Server. You should be able to create a stored procedure or T-SQL code to return a join query with SSAS and SQL Server data. However, why not look at integrating the relational data into SSAS?