Showing results for 
Search instead for 
Did you mean: 


Many companies have a requirement to allow dashboard segmentation or filtering based on a person hierarchy.   For example, a common requirement is to view data from a particular manager’s organization (direct and/or indirect reports).  In a previous article we detailed how you can create a hierarchical model in Incorta and create dashboards using the hierarchy.

In this article, we will specifically focus on how to filter data in such a hierarchy across the entire dashboard.

What you should know before reading this article

We recommend that you be familiar with these Incorta concepts before exploring this topic further.

Applies to

This article applies to all supported versions of Incorta both in the Incorta cloud and on-premises.

Let's Go


First, you will need a table that defines a hierarchy.  Incorta assumes that such a table has a primary key column.  We will use an example use case with a Sales_Rep_ID column.  The SalesRepHierarchy table is shown below.

Screen Shot 2023-01-30 at 12.14.30 PM.png

Note that in the table, there is a foreign key column, Parent_Sales_Rep_Id, which refers to the primary key column to form the hierarchy.  

Screen Shot 2023-01-30 at 12.47.26 PM.png

Next you will need some data that is specifically tied to each sales rep.  In the example, we use the EBS Sales Order tables (OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL) which store sales order information.

What it looks like

Drill Down directly using the hierarchy in the aggregated table

You can directly click on the manager’s name in the hierarchy insight.  The name will be promoted as a prompt filter.  All other insights such as the aggregated KPI will be updated accordingly. 

Screen Recording 2023-01-30 at 4.48.08 PM.gif


Create a Dashboard Prompt

Select the prompt column that stores the managers.  In this example, choose the Parent Sales Rep Name field.

Screen Shot 2023-01-30 at 12.01.14 PM.png

Choose the Is Descendant operator

The Is Descendent operator enables the ability to see the data of the manager and those who report to the manager.

Screen Shot 2023-01-30 at 12.01.26 PM.png

Select the person that you would like to view

You will view all sales made by the manager and/or his subordinates.

Screen Shot 2023-01-30 at 12.01.44 PM.png


Best Practices Index
Best Practices

Just here to browse knowledge? This might help!

Version history
Last update:
‎01-31-2023 04:56 PM
Updated by: