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

Eva-Agnes 1 Reputation point
2021-10-07T07:32:07.147+00:00

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
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,263 questions
{count} votes

1 answer

Sort by: Most helpful
  1. CarrinWu-MSFT 6,866 Reputation points
    2021-10-07T09:23:55.833+00:00

    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   
    

    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.

    0 comments No comments