internal-orders-view

Create Internal Orders View

1. Navigate to the Repository Explorer

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

3. Drag and drop the table CSV_InternalOrders into the canvas.
   
   

4. Select the Output Node in the canvas and configure the following properties:

• Business Name: V_INTERNAL_ORDERS
• Technical Name: V_INTERNAL_ORDERS
• Semantic Usage: Analytical Dataset
• Expose for Consumption: ON
  
  

5. Select the Output Node and change the following columns to Measure:

• GROSSAMOUNT
• NETAMOUNT
• TAXAMOUNT
• QUANTITY
  
  

6. Select the CSV_InternalOrders Node and add a new Projection Node from the context menu
   
   

7. Select the Projection Node and change the name of the column CREATEDAT
   
   

8. Set the new name to CREATE_DATE
   
   

9. Select the Output Node and add a new Association
   
   

10. Search and select the view V_VENDOR_PRODUCTS
    
    

11. Map the column V_VENDOR_PRODUCTS.PRODUCTID with the column V_INTERNAL_ORDERS.PRODUCTID
    
    

12. Select the Output Node and add a new Association
    
    

13. Search and select the view V_EMPLOYEES
    
    

14. Map the column V_EMPLOYEES.EMPLOYEEID with the column V_INTERNAL_ORDERS.EMPLOYEEID
    
    

15. Select the Output Node and add a new Association
    
    

16. Search and select the view SAP.TIME.VIEW_DIMENSION_DAY (Time Dimension - Day)
    
    

17. Map the column V_INTERNAL_ORDERS.CREATE_DATE with the column SAP.TIME.VIEW_DIMENSION_DAY.DATE_SQL
    
    

18. Click on the Deploy button to deploy the view.