Passing drop down box values to web item "table" to filter table contents
Hi,
I am trying to pass "drop down box" values to table. this is what i am doing.
i want the report not to be executed before making selections out of dropdown box.
I've 2 data providers one for dropdown box(DATAPROVIDER_1) and one for table (DATAPROVIDER_2).
DATAPROVIDER_2 is empty without any query.
based on the drop down box selection, I am resetting the DATAPROVIDER_2 to DATAPROVIDER_1 and also trying to pass drop down values to table.
I could able to reset the DATAPROVIDER_2 but i am not having any luck to pass the drop down selected values.
after i select a value from drop down box, data provider (DATAPROVIDER_2) is being reset and all the values are being displayed in the table but i want only records of those drop down selected value.
I appreciate if you can help me. here is the code.
<HTML>
<!-- BW data source object tags -->
<object>
<param name="OWNER" value="SAP_BW"/>
<param name="CMD" value="SET_DATA_PROVIDER"/>
<param name="NAME" value="DATAPROVIDER_2"/>
<param name="DATA_PROVIDER_ID" value=""/>
DATA_PROVIDER: DATAPROVIDER_2
</object>
<object>
<param name="OWNER" value="SAP_BW"/>
<param name="CMD" value="SET_DATA_PROVIDER"/>
<param name="NAME" value="DATAPROVIDER_1"/>
<param name="QUERY" value="Q3"/>
<param name="INFOCUBE" value="IC2"/>
DATA_PROVIDER: DATAPROVIDER_1
</object>
<object>
<param name="OWNER" value="SAP_BW"/>
<param name="CMD" value="SET_PROPERTIES"/>
<param name="TEMPLATE_ID" value="VARIABLE_DROPDOWN_1"/>
TEMPLATE PROPERTIES
</object>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft DHTML Editing Control">
<TITLE>BW Web Application</TITLE>
<link href= "/sap/bw/Mime/BEx/StyleSheets/BWReports.css" type="text/css" rel="stylesheet"/>
<script language="JavaScript">
function setVariable(a){
url = "<SAP_BW_URL>"+ "&DATA_PROVIDER=DATAPROVIDER_2&CMD=RESET_DATA_PROVIDER&INFOCUBE=IC2&QUERY=Q3&FILTER_IOBJNM=ZHIER01&FILTER_VALUE=" ;
url = url + a;
SAPBWOpenURL(url);
}
</script>
</HEAD>
<body>
<P>
<b> CustHier :</b> <select name="ZHIER01" class="SAPBexDdI" onchange="setVariable(options[selectedIndex].value);" size="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_1"/>
<param name="GENERATE_CAPTION" value=""/>
<param name="IOBJNM" value="ZHIER01"/>
<param name="MAXVALUES" value="1000"/>
<param name="SHOW_LABEL" value=""/>
<param name="ONLY_VALUES" value="X"/>
<param name="NO_REMOVE_FILTER" value="X"/>
ITEM: DROPDOWNBOX_1
</object>
</select>
</P><object>
<param name="OWNER" value="SAP_BW"/>
<param name="CMD" value="GET_ITEM"/>
<param name="NAME" value="TABLE_1"/>
<param name="ITEM_CLASS" value="CL_RSR_WWW_ITEM_GRID"/>
<param name="DATA_PROVIDER" value="DATAPROVIDER_2"/>
ITEM: TABLE_1
</object>
<P></P>
</body>
</HTML>