Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

how to define a prompt to get Sales Manager and his reportee manager and reportee salesperson

edited Jan 28, 2021 5:31AM in Reporting & Analytics for Sales 1 comment

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"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!