Execute BEx queries at the same time

[michael_vk]

Dear Guru's,

May be you help me with the very strange situation. I'm not a specialist in SAP BW.

Situation:

In some of the workstations in the same window in different tabs of Google Chrome executing two different BEx query and on the second tab BEx query is waiting while query on the first tab is not finished and only after that is executing! In one of the workstations this situation is not repeat - the second query on the second tab executed regardless of the execution of the first query. What is the possible causes of this situation?

Thank you in advance.

[Savio_Dmello]

"In the workstations where the second query on the second tab executed regardless of the execution of the first query.", Sometime, the earlier result is saved in bex cache so Can you try changing the input variable values so that data is not picked from cache. You can also try deleting the cache before you reproduce the scenario. To delete cache try from WAD, menu tools -> setting -> delete cache -> delete cache. or transaction rsrt -> cache monitor -> delete.

[michael_vk]

Dear Savio_D,

What is the features I must disabled?

The video shows how I run BEx queries.

I've deleted the cache, but situation is the same.

Why on other workstation this problem doesn't appear?

[Savio_Dmello]

I saw the demo. I see that Ztest1 does not have any input variable. can you try by running Ztest first and then the DAYREPORT_... query simultanously in another tab with different selection dates . When these are getting executed, you can monitor the activity in tcode SM51 , It will show whether both queries are getting executed or something else is happening.

[Savio_Dmello]

is it only 1 workstation that has the issue or many workstation. Accordingly, You may have to open an incident with SAP product team to debug it

[michael_vk]

Ztest is executing very fast and I cannot repeat the situation vice versa. At the moment when queries are running, in sm50 I see only one working process:

[michael_vk]

Now, on one of the workstation where second BEx query was executing without delay, it's running incorrect (with delay).

No settings have been changed either in the system or in the browser!

[Savio_Dmello]

for Ztest query, can youadd more fields in row/columns and/or an input variable or to make it slow so that you get time to debug and check in sm50 . Also Did you try replication after disabling the cache option.