prompt selection using dimensional model

[pooja]

Hi all,
We are trying to create prompt selection for currency member using dimensional model.We have 'All currency' member under 'Currency' dimension. Under 'All currency' member there are 10 different currencies. And we would like to display only 'US ' currency on prompt selection. Can you please
help how to achieve this? This is for crossrtab report using dimensional model.

Thanks for help.

P

[dax]

Hi

Is your prompt linked to a query?  If so, can you not just create a data item such as Set([USD]) (ensuring that you bring in the USD member from your currency dimension) - name it something like "Currencies".  Then in your prompt properties change the Use Value property to "Currencies".  When you run the report it should just display USD in the currency list.

Does that help, or have I missed something?

Dax

[pooja]

Thank you.

[MFGF]

Hi,

Am I missing something obvious here? Why have a prompt with only one possible value? Wouldn't it be just plain simpler to have a slicer filter or report expression that targets the USD member without prompting for it?

MF.