Parameters

[chrisssyp82]

Report Builder 3

i'm currently creating a report using Analysis Services cubes and so i'm creating the report using the mdx query designer. I have two data sets, one looks at premium splits by fiscal calendar and the other is policy count split by entry date. I wish to create one parameter so that it can utilise both the fiscal calendar and the entry date, ie the user enter "June 11" and it brings back the data from both queries for June 11. However i have no clue how to do this? (i'm sorry but i'm new to mdx query designer) Can anyone point me in the right direction?

 

[RiverGuy]

You edit the text of your MDX query to include something like:

WHERE (
StrToMember(@rpDateParameter)
)

You then map a parameter called rpDateParameter to an SSRS parameter called @rpDateParameter.