Question:
Hi everyone,
If you have a query with variable selection screen, when you execute this query on BEx analizer, a pop-up requesting the variable value is displayed.
If you publish this query on the web, when you execute it, first of all, a web page is displayed requesting the variable value and when you push the "Execute" button the query data is displayed.
We want this 2 steps to be in the same web page. We need to have the upper side of the web page with the "selection screen" and the lower side of the web page with the actual data. We also want that when you modify the variable value and push again "execute" it refresh the query data.
We try to do this but we are unable. One possible solution would be using the web item "filter" and filter the query data according to our needs. Theorically this could possible, but the problem is the performance because you have to read a lot of data from the database.
(Data are not filtered when reading database but when showing data on the web).
Does anyone knows how to solve this issue?
Thanks in advance.
Manuel.
Answer:
we are trying to solve the same issue. Any help???
Answer:
Here is how I solved the same issue I think you are referring to.
The HTML form tag and in particular the action property of the form tag dictates what action is to be taken when the HTML form is submitted to the server. The parameters on the action tag tells the server what query to process, what infocube to use and what filters and variables to apply to the query. Also note in the code below that the HTML input fields are located between the form tags.
The positioning of the input field between the forms tags causes the fields to be passed to the BW server via the HTTP headers. This field is then interpreted by the server and because of the naming conventions used, the input field (VAR_VALUE_EXT_1) is associated with the variable in the action property of the forms tag (VAR_NAME_1). The input field (VAR_VALUE_EXT_2) is associated with the variable in the action property of the forms tag (VAR_NAME_2) Ultimately the query is then executed using the variable values passed to the server.
Below is code demonstrating my solution . The values for Var_Name_1 are hardcoded in a Select statment with a name VAR_VALUE_EXT_1. The values for var_name_2 are displayed in a BW dropdown box that is associated with a BW Query and wrapped in a select statement with the name var_value_ext_2. An input button is provided that will execute the applyParms() Javascript that will again call this template with the parameters selected from the dropdown list and dropdown box.
Here is the code:
<object>
<param name="OWNER" value="SAP_BW"/>
<param name="CMD" value="SET_PROPERTIES"/>
<param name="TEMPLATE_ID" value="ZCM_C01_WT135_PARMS_I"/>
<param name="SUPPRESS_SYSTEM_MESSAGES" value="X"/>
<param name="SUPPRESS_WARNINGS" value="X"/>
<param name="ENABLE_OPEN_WINDOW" value=""/>
<param name="RRI_DISPLAY_TARGET" value=""/>
TEMPLATE PROPERTIES
</object>
<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="QUERY" value="ZCM_C02_QRM0031_1"/>
<param name="INFOCUBE" value="ZCM_C02I"/>
DATA_PROVIDER: DATAPROVIDER_2
</object>
<object>
<param name="OWNER" value="SAP_BW"/>
<param name="CMD" value="SET_DATA_PROVIDER"/>
<param name="NAME" value="DATAPROVIDER_3"/>
<param name="QUERY" value="ZCM_C01_MCUR"/>
<param name="INFOCUBE" value="ZCM_C01I"/>
DATA_PROVIDER: DATAPROVIDER_3
</object>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft DHTML Editing Control">
<TITLE>BW Web Application</TITLE>
<link href="/sap/bw/Mime/Customer/StyleSheets/BWReports_Option3.css" type="text/css" rel="stylesheet"/>
<SCRIPT language="Javascript">
applyParms(){
//
// Pass variable parms to the same template
//
document.forms("form1").action="/sap/bw/BEx?CMD=ldoc&INFOCUBE=ZCM_C01&TEMPLATE_ID=ZCM_C01_WT135_I&VARIABLE_SCREEN=&VAR_NAME_1=ZCM_CTRY&VAR_NAME_2=ZTARGET"
}
</SCRIPT>
</HEAD>
<BODY >
<br><br>
<TABLE cellSpacing="0" cellPadding="0" width="544" border="1" align="left" style="FONT-SIZE: 8pt; WIDTH: 544px; FONT-FAMILY: Arial; HEIGHT: 123px">
<CAPTION></CAPTION>
<TR>
<TD class="SAPBEXBorderFlexBoxTtl" > Country Grouping:</TD>
<TD class="SAPBEXBorderFlexBoxTtl" > Currency:</TD>
</TR>
<TR>
<!-- Note the form statement
Note the name of the Select Statement (VAR_VALUE_EXT_1)
Note the name associated with the Drowpdown box (VAR_VALUE_EXT_2) and it is associated with DataProvider_3 which points to a query
Note the Button Submit button which executes the applyParms function above
-->
<form name="form1" id="form1" method="post">
<TD align="left" valign="top" bgColor="#e0e0e0" width="200">
<select name='VAR_VALUE_EXT_1' style='FONT-SIZE: 8pt; FONT-FAMILY: Arial; WIDTH: 208px; HEIGHT: 73px' size='4'>
<option value="ZCM_CNTRY_EXJPN">All Countries excl. Japan</option>
<option value="ZCM_CNTRY_EXUS">All Countries excl. US</option>
<option value="ZCM_CNTRY_ASIAPAC_EXJAPAN">Asia-Pac. w/o Japan (12 CTY)</option>
<option value="ZCM_CNTRY_BIG_6">Big 6</option>
<option value="ZCM_CNTRY_EMEA">EMEA</option>
<option value="ZCM_CNTRY_EUROPE_20">Europe (20 CTY)</option>
</select>
</TD>
<TD align="left" valign="top" bgColor="#e0e0e0" >
<select name="VAR_VALUE_EXT_2" style="FONT-SIZE: 8pt; FONT-FAMILY: Arial; WIDTH: 208px; HEIGHT: 73px" size="4">
<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_3"/>
<param name="GENERATE_CAPTION" value=""/>
<param name="IOBJNM" value="0LOC_CURRCY"/>
<param name="BOOKED_VALUES" value="Q"/>
<param name="MAXVALUES" value="100"/>
<param name="SHOW_LABEL" value=""/>
<param name="ONLY_VALUES" value="X"/>
<param name="NO_REMOVE_FILTER" value="X"/>
ITEM: DROPDOWNBOX_1
</object>
</select>
</TD>
</TR>
<TR>
<TD>
<INPUT type="submit" value="Calculate" name="Submit" onclick="applyParms()">
</TD>
</TR>
</TABLE>
<P> </P>
<P> </P> <P> </P>
<P> </P>
<P>
<P> </P>
<P> </P>
<P>
<br><br></P>
<P>
<!--begin footer--></P>
<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>
<!--end footer--></P>
</FORM>
</BODY>
</HTML>
Hope this helps
Bob D.