Forum Discussion

abhiram342's avatar
abhiram342
Microsoft Employee
3 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi abhiram342 ,

     

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