Querying Tables using DAX from Mutiple Cubes

[abhiram342]

Hi All,

We have Multidimensionsal solution with multiple cubes in Databse. We have setup linked server to database programtically query the data. Can some one please tell how to specify the Cube Name while querying the Table using DAX. We want to use same LinkedServer Connection to query data from Muliple Cubes

Example:

select * from openquery(LinkedServerName,''EVALUATE CubeName.Table''))

If we specify the Cube Name then it's not working . With MDX , we have option to specify the Cube Name ( From Clause) while with DAX we didn't find option.

Please tell how to provide the Cube Name while querying from DAX

Thanks,

Abhiram

[v-jayw-msft]

Hi @abhiram342 ,

Please share some sample data so that we could test formula.