march 2022.

Create a parent-child hierarchy in SAP Data Warehouse Cloud

There are different ways to create hierarchies in Data Warehouse Cloud. One way is to use a CSV file and upload it into DWC. Another way is to use the existing hierarchies of your SAP BW system. In this post, I want to show how to use a hierarchy from BW and transform it into a parent-child hierarchy in Data Warehouse Cloud. After the transformation, we use the hierarchy in a view. 

 

First, we need a hierarchy on one InfoObject in SAP BW. 

Read More 2 Comments