Search code examples
sql-serversql-server-2012ssasmdx

Cube Default Measure

If I execute the following MDX script

SELECT
FROM [CubeName]

It returns an answer giving the total of all the members in for the default measure.

Can I write an MDX statement that tells me what the default measure is or is it not possible to query meta-data with MDX?

Solution

  • Try this

    WITH MEMBER [Measures].[DefaultMemberName] AS [Measures].DefaultMember.Member_Name
SELECT
    [Measures].[DefaultMemberName] ON 0
FROM [YourCube]