Hi,
Any help is appreciated
In the below query I want to replace [201412] with parameter @SVCDATE in SSRS query designer, @SVCDATE is already declared.
with
Member [Measures].SUM_ACO_Normalized_Score_Amt AS ([Service From Date].[Year Month Num].&[201412] ,[Measures].[Claim Count])
SELECT
{[Measures].SUM_ACO_Normalized_Score_Amt , [Measures].[Normalized Score Amt], [Measures].[Risk Adjustment Factor A Num], [Measures].[Line Item Paid Amt Adjusted(Claim)], [Measures].[Unique Person Count(Claim)], [Measures].[PMPM Cost (Claim)],[Measures].[Last
Update Date]
} ON COLUMNS,
NON EMPTY
{
( [Servicing Provider].[Provider Name Combined Name].[Provider Name Combined Name].AllMembers * [Servicing Provider].[Provider TIN Num].[Provider TIN Num].AllMembers )
} Dimension Properties MEMBER_CAPTION,
MEMBER_UNIQUE_NAME ON ROWS
FROM CUBE