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.