Showing results for 
Search instead for 
Did you mean: 

Workaround for Custom query script webi report prompt optional in User Prompt Input

Former Member
0 Kudos

Hi Experts,

We developed Webi report with custom query script and we would like to show BU prompt as optional in report level.

Optional prompts doesn't work in custom query script, so we make it as mandatory prompt in Custom query script.

Any workaround for this issue.

Thanks in advance


Ravi Shankar

View Entire Topic
Active Contributor
0 Kudos

You can create a derived table in universe (or view in database if possible) with your script and use the objects from that table in webi and create optional prompt in webi query panel itself.

Former Member
0 Kudos


Thanks for the solution.