Wednesday, 17 September 2014

Distinct in MDX

with set myset
as
{
    [HR Company].[Company Name].&[Amerihealth Administrators]
    , [HR Company].[Company Name].&[Amerihealth Administrators]
    , [HR Company].[Company Name].[All].UNKNOWNMEMBER
    , [HR Company].[Company Name].[All].UNKNOWNMEMBER
}

MEMBER [Measures].[Count]
as
count(myset)

MEMBER [Measures].[DistinctCount]
as
count(distinct(myset))

SELECT
{
    [Measures].[Count]
    , [Measures].[DistinctCount]
} ON 0
FROM [SampleCompany]

No comments:

Post a Comment