Slice MDX member by parameter

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

September 3rd, 2015 5:01pm

Hi PARC,

According to your description, you want to use parameter in your MDX query when working in SSRS. Right?

In Reporting Services, when using parameter in MDX query, it will resolve the parameter as Text, so we need to use STRTOMEMBER() or STRTOSET() to convert the parameter. And you need to create the parameter in the Query mode, it will not take other existing parameters. Please refer to screenshots below:

Reference:
SSRS Report with Single and Multi Selection Parameter using MDX Query
Create First SSRS Report with SQL Server Analysis Services OLAP Cube

Regards, 

Free Windows Admin Tool Kit Click here and download it now
September 6th, 2015 10:56pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics