Understand SAP Analytics Cloud Planning Data Storage Configuration in SAP Datasphere

With seamless planning, leverage your SAP Analytics Cloud data in SAP Datasphere and bring both applications closer together for a smooth planning experience.

Seamless planning refers to the planning workflows supported by the integration of SAP Analytics Cloud data in SAP Datasphere. SAP Analytics Cloud is responsible for the consumption, modeling and visualization of the data, while SAP Datasphere handles the data storage. You’ll be able to model and plan against SAP Analytics Cloud data, stored in SAP Datasphere, provided that both tenants are linked. Note that only one SAP Analytics Cloud tenant can be linked to an SAP Datasphere tenant and vice versa. It is no possible to link one tenant to multiple tenants.

With seamless planning, you’re now free to store your models' data or other individual objects like public dimensions, currency rates tables in SAP Datasphere, where all the data resides.

Are There Technical Prerequisites?

The prerequisites below are necessary to connect SAP Analytics Cloud and SAP Datasphere for seamless planning.

  • SAP Analytics Cloud and SAP Datasphere tenants must be linked in a 1:1 relationship by the system owner.

  • The SAP Analytics Cloud tenant me be running on HANA Cloud.

  • Both SAP Analytics Cloud and SAP Datasphere tenants must be located in the same data center and deployed in the same landscape. SAP data centers are not in scope.

  • Both SAP Analytics Cloud and SAP Datasphere tenants must use the same identity provider (IdP) and the same subject name identifier.

  • Ensure that the SAP Datasphere URL you enter doesn't match an entry in the list of SAP Datasphere's trusted origins. For more information on how to prevent or resolve the error during tenant linking, see SAP Note 3574577 Information published on SAP site.

How Does It Work?

Seamless planning leverages SAP Datasphere spaces to host SAP Analytics Cloud model run-time artifacts. SAP Datasphere therefore becomes the preferred data layer for SAP Analytics Cloud, while SAP Analytics Cloud still defines the model structure, owns the model’s metadata, defines calculations, planning processes, etc.

SAP Analytics Cloud modelers can opt for SAP Datasphere data storage when creating new models and dimensions, or when importing content. They can also control the visibility of the SAP Analytics Cloud objects in the SAP Datasphere. Once SAP Analytics Cloud models and public dimensions are exposed in SAP Datasphere, SAP Datasphere modelers are free to share these objects with other spaces using SAP Datasphere sharing functionality.

How Can I Link My SAP Analytics Cloud and SAP Datasphere Tenants?

Seamless planning requires both application tenants to be linked so that both applications can communicate seamlessly. Formations are logical groups of SAP systems that can be extended in a business scenario. A formation enables the automated integration between a set of your provisioned SAP systems. Linking both tenants is only possible if they are hosted on the same data center and deployed in the same landscape. Each tenant can only have a single formation to another tenant.

Creating a formation type Integration with SAP Analytics Cloud enables the selection of SAP Datasphere spaces as the data storage selection for models, public dimension tables, and other supported objects types.

For more information and detailed steps on how the system owner can create formations in the Business Technology Platform (BTP) cockpit or SAP for Me, see Configure Data Storage for Planning.

Can SAP Datasphere Modelers Make Structural Changes in SAP Datasphere?

SAP Analytics Cloud objects available in SAP Datasphere are in read-only mode, meaning that SAP Datasphere cannot make structural changes to these objects.

SAP Analytics Cloud models expose the underlying data foundation as a local table (fact), while the public dimensions expose the master data as a local table (dimension) associated with a translation table responsible for storing the multi-language descriptions. Then, SAP Datasphere can use SAP Analytics Cloud objects in graphical views, SQL views, data flows, analytics models, transformation flows, etc.

What Are The Supported Models?

Seamless planning only supports standard models. Account models don't allow choosing SAP Datasphere spaces as data storage location.

Who Owns What?

With seamless planning, all the data is stored in SAP Datasphere.

However, the ownership of artifacts is split as follows:
  • SAP Analytics Cloud owns run-time artifacts such as views, tables, fact planning data, teams, currencies, units, and data access control security.

  • SAP Datasphere owns SAP Datasphere views, SAP Datasphere tables and actual data.

Are There Restrictions?

Seamless planning is still under development. Below is a list of restrictions that apply to seamless planning.
  • The application generates an error when trying to retrieve spaces if the header request gets too long. This usually happens if a user is assigned to a large number of SAP Datasphere spaces that the application tries to retrieve while attempting to store a model, a public dimension table or a currency rates table in SAP Datasphere.

  • The following features of Data Export Service API are not supported:

    • Audit tables

  • The following features of the Data Import Service API are not supported:

    • Public dimension tables

    • Private versions