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.