Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    May 24, 2006 at 02:27 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 25, 2006 at 06:20 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 05, 2007 at 02:57 PM

    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..

    Add comment
    10|10000 characters needed characters exceeded