Print Page - prompt selection using dimensional model

Title: prompt selection using dimensional model
Post by: pooja on 29 Jan 2014 10:39:38 AM

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

Title: Re: prompt selection using dimensional model
Post by: dax on 29 Jan 2014 04:19:46 PM

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

Title: Re: prompt selection using dimensional model
Post by: pooja on 30 Jan 2014 12:35:44 PM

Thank you.

Title: Re: prompt selection using dimensional model
Post by: MFGF on 03 Feb 2014 05:53:09 AM

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.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: pooja on 29 Jan 2014 10:39:38 AM