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

[Former Member]

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

Regards

Ravi Shankar

[arijit_das · Accepted solution]

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 · Accepted solution]

Hi,

Thanks for the solution.

[Former Member]

Hi,

Dont put any prompt in script level for BU field, then use BU as an optional prompt in WEBI Report level.

Thanks & Regards,

Srinu.Rapolu