Sunday, March 9, 2025

SAC Live connection with Two sources

Combining Live Connections in SAP Analytics Cloud

Combining Live Connections in SAP Analytics Cloud

1. SAC Live Connections – Key Considerations

Live Connections are real-time: Data is not stored in SAC but is fetched directly from the backend (SAP S/4HANA, BW, HANA, etc.).

No data blending across two Live Connections: SAC does not support native data blending between two Live Connections.

Limited transformations & calculations: Since data is not replicated in SAC, advanced modeling features are restricted.

2. Possible Workarounds

A. Use Data Acquisition Instead of Live Connection

If you need to combine data from two Live sources, consider importing (data acquisition) into SAC. This allows data blending, calculations, and transformations.

However, this approach loses the real-time aspect of Live Connections.

B. Merge Data at Source (Backend Approach)

If you are using SAP BW or SAP HANA, create a Composite Provider, Calculation View, or CDS View that merges data at the backend.

This way, SAC sees it as a single Live Connection with all required fields.

C. Create a Multi-Source Universe (For HANA)

If connecting to SAP HANA, you can use HANA Calculation Views with joins/unions across different data sources.

D. Use Cross-System Queries (For SAP BW)

In SAP BW, use MultiProviders, CompositeProviders, or Open ODS views to combine data across different BW sources.

E. Use Data Federation via SAP Datasphere

SAP Datasphere (formerly Data Warehouse Cloud) can act as an integration layer for multiple Live Connections before SAC reporting.

3. Reporting Considerations

If you just need to display data from two Live Connections without merging them, create separate widgets/pages in SAC stories.

Use Linked Analysis in SAC to synchronize filtering across two Live data sources.

Conclusion

You cannot directly combine two Live Connections in SAC for calculations, but using backend modeling (HANA/BW), Data Acquisition, or an intermediate layer like SAP Datasphere can help you achieve your goal.

Would you like specific guidance based on your data sources (e.g., S/4HANA, BW, HANA)?

No comments:

Post a Comment

Fiori Development - Style

Okay, here is a rewritten version incorporating the detailed information about developing preformatted layout reports, including a Table of ...