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

How to limit prompt values to values displayed on analysis - OTBI

edited Oct 9, 2024 5:18PM in Reporting & Analytics for Sales 3 comments

Summary:

I'm building an analysis using the "Incentive Compensation - Attainments Real Time" subject area. One of the prompts in the dashboard that includes this analysis is "Participant". The problem is that the prompt shows every single participant in the environment, but the customers requires that the prompt only shows Participants that have data.

For example, in dev environment, we have many test participants that have no data whatsoever, they are not even assigned to compensation plans, and they still show up as an option in prompt. If we select one of these participants, the report returns an error claiming there is no data to display, which is true. But if there is no data to display, whe would like them to not be an option.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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