question

EvaAgnes-2952 avatar image
0 Votes"
EvaAgnes-2952 asked CarrinWu-MSFT commented

How to list Dimension Name or Measurement Name from MDX Script ?

I have a script (MDX textdata usage) from SSAS, I want to list Dimension name or Measurement name from that string.
any one please suggest how to list it?

sql-server-analysis-services
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @EvaAgnes-2952, we have not get a reply from you. Could below answers help you? If yes, please do "Accept Answer". By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·

Hi @EvaAgnes-2952, we have not get a reply from you. Could below answers help you? If yes, please do "Accept Answer". By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·

1 Answer

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered

Hi @EvaAgnes-2952,

Welcome to Microsoft Q&A!

Do you have to use MDX? If not, you could get Dimension Name or Measure Name using Analysis Services Dynamic Management Views (DMVs). The query, based on SQL, is an interface to schema rowsets.

 SELECT *
 FROM $system.MDSchema_Dimensions 
    
 SELECT *
 FROM $SYSTEM.MDSCHEMA_MEASURES 

138484-screenshot-2021-10-07-171519.png

138437-screenshot-2021-10-07-171436.png


Best regards,
Carrin


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.