cancel
Showing results for 
Search instead for 
Did you mean: 

BW query connection, no data available in Dashboard

0 Kudos

Hi Experts,

I have a problem with a Dashboard that I'm developing, the problem is that the SAP netweaver BW connection (I have 3 connection with problems) has some intermittence, with the same filters sometimes They returns data correctly but sometime don't show any data. I check the filters that I'm sending but there always the same values for this test, I also check with fiddler application the XML send between the systems and looks the same. Has Anyone had a similar problem?

These are some screenshot of part the XML sent between systems, the first  results OK, but the second return no data.

XML SEND TO BW - TEST 1

RESPONSE OK - TEST 1

XML SEND TO BW - TEST 2

You can see that the query Variables receives the same values like test 1.

RESPONSE NO_DATA_AVAILABLE - TEST 2

Thanks for any help!

Regards,

Rosmar Torres

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

I solve this problem, the optional variables of the query was not cleaning the values when you send blank value to get all data, to solve this I had to create a set of optional variables for each query and now Works. I don't understand what really made this error occur, but the change of variables Works.