How to Hide a Prompt coming from Bex in Webi Report
Hi BOBJ experts,
I have a Report1 in Webi 4.0 built directly on Bex1.
There is a optional Prompt in Bex which is appearing in Webi Report1 Prompt. User wants this to be hidden.
How can I hide it?
Note: I cannot remove the prompt from Bex as other Webi reports are built on this same bex query. This optional filter needs to be removed only in Report1
When you are in the edit query mode, go to the variables settings.
Once in there you will be able to deselect the box for “Set as Prompt” for that particular line.
If you just do this and try to save it wont work.
You need to enter data in the mandatory prompts. We will get rid of these default values when we purge prompts step before saving the query.