Introduction

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 the three spaces in the underlying SAP Datasphere.

• SAP_WCI - This space contains all the analytic models that form the foundation of the SAP Analytics Cloud stories.
• SAP_S4H - This space contains all the modeling artifacts required to build the analytic models, such as views, data access controls etc.
• SAP_S4H_ING - This space contains all the local tables and their corresponding replication flows. The data from the data products reside in these local tables.

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 a space copy of SAP_S4H to BDC_S4H_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