Combining Live Connections in SAP Analytics Cloud
Table of Contents
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