If you are unable to create a new account, please email support@bspsoftware.com

 

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

Started by ersin.gulbahar, 04 Nov 2014 01:44:05 AM

Previous topic - Next topic

ersin.gulbahar

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

cognos810

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