CODEWITHSUNDEEP
sql-serversql-server-2012ssasmdx
whytheq
whytheq

Reputation: 35557

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?

Upvotes: 1

Views: 415

Answers (1)

Alexander Sigachov
Alexander Sigachov

Reputation: 1551

Try this

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

Upvotes: 3

Related Questions