cancel
Showing results for 
Search instead for 
Did you mean: 

Live Connection resultset issue

rafal_skorupa1
Explorer
0 Kudos
449

Hello Experts

I have noticed following issue related to query refresh behaviour in BW Live connection setup.

I can not build any logic that is based on values comming from a resultset. Meaning that resultset is empty after each table change. I have a simple logic to:

1.change variables

2.pull resultset

3.add dimension

4.pull resultset

It seems getResultSet doesn't wait until refresh is completed:

It completely changes when I change this table to use table variables instead of Application variables.:

It properly displays resultset after each change:

Can anyone explain why it behavies like this? I checked it with acquired data models and it works fine as well- resultset reads data imidietly after table change. In my opinion somehting had to change for live connection.

Regards

Rafał

Accepted Solutions (0)

Answers (1)

Answers (1)

Bob0001
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi rafal.skorupa, this is not expected, please file a ticket to SAP about this. Are you using linked variables?

rafal_skorupa1
Explorer
0 Kudos

Hi bob.meincke

I am not using linked any linked variables in this example. We have an open ticket with SAP 465074/2022 related to variable change behaviour - I guess something changed with variable container. setDimensionFilter method defined right after SetVariableValue stopped working as well.

Anyway thanks for confirmation- It was driving me crazy last days.

Regards

Rafał