Hello everyone,
Could you please advice how I can change the below code in BACC/Cognos, in order to catch multiple values and not just one?
For one of the reports, I have a detailed filter with syntax:
[Business View].[T_DETAILS a1].[GBG_NAME a1] in ('%'+upper (?pGBG_Name?)+'%')
It is working fine, but in the Prompt it allows me to insert just one value, and not multiple. I have changed the Prompt properties to be Multi select = "Yes" and Multi-line = "Yes"
I need to keep the wildcards but at the same time to be able to insert multiple values in the prompt.
If I change the code to [Business View].[T_DETAILS a1].[GBG_NAME a1] in (upper (?pGBG_Name?)) it works fine, it allows to me insert multiple values in the Prompt, but i need to keep the wildcards as well.
------------------------------
Denitsa Pavlova
------------------------------
#CognosAnalyticswithWatson