Input Control Creation/Implementation in Webi
Hope you all having great time! We have a crazy requirement. Actually let me give you a little bit background first.
As shown in below image we have tables CA_STAT_TAB, MO_STAT_TAB etc... for all US 50 states. i.e., 50 tables we have.
So now the requirement is we need to show all the 50 tables in the webi report in alphabetical order and one below the other like shown below and then we will have an input control called region (as shown below) which will be used to see the states belonging to specific region. by default it is all regions with all states shown and when user selects East coast (lets say) the other will hide and Eastern states will be left.
This pretty much looks like a normal input control, but the problem is each state is coming from a individual table and we don't have any pre-defined object for regions which we can use. So guys, please help me implement this functionality.
Appreciate your responses . FYI. We are on BO 4.1 and Teradata backend