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
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
Post a Comment