Skip to Content
0
Nov 04, 2004 at 09:20 PM

Assigning a DataProvider filter value with JavaScript

28 Views

I have a "Fiscal Yr/Period" filter characteristic in my web application that I am assigning the value of the current month and year when the web application is loaded. In other words, this filter is applied to the DataProvider when the application loads (code below):

<object>

<param name="OWNER" value="SAP_BW"/>

<param name="CMD" value="SET_DATA_PROVIDER"/>

<param name="NAME" value="C_LPR_Q018"/>

<param name="QUERY" value="C_LPR_Q018"/>

<param name="INFOCUBE" value="ZPP_C01"/>

<param name='FILTER_IOBJNM' value='0FISCPER'/>

<param name='FILTER_VALUE' value='H12004010'/>

DATA_PROVIDER: C_LPR_Q018

</object>

As you can see above, the value for the '0FISCPER' object is hardcoded and thus requires me to change this monthly. I have written some JavaScript code to calculate the current mo. and yr. however I can't get my JavaScript variable that holds the value I need assigned to the FILTER VALUE. Can I even assign a JavaScript variable as the filter value? Is there another way? Any help would be greatly appreciated.