business-partners-view

Create Business Partners View

In this exercise we will create our first View of type Dimension.

🎓 Dimension: A Dimension is a term which comes from the OLAP (Online Analytical Processing) and Starschema domain. It represents Master Data such as Business Partners, Products, Customers, Sales Organization. Master Data usually carries texts and descriptive attributes, which exist in multiple languages.

1. Navigate to the Repository Explorer

2. Click on Create - Graphical View Button to create a new view
   
   

3. Click on Details button and configure the following properties:

   • Business Name: V_BUSINESS_PARTNERS
   • Technical Name: V_BUSINESS_PARTNERS
   • Semantic Usage: Dimension
   • Expose for Consumption: ON
     
     

Join Node

4. Drag and drop the table CSV_BusinessPartners into the canvas
   
   

5. Drag and drop the table CSV_Addresses into the canvas and drop it directly on the CSV_BusinessPartners Node.

6. Select from the context menu Join
   
   

7. A new Join Node and a Projection Node will created

8. Select the Join Node and map the column CSV_BusinessPartners.ADDRESSID with the column CSV_Addresses.ADDRESSID
   
   

9. Adjust the Join Type to Inner Join.

   Note: Following Join Types are currently supported: Inner Join, Left Join, Right Join, Full Outer Join, Cross Join

   
   

10. You can also set the join cardinality:

    • Exactly One (1)
    • One (0..1)
    • Many (*)
    
    

    Note: The cardinality information is utilized in SAP HANA Cloud to optimize the query execution and for that also the overall performance.

    
    

Projection Node

With the projection node, you can exclude or restore columns from your model. Hence, they won't be available nor consumpable on the client side, such as SAP Analytics Cloud.

11. Select the Projection Node and exclude the FAXNUMBER from the Node.
    
    

Id and Text

Id and Text: Master Data usually consists an identifier (e.g. Cost Center Id) and a textual description (Cost Center Name). Depending on the reporting requirement, users might want to display one or the other (or both) in the story. This particular semantic and relation between an Id and Text can be modelled in SAP Data Warehouse Cloud.

11. Select the Output Node and navigate to the Attributes section and click on Edit Attriutes button:
    
    
12. Adjust the following attribute properties:
    • COMPANYNAME: set the semantic type to TEXT
    • PARTNERID: set the label to COMPANYNAME
      
      

Level Based Hierarchy

13. Select the Output Node and open the Hierarchy Dialog
    
    

14. Add a new Level Based Hierarchy
    
    

15. Adjust the Hierarchy as following:

• Business Name: Hierarchy
• Technical Name: Hierarchy
• Levels:
  • REGION
  • COUNTRY
  • CITY
    
    

Data Preview

16. Select the Output Node and click on Data Preview from the context menu.
    
    

Deployment

17. Click on Deploy button to deploy the view