YTD, QTD, MTD,WKD Prompt in Report Studio

[wildtopiwala]

Hello Everyone,

I need a prompt on a report page where  user has an option to select YTD, QTD, MTD, WTD and the report will change accordingly. The report is based on a cube and I have YTD, QTD,MTD,WTD in a time dim.

Can someone please explain how should I create this?

Thanks

[MFGF]

Hello Everyone,

I need a prompt on a report page where  user has an option to select YTD, QTD, MTD, WTD and the report will change accordingly. The report is based on a cube and I have YTD, QTD,MTD,WTD in a time dim.

Can someone please explain how should I create this?

Thanks

Hi,

Firstly, you need to do a little research on your YTD, QTD, MTD and WTD members in the cube. You will need to know what the Member Unique Name (MUN) of each of these is. My advice is to open Notepad and paste them into there as you go along.

To find the MUN of a member (such as YTD), expand the member tree in your package until you see the member, right-click on it, and select "Properties" from the right-click menu. Locate the Member Unique Name property, and copy it into Notepad. Do the same for each of the other members you want to use.

Next, you can add the prompt. Drag in a value prompt onto your report page and define a name for the parameter it will prompt for (eg YQMW). Don't click "Next" - just hit "Finish" at this point.

Select the prompt, and in properties, firstly set "Auto-Submit" to Yes. Go to the Static Choices property, and add four static choices. For the first one, set the Use Value to be the MUN of your YTD member, and set the Display Value to YTD. Repeat for each of the other members you want to use. Next, go to the Default Selections property, and enter the MUN one of the members you want to be the default - eg add the MUN for YTD.

If you want to display the prompted member as a row or a column in your crosstab, drag in a Query Calculation, set the type to "Other", give it a name, and code the expression as your parameter within question marks - eg ?YQMW?

If you don't want to display the selected member but just want it to filter the measures in your crosstab, go to the query of your crosstab, select the Toolbox tab, drag a Slicer Member Set from the toolbox into your Slicer area of the query, and code the expression as your parameter in question marks - eg ?YQMW?

Cheers!

MF.

[wildtopiwala]

First, I want to thank you for your quick response. I followed all the steps but when I run the report I am getting this error:
"Slicer members must come from different dimensions"
As you mentioned, I dragged slicer from the toolbar and added ?p_YQMW?. Please let me know how can I troubleshot this error.


Thanks

[MFGF]

First, I want to thank you for your quick response. I followed all the steps but when I run the report I am getting this error:
"Slicer members must come from different dimensions"
As you mentioned, I dragged slicer from the toolbar and added ?p_YQMW?. Please let me know how can I troubleshot this error.


Thanks

What members are you using currently in your rows and columns? Sounds like you are already using one of the members you are slicing on?

MF.

[wildtopiwala]

Thank You, I was able to make it work by following you crystal clear instructions  :) :) :) :)