BW Web Query Passing Date Interval Values

[Former Member]

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.

[Former Member]

Hi Zakir,

you are missing two other parameters in the URL which are mentioned below.

1) VAR_OPERATOR = EQ or GT or LT or BT etc..

2) VAR_SIGN = I or E (inlude or Exclude)

and you have to pass the date in external format as mentioned in other reply.

Regards

Madhukar

[Former Member]

Is this URL QueryStrig Ok? (this would be appended to the server url)

%2F is hex for /. I have low value 02/17/2005 and high value 02/21/2005

var_name_1=customer&var_value_ext_1=510000&var_name_2=zbil_dt&var_operator_2=BT&var_value_low_ext_2=02%2F17%2F2005&var_value_high_ext_2=02%2f21%2f2005&var_sign=I

If it is then it is still not working. Any idea why?

[athavanraja]

just pass the dates in user specific format without separators, the system will automatically put the separators.

for example for 02/17/2005 just pass 02172005 .(provided the user specific format is MMDDYYYY .

Regards

Raja

[Former Member]

use the date separators.

for example: 01/02/2005