Introduction

Objective

After completing this lesson, you will be able to as a Data Analyst, be familiar with the Data Modeling requirements.

When analyzing the Cash Flow, our business users want to better understand the company segmentation. The clustering algorithm is executed in SAP Databricks and returns a cluster label for each company as well as the coordinates. This helps to visually interpret the cash flow clustering by company code in SAP Analytics Cloud later.

We want to add the coordinates as visual representation to our report, therefore we need to add these as measures to our model. You will create a new Fact View and Analytic Model which the embeds the data from SAP Databricks.

To customize the delivered content through SAP Business Data Cloud as part of the Intelligent Application, the space content onboarded via SAP Business Data Cloud needs to be transformed from SAP-managed content into editable content using the space copy and object sharing. The Data Builder entities are originally protected by the “sap.” namespace, where the namespace of the copied entities will be removed and they will become editable. In copied spaces, the “sap.” will be renamed to “sap_” which indicates that it is now a customer managed copied of the artifacts.

The installation of the Working Capital Insights Intelligent Application creates two spaces in the underlying SAP Datasphere. Both spaces are SAP-managed, and cannot be edited.

  • IA Working Capital (SAP_WCI or SAP_WCI_S4) - This space contains all the analytic models that form the foundation of the SAP Analytics Cloud stories.
  • SAP S/4HANA Content (SAP_S4H or SAP_S4H_S4) - This space contains all the modeling artifacts required to build the analytic models, such as views, data access controls etc.

Note

Your Datasphere space structure can differ depending on the version of the WCI Intelligent Application. The space SAP_S4H_ING is part of an earlier version of the intelligent application.

The following is the setup for this use case, with some of the steps already completed during your user automation or in previous lesson(s):

  • Perform space copies of SAP_S4H and SAP_WCI to BDC_S4H_EXT and BDC_WCI_EXT
  • Identify and only share the required Cashflow objects to your space
  • Install a data product shared by SAP Databricks in SAP Datasphere
  • Create a new Fact View using the Cashflow related Fact View as a source
  • Create a new Analytic Model