Working with SAP Datasphere

The advantages of using an SAP Datasphere model in an SAP Analytics Cloud story include:

• More analytical capabilities or calculation for complex business requests
• Reusable objects
• Output control
• Optimized performance
• Optimized integration for SAP Business Warehouse
• Reusing data security of the source (supported by SSO)
• Analytical previews
• Self-service analytics strategies are supported - users can create their own models

System administrators must first set SAP Analytics Cloud and SAP Datasphere as trusted origins to each other. This means a security-based trusted relationship is created between the two platforms.

It provides:

• Secure communication
• Secure data transfer/exchange
• Authentication
• Authorization

It is also recommended to establish tenant links between SAP Analytics Cloud and SAP Datasphere. This enables a better and more efficient collaboration between the two cloud platforms. It helps to provide data very easily and for users to navigate between the connected tenants using the Product Switch menu option.

Administrators create a live data connection from SAP Analytics Cloud to SAP Datasphere, allowing SAP Analytics Cloud users to consume data that has been modeled in SAP Datasphere. A story can be created in SAP Analytics Cloud using an SAP Datasphere model as a data source with no additional effort.

For more information, go to: Creating Data Connections for Cloud Applications in SAP Analytics Cloud.

Modelers can update the model in SAP Datasphere. In the example below, you can see an SAP Datasphere analytic model.

1. Impact and Lineage and Generate OData Request tools.
2. Single fact source
3. Toggle between Model and Preview.
4. When you open a model in SAP Datasphere, you can see if it has been deployed or not. A model can only be used as a data source in SAP Analytics Cloud if it has been deployed.
5. Measures are taken from fact source. Calculated and restricted measures can be added.
6. Dimensions, including nested dimensions. Text associations and hierarchies are automatically resolved.
7. Variables for different use cases. For example, input parameter push-down, restricted measure variables.

To use a model created in SAP Datasphere, you first have to create an Optimized Design Experience story in SAP Analytics Cloud using the model that was created and deployed in SAP Datasphere.

Let's take a closer look.

To view unsupported features with SAP Datasphere live connections in SAP Analytics Cloud go to SAP Note: 2832606.