Frequently Asked Question
Making a cascading N4V list of values controls
Last Updated 3 years ago
Symptom
- Create two linked lists of values.
Environment
- SAP BusinessObjects Business Intelligence Platform : all 4.2/4.3 Webi versions
- Need4Viz : all versions
Procedure
- Create a Webi report with a bloc containing 2 linked dimensions. In the following example we have the name of the buses stations and the status of the station
- Create an Input Control (simple list of values) based on the name and affect it to the Webi bloc
- Create an Input Control (simple list of values) based on the status and affect it to the Webi bloc
- Create a N4V List of value based on the name, add "all values" and affect it the "name" Input Control
- Create a N4V List of value based on the status, add "all values" and affect it the "status" Input Control
- Update the Input Control based on the status and affect the N4V List "name" bloc to it
- In the global settings of the N4V list status, tick the reset "Input Controls when selection is done" :
If you want to only reset the IC based on the name (and not all your report IC), just set it as :
And now, by filtering the first list, we filter the block and the second list :
By filtering then in the second, we filter the block :
Selecting a value from the first list resets the second list :