Dashboard output others manager are able to see first time.

[ArvindKumar]

Details: We have analytic which gives reportee and their assigned roles details for Manager in Saviynt. Manager simply can click on dashboard and can see the results from the linked analytic: screen shot attached in document. 

If another manager first time check the same result from his/her login in Dashboard. He and she see similar output as coming for previous which is completely incorrect. Why previous manager results are showing to new manager analytic output until analytic not refresh in Dashboard. Screen shot attached in document. 

If new manager click on refresh it will refresh. After refresh it fetch the current manager reportee details. 

User SQL query: 

select u.username,u.firstname,u.lastname as 'LastNAME',r. role_name, CASE WHEN r.roletype = 1 THEN 'Enabler' WHEN r.roletype = 2 THEN 'Transactional' WHEN r.roletype = 3 THEN 'FireFighter' WHEN r.roletype = 4 THEN 'Enterprise' WHEN r.roletype = 5 THEN 'Application' WHEN r.roletype = 6 THEN 'EntitlementBasedRole' END AS 'Roletype' from users u, roles r where u.userkey in (select distinct rua.userkey from users P, role_user_account rua where P.manager =${user.id} and rua.userkey=P.userkey and rua.rolekey=r.rolekey)

Please assist. 

Regards, 

Arvind 

[rushikeshvartak]

Since you have linked report where history is getting stored & report may be scheduled on particular interval here new requestor will see previous data as job is not executed. 

Solution will be use runtime analytics. As this data is read only

Another solution use user context https://saviynt.freshdesk.com/support/solutions/articles/43000431474-context-types-of-elasticsearch-... 

select P.manager as USERCONTEXT,u.username,u.firstname,u.lastname as 'LastNAME',r. role_name, CASE WHEN r.roletype = 1 THEN 'Enabler' WHEN r.roletype = 2 THEN 'Transactional' WHEN r.roletype = 3 THEN 'FireFighter' WHEN r.roletype = 4 THEN 'Enterprise' WHEN r.roletype = 5 THEN 'Application' WHEN r.roletype = 6 THEN 'EntitlementBasedRole' END AS 'Roletype' from users u, roles r where u.userkey in (select distinct rua.userkey from users P, role_user_account rua where  rua.userkey=P.userkey and rua.rolekey=r.rolekey)

[ArvindKumar]

Hi Rushikesh, 

I am using run time analytic only. I even can scheduled my report every 1 or 5 min. But even in the time period, anyone can see others previous manager data. So we dont to show anyone data to any other manager. 

Secondly in Context drop down option inverse user is not visible for me. 

Regards, 

Arvind 

[rushikeshvartak]

Use user from drop down