Skip to Content
author's profile photo
Former Member

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>

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Apr 13, 2004 at 11:11 AM

    Is this BSP you are using? (In that case I'll move your message to the right forum...)

    Add comment
    10|10000 characters needed characters exceeded