Inserting an example chart

See the following example of adding an Organization Chart to a visual dashboard. This visual project is created on the basis of DEMO.EMPLOYEE table from the default Samples repository.

About this task

To create a visual project on the basis of DEMO.EMPLOYEE table:

Procedure

  1. Create a visual dashboard.
  2. Insert the query with the following SQL statement:

    SELECT A.EMPLOYEE_ID, A.FULL_NAME, A.SUPERVISOR_ID

    FROM DEMO.EMPLOYEE A

  3. Add Organization Chart to the visual project.
  4. On the second page of the Organization Chart wizard specify the following chart options:
    1. Set SUPERVISOR_ID in the Parent field.
    2. Set EMPLOYEE_ID in the Child field.
    3. Set FULL_NAME in the Label filed.
  5. Click Finish. The example chart is added to the current visual project.