Piggybacking Data Filters with Input Controls in WebI
We recently received a question about Input Controls in WebI, so we thought we'd share our response as there must be others with the same concerns!
Question
Suppose I wanted to add an additional level to my filtering when using the Input Control function. For example, if I would like to see data pertaining to Chicago, I would select Illinois in the first entry field, then the only options on the next level would be cities in Illinois. From here I would obviously select Chicago.
Currently, I can only pull in a list of every city in the United States as a secondary filter. Is there anyway to piggyback the city filter on the state filter?
Answer
Option 1
Input Controls cannot be piggy-backed in the manner that you are describing. You can use the filter bar to perform this task, the filters will affect each other in a way that input controls do not.
Figure 1-1
Figure 1-2
Tip: Webi can be complicated. Our expert SAP BusinessObjects consultants can help. See how or contact us.
Option 2
The other option is to use the linking feature in WebI 4.x to filter your data down and this will also reduce the options in a hierarchical manner in the manner that you are describing (i.e. when you click on Illinois in a table/graph only those cities will appear in another table/graph).
Figure 2-1
Figure 2-2
For more information, check out the video on Innovative Use of Input Controls in WebI: Tutorial
SAP BusinessObjects Consulting Services »
If you have any further questions about input controls, don't hesitate to reach out to us below!
