Forum Discussion
abhiram342
3 years agoMicrosoft Employee
Querying Tables using DAX from Mutiple Cubes
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
1 Reply
- AnonymousNot applicable