You've highlighted a critical point of contention, and it's essential to clarify the nuances of live connections with the SAC Excel Add-in. You are correct to point out the conflicting information.
Here's a breakdown to reconcile the apparent contradiction:
The Core Issue: How "Live Connection" is Interpreted
- Traditional SAC Live Connections:
- As you correctly stated, these connections, particularly to sources like S/4HANA or BW, operate by querying the source system directly when a user interacts with a story.
- Data is not stored within SAC itself.
- SAP Datasphere Live Connections:
- SAP is increasingly emphasizing SAP Datasphere as a central data layer.
- Live connections from the SAC Excel Add-in to SAP Datasphere analytic models are supported.
- This is a different type of live connection, where the semantic layer resides in Datasphere.
Why the Discrepancy?
- The initial information you provided, stating "No, SAP Analytics Cloud (SAC) Excel Add-in does not support Live Connections for reporting," is primarily accurate when referring to traditional live connections directly to source systems like S/4HANA or BW.
- The newer information about live connections from the SAC Excel add in, is referring to live connections to SAP Datasphere analytic models.
- Therefore, the accuracy of the statement depends on what type of live connection is being discussed.
In Summary:
- Direct live connections from the SAC Excel Add-in to S/4HANA or BW are generally not supported.
- Live connections from the SAC Excel Add-in to SAP Datasphere analytic models are supported.
- The add in is designed to work with SAC models, and Datasphere provides the model, that the add in can work with.
Therefore, the information you provided regarding the limitations of live connections from S/4Hana and BW, directly to the SAC excel add in is correct.
I hope this clarifies the situation.
No comments:
Post a Comment