how to Limit the prompt values based on the result of the analysis?
Content
I'm creating a validation report in OTBI which contains Employment data of contractors. The requirement is to be able to prompt on Business Unit. I want the list of values in the business unit name prompt to be limited to the business units that are available in the result of the analysis.
How can I do this?
I have tried to create an analysis which has the same logic and results in merely the BU's as a result (A). In my actual analysis I wanted to use the first analysis (A) to filter the BU's, hoping that this would result in a limited amount of business units in the prompt field as well.