How to aggregate city by state in input control of webi

[Former Member]

Hello Experts ,

I have a requirement where i need to provide two input controls(dropdowns) in Webi Report

First input control will be state and second input control will be cities relates to the selected state from state input control.

which am unable to achieve.

BO 4.0 sp4

Need Help!!!

Regards

Sushma

[former_member201488]

I don't believe this is possible with Input Controls just yet - the feature is on the drawing Board for 4.2 though - "Cascading Input Controls".

Consider using normal filter dropdowns, which should work as expected (if the hierarchy is designated at the Universe, IIRC).

HTH

NMG