employees-view

Create Employees 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 T_EMPLOYEES into the canvas
   
   

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

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

5. Click on the Hierarchy button
   
   

6. Add a new Parent Child Hieararchy (aka Internal Hierarchy)
   
   

7. Adjust the following properties:

   • Business Name: Employee Hierarchy
   • Technical Name: EMP_HIER
   • Parent Column: MANAGERID
   • Child Column: EMPLOYEEID
     
     

8. Selct the Output Node and click on Edit button of the Attributes section.
   
   

9. Adjust the following properties:

• FULL_NAME, set semantic to TEXT
• EMPLOYEEID, set the label to FULL_NAME.
  
  
  

12. Select the Output Node in the canvas and click on Data Preview from the context menu
    
    
13. Click on deploy button to deploy the view