on 06-21-2021 12:25 PM
Dear SAC Community,
I would like to collect some thoughts about SAC & Live Data Connection (we are using live connection to BW4 2.0).
From one side, Live Data Connection is great from the maintenance perspective:
However, Live Data Connection brings some serious downsides:
I really appreciate Live Connection in SAC, I really do. However, with number of challenges, sometimes I think that maybe import connection would be better. I would love to confront my opinion with someone else – what is your opinion about Live Connection? How stable is your setup?
Thanks in advance for any inputs, comments, thoughts!
Hi Roland,
I do have a question for you and others.
Is there a limitation to the number of rows to be displayed while executing a SAC story in tabular format using live connection with S4 HANA systemin the backend..
Can the user see 2 million rows of data in a SAC Tabular format story?
For Example, we have multiple hierarchy nodes and we would like to expand and hence huge amount of data to be displayed.
Thank you,
Amar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
member123 could you please tell me how many cells of data can be pulled at a single shot in classical story table. If you have found the answer.
We have a story with single table with 18 columns and 10 input controls. Story built using Hana calculation view using live connection. When i open/run the report i get the message
"The data cannot be displayed: the query process was stopped before it finished because it returned too many records. Please try filtering your data.
Correlation ID: 37445833-5520-4986-b140-117643641833"Thank You
Hello mateusz_mikulski
See my recent Blog - next Mystery solved – proper SAC Connection
After I have provided some Test Systems based on 7.50 and BW/4 2.0 to the SAC Development, the so called "live connection" is the best approach.
the main challenges from my side is, that there are still way too much data is send to SAC and also too much calculation are done on the SAC instance before sending the data to the End User.
If the SAP BW(/4) would be used more for what it stands for, e.g. OLAP processing, calculations, planning, consolidation, etc. and only sending the needed data to SAC the response would be quicker, the Network Stream lower and the overall Performance much better.
Finally: data sovereignty. with live connection no (sensitive) customer data is transferred and (even temporary) stored on the Amazon Hyperscaler Platform were SAP Analytics Cloud is build on has left the Company premises.
Blog - why SAP BW/4HANA?
Best Regards Roland
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.