Hi, team!

I am trying to add a text prompt to my report, but it is not working.

I am using the Expression "[C].[C_opera_module_QIW_DB].[All_Opera_Deals_View_1_1].[OPP_ID] contains ?Parameter1?" as a query filter.
The object I am using is 'Text box prompt'.

What am I doing wrong?
Thanks!

------------------------------
Sergio Marinho da Silva
------------------------------

#CognosAnalyticswithWatson

Hi Sergio,

You might want to change your detail filter to Optional:

From the query window, click on your detail filter. Make sure the Properties page is displayed then change usage to Optional.

From your text box prompt, make sure you have the following:

The parameter name should be the same each time.

You can run your report without a value for your parameter, so you will see the available value for [C].[C_opera_module_QIW_DB].[All_Opera_Deals_View_1_1].[OPP_ID]...

In my case, just for the explanation:

Best regards,

------------------------------
Patrick Neveu
Positive Thinking Company
------------------------------