Hi Krypto,

You can indeed. You need to create a linked server to your Analysis Services instance.

e.g.

EXEC sp_addlinkedserver

@server = 'AW'

, @srvproduct = ''

, @provider = 'MSOLAP'

, @datasrc = 'localhost'

,@catalog = 'AdventureWorks'

Then you can query with OPENQUERY and join on this set.

SELECT DISTINCT

DimProduct.[EnglishProductName]

, a.[Internet Sales Amount]

FROM [AdventureWorksDW2012].dbo.[DimProduct]

INNER JOIN

(SELECT

CAST("[Product].[Product].[Product].[MEMBER_CAPTION]" AS NVARCHAR) AS [Product Name]

,"[Measures].[Internet Sales Amount]" AS [Internet Sales Amount]

FROM OPENQUERY(AW,'SELECT [Measures].[Internet Sales Amount] ON 0, NON EMPTY [Product].[Product].Children ON 1 FROM [Adventure Works]')) a

ON DimProduct.EnglishProductName = a.[Product Name]

Probably a really horrible example but hopefully it gives you an idea.