Filtering one dropdown on the basis of value from another dropdown in WAD

[Former Member]

Hi All,

i have a bw dropdown called 'Corporate' and another called 'Facility'. there can be several facilties under a Corporate.

what i need to do is filter the facility dropdown on the basis of the value selected in the corporate dropdown.

thanks in advance

Godhuli

[Former Member]

Hello,

How to have this functionality in the BI 7.0 ?

I dont see the "posted value" option in the properties..

As well, even if i set the DP as an 'affected' data provider, I still see the full list..

I thought once we set it as a affected Dataprovider, it will automatically refresh the dropdown..

[Former Member]

Hi Godhuli,

You can achieve this by the following procedure.

For your Corporate dropdown you need to specify a DataProvider.

For Your Facility dropdown you need to specify a Dataprovider.

For the Corporate dropdown there is a property "Affected DataProvider".

In that property select the DataProvider of your Facility dropdown.

So now when you select Corporate your Facility will get filtered by the values for that selected Corporate dropdown value.

Hope it helps.

Regards,

Parth.

[Former Member]

Godhuli,

Change the values in the facitlity drop down to posted values only. You should be able to do this in the property setting of the dropdown in the template.

Cheers

Aneesh