cancel
Showing results for 
Search instead for 
Did you mean: 

Execute BEx queries at the same time

michael_vk
Explorer
0 Kudos
409

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
Active Participant
0 Kudos
"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
Explorer
0 Kudos

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
Active Participant
0 Kudos
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
Active Participant
0 Kudos
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
View Entire Topic
michael_vk
Explorer
0 Kudos

Dear Savio,

In sm50 I see running only first query, running second query not showing. As second query I can use absolutely any other query and situation will be the same.