Hi everyone, I have a query which runs fine on Bex Analyzer (excel) and this has variable 0P_FPER for 0FISCPER. When run on excel and matchcode (F4) is pressed, I am able to select a fiscal period and the correct value is transfered to the variable.
However, when the same query is run on BEx Web and the matchcode is used, an incorrect period+year is returned.
On Excel:
when selected it returns 001.2008 for January 2008
On Web:
when selected it returns 001 08 for January 2008, and reports that the value is not valid
The URL changes from
http://server:1080/sap/bw/BEx?CMD=LDOC&QUERY=ZFC_MC_03_R004
to
http://server:1080/sap/bw/BEx?SAP-LANGUAGE=S&PAGENO=1&CMD_ID=1&REQUEST_NO=1&SUBCMD=CMD_F4&VAR_VALUE_LOW_EXT_3=008%04&F4CMD=FINISHED
and the value "008 04" is transered to the variable.
This is on BI 7.0 sp 17, does not happen on BW 3.5.
Has anyone experienced this ?
Any ideas where to look at ?
Thanks
Marco