Analytics Report showing team members dynamically

[ejeong]

Hello we want to make an analytics report showing team members for all managers

Can we try query like below? 

select u.username,u.email

from users u,users u1

where u.manager = u1.usereky 

and u1.username = ${user.username} 

I am wondering if we can use "${user.username}" to show different result dynamically for each manager with same report. 

Thanks

[dgandhi · Accepted solution]

Hi @ejeong 

Create run time analytics to find all the reportees for any given manager (based on user input)

Thanks

[ejeong]

can't we use ${user.username} ? should it be ${manager} ?

[rushikeshvartak · Accepted solution]

Use Analytics user context concept 

https://forums.saviynt.com/t5/community-knowledge-base/how-to-use-user-context-concept-in-analytics-...

[ejeong]

Is this working in V5.5? i tried this but it's giving all records of report...

[dgandhi]

The query that I gave worked in Saviynt 5.5 SP3

Thanks

[ejeong]

@dgandhi ok. Objective here is to show this report history to all manager. And they will see only their reportee.  I am trying with USERCONTEXT as well but no luck so far. Giving all rows..

[rushikeshvartak]

Share screenshot of analytics config page 

[ejeong]

it works! I missed to select under Context

[dgandhi]

Are you logged in with ROLE_ADMIN SAV Role when you see all the rows? Have you tried to login with SAV role that is assigned to manager and see what is the behavior?

Thanks

[ejeong]

@dgandhi  to make report history, i need to run from my end once, when try to run, it is asking me to value in manager field. But i dont want to give option to run report to managers. And report should be run on schedule

Pls explain more how you are using in your use case