Skip to Content
0
Former Member
Jul 27, 2005 at 06:09 AM

BW Web Query Passing Date Interval Values

36 Views

Hello,

This is my first use of SDN, so please forgive my ignorance.

I am J2EE developer, recently we have a requirement to stream BW Query results so that they can be selectively manipulated in one of our systems.

Unfortunately the team that designed this query is new to web query approach itself. I have the query URL with me. After reading some SAP BW documentation, I found that it is possible to pass VARIABLE_SCREEN=%20 (which is similar to not passing this variable at all) to avoid the parameter page that appears upon url execution. Also I was able to understand the parameter passing mechanism.

I have two parameters to pass

1. Customer Code (single value)

2. Date - Interval.

Regardless of whether the retrieval is through parameter page or not, the criteria for providing the customer code works properly giving the right results.

When I use the parameter page and pass a date interval like 02012004 - 02252004, it retrieves the data exactly the way it should, however when i use the query string like VAR_NAME_1=ZBIL_DT&VAR_VALUE_LOW_EXT_1=02012004&VAR_VALUE_HIGH_EXT_1=02252004 it completely ignores the criteria and retrieves the complete result as if there were no interval on the date at all.

I would appreciate all the help on this.