Hi @Eva-Agnes ,
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
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.