how to define a prompt to get Sales Manager and his reportee manager and reportee salesperson
Content
Hi All,
We have a scenario, where in one sales manager has salespersons and other sales managers as reportees.
Now, we are trying to build a dashboard prompt, which should show his immediate sub-ordinates in one prompt and if in this prompt option if he selects a manager name, in another prompt option it should display that manager reportees (Sales Persons).
We are using below SQL to get immediate sub-ordinates, but it is not working as expected and showing his entire hierarchy.
SELECT CASE WHEN VALUEOF("NQ_SESSION"."USER_ORG_HIER_LEVEL")<16 THEN "Sales Resource Hierarchy"."Current Level 15 Resource Name"
0