reporting services - How to replace/get value of parameter in MDX query passed by SSRS report -


sorry basic question,

i have ssrs report takes value of parameter dynamically , creates mdx query.

now, have mdx query , want run in ssms or mdx studio. not sure how replace parameter value.

for example:

with member [measures].[hc threshold] val(strtomember(@hc_threshold).name), format_string="$#,0" 

and found hc_threshold dimension, looks like

enter image description here

based on this, how modify 'val(strtomember(@hc_threshold).name), format_string="$#,0"', if user selects 75000.

let me know if need more information, new ssrs , parameterized queries in mdx.

thanks

replace parameter value string produces valid member of dimension.

select [product].[model name].[model name] on rows, [measures].[sales amount] on columns [adventure works dw2012] strtomember("[ship date].[calendar quarter].[4]") 

note strtomember() receives string argument , converts valid member.

in scenario like:

strtomember("[hc_threshold].[id].[7500]") 

Comments