Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Filter Query in dropDown box in WAD 3.x

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 Member
Not what you were looking for? View more on this topic or Ask a question