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]
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