You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Configure Prompt acting like a nested query?

in Reporting and Analytics for SCM

Summary:

How to configure Prompt acting like a nested query?

Content (please ensure you mask any confidential information):

Hi Experts,

Would like to reach out to you to explore the features available around Prompt in a Analysis OTBI report.

Please refer to below screenshot, that currently I am using the standard Column Prompt on "Performed By" field (renamed as Approver), and the result would get me as showed in #2, only the selected "Performed By" approver is showing in the result.

May I ask if there's a way to configure the Prompt acting like a nested query, that if I search for "Performed By" of Mr. Ken Li, the result to get me all the PRs that had Mr. Ken Li as one of the approvers, and also showing the other approvers in those same PRs. The desired result would be like #1.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!