Print Page - How can I use this expression in query calculatio (source : TM1 / Cognos 10.2.1)

Title: How can I use this expression in query calculatio (source : TM1 / Cognos 10.2.1)
Post by: ersin.gulbahar on 04 Nov 2014 01:44:05 AM

Hi experts,
I have a prompt and its paramater is p_myparam
I want to use this expression : filter([xxx].[yyy].[zzz],caption([xxx].[yyy].[zzz]) contains ?p_myparam?)
But it does not work.
Because I think p_myparam is member unique name. I want it display name but it is possible? I use in report expression ParamDisplayValue('p_myparam') but I do not use this because I need this in data item.so it become ?p_myparam?,
How can I solve this issue?

thanks in advance

Title: Re: How can I use this expression in query calculatio (source : TM1 / Cognos 10.2.1)
Post by: CognosAnalytics on 04 Nov 2014 06:43:07 PM

Hello ersin.gulbahar,
You can set the Use value of the prompt as caption([data item]). If you are using the MUN in any other query on the report, then you can construct the MUN using the Value returned by the p_myparam.

-Cognos810

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: ersin.gulbahar on 04 Nov 2014 01:44:05 AM