How to limit prompt values to values displayed on analysis - OTBI
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.
Tagged:
0