Quick guidance on implementing Seamless Planning with SAP Datasphere
Provides implementation guidance for SAP Analytics Cloud Seamless Planning with Datasphere integration.
/plugin marketplace add secondsky/sap-skills/plugin install sap-sac-planning@sap-skillsQuick reference for implementing SAP Analytics Cloud Seamless Planning with SAP Datasphere.
Seamless Planning unifies SAC planning with Datasphere for enterprise-grade data governance.
┌─────────────────────────────────────────────────────────────┐
│ SAP Analytics Cloud │
│ • Planning calculations & formulas │
│ • Version management logic │
│ • Data actions & multi actions │
│ • Calendar workflows │
│ • User interface & experience │
└───────────────────────┬─────────────────────────────────────┘
│ Direct Persistence
▼
┌─────────────────────────────────────────────────────────────┐
│ SAP Datasphere │
│ • Fact data (planning transactions) │
│ • Public dimension tables │
│ • Physical storage │
│ • Data governance & security │
│ • Cross-system integration │
└─────────────────────────────────────────────────────────────┘
Assign users appropriate space-level roles:
| Role | Required For |
|---|---|
| DW Modeler | Create and edit models |
| DW Integrator | Import and export data |
| DW Space Administrator | Manage space settings |
┌─────────────────────────────────────┐
│ Create New Model │
├─────────────────────────────────────┤
│ Model Type: Planning Model │
│ │
│ Data Storage Location: │
│ ┌─────────────────────────────────┐ │
│ │ ○ SAP Analytics Cloud (default) │ │
│ │ ● SAP Datasphere Space: │ │
│ │ [Your_Planning_Space ▼] │ │
│ └─────────────────────────────────┘ │
└─────────────────────────────────────┘
Configure dimensions as normal:
Note: Public dimensions are stored in Datasphere as dimension tables.
Objects Created in Datasphere:
| Object Type | Location | Description |
|---|---|---|
| Fact Object | Datasphere Space | Read-only view of planning data |
| Physical Table | sap.sac.<GUID> | Actual storage |
| Dimension Tables | Shared in Space | Public dimensions |
Continue planning normally in SAC:
All changes automatically persist to Datasphere!
Important: All models for cross-model operations must be in the same Datasphere space.
This applies to:
| Constraint | Details |
|---|---|
| Same Space Required | Cross-model operations require same Datasphere space |
| Public Dimensions | Must be in same space as referencing models |
| Currency Tables | Must reside in same space |
| Hierarchies | SAC hierarchies not exposed; recreate in Datasphere |
| Import Models Only | Only import data models supported |
| Benefit | Description |
|---|---|
| Unified Data | Single source of truth in Datasphere |
| Direct Persistence | No manual export needed |
| Reduced SAC Load | Offloads storage from SAC |
| Enterprise Reuse | Datasphere modeling for planning data |
| Real-Time Analysis | Live plan vs. actuals reporting |
| Governed Data | Enterprise security on plan data |
Check:
Reference: SAP KBA 3515100
Check:
Check:
// Check if model is Datasphere-enabled
// (No direct API - check model properties in UI)
// Verify data source connection
var ds = Table_1.getDataSource();
console.log("Data source connected: " + (ds !== null));
// Test data entry
try {
Table_1.getPlanning().setUserInput(selection, value);
Table_1.getPlanning().submitData();
console.log("Data persisted successfully");
} catch (e) {
console.log("Error: " + e.message);
}
For detailed information, consult:
references/seamless-planning-datasphere.md - Complete architecture and configurationreferences/modeling-basics.md - Planning model fundamentalsGuide Version: 1.0.0 Last Updated: 2025-12-27 SAC Version: 2025.25