Skip to Content
0
Apr 13 at 02:26 PM

SAP Datasphere + Remote Query Monitor: what is Transaction?

235 Views

Hi,

I have created very simple flow:

BW4/HANA Composite Provider - Datasphere Remote Table - Datasphere View (Analytical Dataset) - SAC Story (one chart only).

The flow is working, means - I see data in the bar chart in SAC, and the flow is fully virtual: no materialization in Datasphere. I refresh the SAC story couple of times just to see it is stable, what is the performance etc.

Can someone explain, please, what is Transaction in Remote Query Monitor? SAP Help says it 'Displays the remote source transaction'. What is it for BW4/HANA? Can I find it in BW4 somehow and check what was run in BW4?

Some other concerns I have:

  • In general, 21 seconds for 104 rows is not so great. What is even worse is that sometimes it is 21 seconds, sometimes it is more than 40 seconds. A bit unstable. Based on that I expect that if my chart is used by hundreds of users, the performance wouldn't be fantastic.
  • In Remote Query Monitor I don't see the user ID or even from where the statement was executed (SAC in my case). Let's imagine someone is running super heavy statement and ask for millions of rows. I can't even see who is doing that...

image.png

Attachments

image.png (140.3 kB)