SAP Retail POS Analysis : SAP Data Warehouse Cloud and SAP Analytics Cloud Content “out of the box”
This blog post has the intention to give some background information about the new released SAP Data Warehouse Cloud Content “SAP Retail: POS Analysis” and its related SAP Analytics Cloud Content “Retail: POS Analysis”.
The idea of this content is, to support customers, partners and colleagues to start with SAP Data Warehouse Cloud projects. Since SAP Data Warehouse Cloud is quite new, we thought it would be good to have an end-to-end scenario available out of the box.
Let’s get a short overview of what the story in SAP Analytics Cloud is offering:
The first page, called “POS Analysis Cockpit”, gives an overview of some important KPI’s as Sales Amount, Number of Transactions, Sales Quantity and Average Basket Value. The pattern for each KPI is always the same, and the idea is to get a first quick birds eye perspective.
On the next page of the story, “POS Sales Analysis”, the user has much more possibilities to analyse the data in detail:
The third page “Store Analysis” allows to analyze POS transactions per hour. Again different KPI’s, Location Hierarchy and Product Hierarchy can be filtered. Top values and Flop values will automatically calcualted. With a date picker the granularity of the data set can be chosen for daily, monthly, quarterly or yearly granularity.
Now let’s have a look on the over all achitecture:
SAP Data Warehouse Cloud is the foundation layer for all data consumed by SAP Analytics Cloud.
You will find usefull information in the latest version of SAP Data Warehouse Cloud Content Documentation.
Basically, this content consist of two different kind of data:
- master data for products and sites
- transactional data for POS data
Let’s get back to the idea of this content. When it comes to analytics, semantics are key. For this asset, the idea was to have something in place to get quickly familiar with the possibilities SAP Data Warehouse Cloud offers when it comes to semantics and how those semantics will enable SAP Analytics Cloud functionality.
Having meaningful master data is crucial for analytics. Let’s have a closer look into the store master data. In our case, valuable information is spread over 3 different tables. Thats why we use the possibility to join those tables to get one common dataset for stores:
Semantically spoken, we created a common data set of type dimension for our store information:
There are two interesting possibilities SAP Datawarehouse Cloud offers:
- labeling data
- creating hierarchies
For that we assign Semantic Type “Text” to the Store Name Attribute and for the Store Attribute, we assign Store Name as Label Column.
As a consequence, in SAP Analytcis Cloud, we can use ID and Description for the dimension Store:
Hierarchies bring structure in reports. SAP Data Warehouse Cloud does support two kinds of hierarchies, level based hierarchy and parent child hierarchy.
We used a level based hierarchy with the dimensions Country, City and Store:
Transactional data are the heart of every report. They contain the measure which are the foundation to calculate the KPIs to steer your business. Thus, let’s have a short view whats possible here. The data set we used consist of two tables which has different information about a POS transaction. Thats why again, first step is a join:
Main difference to the master data view is the semantic usage of type “Relational Dataset”.
Now, that transactional data and master data views are ready, we created the final “Analytical Dataset” (Semantic Usage) which will be used for consumption (Expose for Consumption = ON) and enriched by additional semantic features:
A crucial semantic feature is to be able to assign semantics to measures (the technical name for KPI’s). Measures will have an aggreagtion behavior, a semantic type and if a unit is needed, the corresponding column in the data set can be assigned:
As a consequence, SAP Analytics Cloud can deal with those settings:
In my next blog post, I will describe how easily it is to deploy this content.
Regards and stay curious,
#build bridges, not silos