Filter Query in dropDown box in WAD 3.x

[Former Member]

Hello,

I need to filter the dropDown values ​​dynamically, This is the data:

- DROPDOWNBOX_1 (Infobject ZUN_T) Values: 1,2, All

- DROPDOWNBOX_2 (Infobject ZZO_T) Values: 1-1,1-2, 1-3, 2-1, 2-2, 2-3.

the ZZO_T infobjeto has a hierarchy that depends on ZUN_T:

ZUN_T -> ZZO_T

1 -> 1-1, 1-2, 1-3

2 -> 2-1, 2-2, 2-3

What I need is that when I select a value of dropDown1, dropDown2 automatically updated with valid values​​.

Any ideas?

<P><select name="VAR_VALUE_EXT_1" >
<object>
         <param name="OWNER" value="SAP_BW"/>
         <param name="CMD" value="GET_ITEM"/>
         <param name="NAME" value="DROPDOWNBOX_1"/>
         <param name="ITEM_CLASS" value="CL_RSR_WWW_ITEM_FILTER_DDOWN"/>
         <param name="DATA_PROVIDER" value="DATAPROVIDER_2"/>
         <param name="GENERATE_CAPTION" value=""/>
         <param name="IOBJNM" value="ZUN_T"/>
         <param name="ONLY_VALUES" value="X"/>
         <param name="NO_REMOVE_FILTER" value="X"/>
         <param name="TARGET_DATA_PROVIDER_1" value="DATAPROVIDER_2"/>
         <param name="FILTER_IOBJNM" value="ZUN_T"/>
         <param name="FILTER_VALUE" value="UN01"/>
         ITEM:            DROPDOWNBOX_1
</object>
</select> </P>

<P><select name="VAR_VALUE_EXT_2"  >
<object>
         <param name="OWNER" value="SAP_BW"/>
         <param name="CMD" value="GET_ITEM"/>
         <param name="NAME" value="DROPDOWNBOX_2"/>
         <param name="ITEM_CLASS" value="CL_RSR_WWW_ITEM_FILTER_DDOWN"/>
         <param name="DATA_PROVIDER" value="DATAPROVIDER_1"/>
         <param name="GENERATE_CAPTION" value=""/>
         <param name="IOBJNM" value="ZZO_T"/>
         <param name="BOOKED_VALUES" value="Q"/>
         <param name="ONLY_VALUES" value="X"/>
         <param name="TARGET_DATA_PROVIDER_1" value="DATAPROVIDER_2"/>
         <param name="FILTER_IOBJNM" value="ZUN_T"/>
         <param name="FILTER_VALUE" value="UN01"/>
         ITEM:            DROPDOWNBOX_2
</object>
</select></P>

I am new in BW, and do not know if the query is fine, please tell me the complete steps,

Thanks.

[former_member183777]

In the query definition of ZZO_T, review the properties / advanced tab. Set the list of values for filters to only the ones posted in InfoCube.

[Former Member]

Hello Vineet,

I can not find the advanced tab, is in the query designer 3.x?

Thanks.