Module 21: BW/4HANA & SAP Analytics Cloud (SAC)
SAP Analytics Cloud (SAC) is SAP's strategic analytics platform and the primary consumer of BW/4HANA analytics in modern landscapes.
A correct connection, security, and performance design determines whether SAC becomes an asset or a bottleneck.
This module covers:
- Live connection
- Import connection
- BW Queries in SAC
- Security integration
- Performance considerations
1. SAP Analytics Cloud in BW Landscape
Role of SAC
- Visualization & dashboards
- Self-service analytics
- Planning & predictive analytics
- Web & mobile access
BW/4HANA → BW Query → SAC Story
BW remains the system of record; SAC is the system of insight.
2. Live Connection (Recommended)
2.1 What is a Live Connection?
A live connection means:
- SAC queries BW/4HANA in real time
- No data is stored in SAC
- All calculations execute in BW/HANA
Characteristics
| Aspect | Live Connection |
|---|---|
| Data storage | BW only |
| Latency | Real-time |
| Security | BW authorizations |
| Data duplication | None |
| Governance | Strong |
Typical Use Cases
- Enterprise dashboards
- Financial & sensitive data
- Large datasets
- Centralized governance
For BW/4HANA, live connection should be the default choice.
3. Import Connection
3.1 What is an Import Connection?
An import connection:
- Copies data from BW into SAC
- Stores data in SAC models
- Refreshes on schedule
Characteristics
| Aspect | Import Connection |
|---|---|
| Data storage | SAC |
| Latency | Scheduled |
| Security | SAC roles |
| Modeling | SAC-side |
| Performance | UI-fast |
Typical Use Cases
- Predictive scenarios
- Planning models
- Lightweight datasets
- Offline analysis
Import connections break the single source of truth principle.
4. Live vs Import – Decision Matrix (Very Important)
| Criteria | Live | Import |
|---|---|---|
| Real-time data | ✅ | ❌ |
| Large data volumes | ✅ | ❌ |
| BW security reuse | ✅ | ❌ |
| SAC planning | ❌ | ✅ |
| Predictive features | ❌ | ✅ |
Live for governance, import for agility.
5. BW Queries in SAC
5.1 How SAC Consumes BW Queries
- BW Query acts as semantic layer
- Variables are prompted in SAC
- Filters & hierarchies respected
BW Query → SAC Live Model → Story
Best Practices for BW Queries Used in SAC
Keep queries lightweight
Limit free characteristics
Avoid complex CKFs
Use restricted key figures
Query-specific hacks for SAC
Reporting directly on aDSOs
Excessive drilldowns
6. Security Integration
6.1 Security in Live Connection
- Uses BW analysis authorizations
- PFCG roles apply
- Row-level security enforced
Security is evaluated in BW, not in SAC.
6.2 Security in Import Connection
- SAC roles & teams
- Separate security model
- Data-level restrictions must be redefined
Security duplication increases maintenance effort.
7. Performance Considerations (Critical)
7.1 Performance Factors for Live Connection
| Factor | Impact |
|---|---|
| BW modeling quality | High |
| Query design | High |
| Network latency | Medium |
| SAC story complexity | Medium |
Performance Best Practices
Optimize BW queries first
Use filters at query level
Reduce story widgets
Avoid unnecessary joins
7.2 Performance Factors for Import Connection
- Data volume in SAC
- Refresh frequency
- SAC-side modeling complexity
Keep import datasets small and purpose-driven.
8. Common Design Mistakes
Using import when live is sufficient
Overloading SAC stories
Ignoring BW query optimization
Mixing security models blindly
9. BW/4HANA vs Classic BW (SAC Integration)
| Area | Classic BW | BW/4HANA |
|---|---|---|
| SAC usage | Limited | Strategic |
| Live connection | Partial | Strong |
| Performance | Moderate | High |
| Governance | Medium | Strong |
10. Interview-Grade Questions
Q1. Why is live connection preferred for BW/4HANA?
Answer: Because it avoids data duplication, enforces BW security, ensures real-time access, and leverages HANA pushdown.
Q2. When should import connection be used?
Answer: When SAC planning, predictive analytics, or offline analysis is required and data volume is manageable.
11. Summary
- SAC is SAP's strategic analytics tool
- Live connection is preferred for BW
- Import connection serves niche scenarios
- BW Queries remain the semantic core
- Performance depends on BW design first
12. What's Next?
➡️ Module 22: Security, Auditing & Compliance (BW/4HANA)
A fast SAC dashboard starts with a well-designed BW model.