WITH MEMBER [Measures].x AS
CASE
WHEN [Measures].[Claim Age In Days] >= 0 AND [Measures].[Claim Age In Days] <= 10 THEN '0 - 10 Days'
WHEN [Measures].[Claim Age In Days] >= 11 AND [Measures].[Claim Age In Days] <= 50 THEN '11 - 50 Days'
WHEN [Measures].[Claim Age In Days] >= 51 AND [Measures].[Claim Age In Days] <= 100 THEN '51 - 100 Days'
ELSE '> 100 Days'
END
SELECT [Measures].x on 0
, NON EMPTY [HR User].[USER NAME].[USER NAME].Members ON 1
FROM [SampleCompany]
CASE
WHEN [Measures].[Claim Age In Days] >= 0 AND [Measures].[Claim Age In Days] <= 10 THEN '0 - 10 Days'
WHEN [Measures].[Claim Age In Days] >= 11 AND [Measures].[Claim Age In Days] <= 50 THEN '11 - 50 Days'
WHEN [Measures].[Claim Age In Days] >= 51 AND [Measures].[Claim Age In Days] <= 100 THEN '51 - 100 Days'
ELSE '> 100 Days'
END
SELECT [Measures].x on 0
, NON EMPTY [HR User].[USER NAME].[USER NAME].Members ON 1
FROM [SampleCompany]
No comments:
Post a Comment