BEx Variable Screen After Initial Entry Pre-populates fields with Hash Mark

[Former Member]

The following sequence is causing issues with BEx Queries running in Portal

1. Run the query with no filters resulting in a full listing

2. Use the u201Cvariable screenu201D button to open the variable entry screen u2013 all the blank entries have all been replaced with a literal u201C#u201D (hash mark)

3. Press the OK button without modifying any variables u2013 no results are returned

4. Try again, this time deleting the literal "#" (hash mark)

5. Results are returned as expected (the query returns values as if no filters)

There should be no need to have to delete the hash marks to run the query, the Variable Entry screen should come up blank when sumoned.

[Former Member]

check to see if the 'default values' for the variables have been set to '#'

[Former Member]

Checking in BEx Query Designer, the Filter tab, clicking on any of the InfoObject attributes in the Default Values panel, then on the Default Values tab of the Properties panel shows no values selected for any of the selected items.

[Former Member]

not over there. when you create a varibale on a characterisctic, the variable will have default values.

Please check to see in the variable definition and change it.

[Former Member]

It apears that the problem was caused after applying NW SPS 16.

Problem was resolved by applying SAP Note 1168964.

thansk for the input!