Creating a Graphical View and Analytic Model in SAP Datasphere

In SAP Datasphere, there are a variety of different ways that you can prepare data for consumption. In this lesson, we will create a model in SAP Datasphere using a Graphical View to query the SAP Analytics Cloud fact tables for sales revenue plan data and actual data.

Remember, the data models for plan data and actual data were created using the SAP Datasphere Data First approach. Meaning models were created in SAP Analytics Cloud using a file, an SAP Datasphere space was selected as the data storage location, and the model was exposed to SAP Datasphere.

Create a Graphical View

To create a graphical view using the fact tables created from the SAP Analytics Cloud model:

In SAP Datasphere, go to Data Builder.
Select the SAP Datasphere space that was exposed to the model.
Select the fact table, in the following example, Fact_Table_Plan_Data is selected.
Select New Graphical View.

SAP Datasphere Data Builder (1), in the SACP21_41_Seamless_Plan (2) with the Fact Table Plan Data checkbox selected (3) and New Graphical View (4).

Combine the Plan and Actual Fact Tables

Since we want to combine the data from the two fact tables, we use the Union operator in the graphical view.

Drag the first data source, in this example, Fact_Table_Plan_Data onto the canvas.
Drag the second data source, Fact_Table_Actual_Data and drop it onto the Union operator.

SAP Datasphere Graphical View with the fact table fro plan data being dragged and dropped onto the canvas (1) and then the actual data fact table being dropped on the Union operator (2).

Map the Dimensions and Measures

The graphical view setup requires mapping between the dimensions and the measure of both data sources. Once the mapping is complete, save the graphical view.

SAP Datasphere Graphical View Union Properties on the right with mapping.

Deploy the Graphical View

Configure and deploy the graphical view by completing the following steps:

Toggle Expose for Consumption to On.
Toggle Run in Analytical Mode to On.
Deploy the view.
Once the Status is set to Deployed, select Create Analytic Model.

Configure and deploy the view using steps 1-3 as detailed above the screenshot. Wait until the status is set to Deployed.

Hint

If the Status does not immediately update to Deployed, refresh the browser.

Deploy the Analytic Model

Update the name of the model. It is also possible to change the name when it's deployed.
Select Deploy. Once deployed, graphical view changes color as shown in the following example, and the Status updates to Deployed.
To view the model, select Preview.

Configure and deploy the model using steps 1-3 as detailed above the screenshot. Wait until the status is set to Deployed before previewing.

Preview the Analytic Model in SAP Datasphere

Once the analytic model is deployed, it's ready for consumption in SAP Analytics Cloud. In the following example, you can see the plan data that was updated earlier in the lesson.

SAP Datasphere model with data previously viewed in the fact table highlighted.