Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Joining SQL and MDX result sets...possible?

Author  Topic 

phrankbooth
Posting Yak Master

162 Posts

Posted - 2010-04-14 : 14:36:50
Hi,

Wondering if anyone's experienced having to join MDX and SQL result sets. Is it possible at all? I know they are different animals, but just wondering if there is some undocumented way, to join them while maintaining their native formats.

I've been able to do it by using OPENROWSET, but this is a flattening of the MDX resultset.

Thx!!

--PhB

savior faire
Posting Yak Master

194 Posts

Posted - 2010-04-14 : 19:38:41
Maybe you can post a question on www.ssas-info.com, a site dedicated solely to Analysis services. Lots and lots of really smart people and experts on that site. Hundreds of articles and white papers, plus videos and downloads.


______________________________________________
Talk sense to a fool and he calls you foolish.
Go to Top of Page
   

- Advertisement -