Introduction

Objective

After completing this lesson, you will be able to understand the semantic usage types of data modeling. The main learnings and the architectural overview describe the data objects of the scenario and the target dimensions and fact.

With SAP Datasphere we can bring data into the Data Builder, combine and prepare it for consumption in SAP Analytics Cloud, and other BI clients either directly or after further modeling in the Business Builder.

We can create graphical and SQL views to build the foundation of your data modeling on top of the remote or local tables. Views are classified into the semantic usage types:

  • Fact to indicate that your entity contains one or more measures that can be analysed.

  • Dimensions indicate that your entity contains attributes that are used to analyse and categorize measures defined in other entities.

  • Hierarchy to indicate that your entity contains parent-child relationships for members in a dimension.

  • Text to indicate that your entity contains strings with language identifiers to translate text attributes.

  • Relational dataset contains columns with basically no immediate analytical purpose, typically used as interim entities.

Key takeaways for the unit include:

  • Combine remote and local tables of the Data Ingestion layer.
  • Create Dimension, Fact and Text views.
  • Adapt the measure and attribute semantics of the views.
  • How to associate dimension, text and fact entities, building up the relationships.
  • Persist master data of the dimension views.

The overview below lists the views, representing the foundation of your data model, which you create or process in this Data Modeling unit:

In the next lessons, we create three Dimension views and one Fact view:

  1. Product Dimension view, consisting of:

    • Products
    • Product Texts
    • Product Sentiments

  2. Address Dimension view, consisting of:

    • Addresses
    • Countries

  3. Business Partner Dimension view, consisting of:

    • Business Partners

  4. Sales Fact view, consisting of:

    • Sales Order
    • Sales Order Items


[Optional] Modular Approach

If you did not complete the previous Data Acquisition unit, to ingest the source objects and build up the Data Inbound Layer, you can instead use the ‘4OV_*’ objects.

These objects are stored in the SAP Datasphere space CENTRAL_DATA in the folder WORKBOOK_OVERVIEW, and shared to your user space .

The local and the shared object names are identical, except of the prefix ‘4OV_’.

You find the ‘4OV_*’ objects in your Repository Explorer. Or in the Source Tree Explorer of the Data Builder Tools next to your local objects.

Also the dimension and fact views that will be defined in this Data Modeling unit are predefined for flexibility.


Learning

SAP FacebookSAP YoutubeSAP LinkedIn