Announcing the SAVIYNT KNOWLEDGE EXCHANGE unifying the Saviynt forums, documentation, training, and more in a single search tool across platforms. Click HERE to read the Announcement.

Dashboard Data not getting refreshed for logged in User

Manu269
All-Star
All-Star

Hi Team,

We have configured below Run Time Analytics : Access Requests waiting for Approval.

SELECT DISTINCT Substr(jbpmprocessinstanceid, Instr(jbpmprocessinstanceid, '.') + 1, Length(jbpmprocessinstanceid)) requestid,
us.username AS 'Requested For',
u.username AS 'Approver Name',
aa.jbpm_activity_name AS 'Activity Name',
aa.submitdate AS 'Start Date',
CASE
WHEN ar.requesttype = 1 THEN 'Add Access'
WHEN ar.requesttype = 2 THEN 'Remove Access / Account'
WHEN ar.requesttype = 3 THEN 'NEW ACCOUNT'
WHEN ar.requesttype = 4 THEN 'ROLE REQUEST'
WHEN ar.requesttype = 11 THEN 'FFROLE REQUEST'
WHEN ar.requesttype = 12 THEN 'UPDATE ACCOUNT'
WHEN ar.requesttype = 28 THEN 'EXTEND ACCESS'
WHEN ar.requesttype = 23 THEN 'FIREFIGHTERID'
WHEN ar.requesttype = 24 THEN 'FIREFIGHTERID ACCESS'
END 'Request Type'
FROM access_approvers aa,
users u,
users us,
request_access ra,
ars_requests ar
WHERE ra.request_accesskey = aa.request_access_key
AND ra.requestkey = ar.requestkey
AND u.userkey = aa.approverkey
AND us.userkey = ra.userkey
AND ar.requesttype IN (1,2,3,4,11,12,23,24,28)
AND aa.status = 1
AND u.username= ${ukey};

We have also Configured a Dashboard of type ES Tile.

Manu269_0-1661417596801.png

We have added the dashboard under ARS & analytics to SAV Role Also.

Now when the end user log into Saviynt and navigate to ARS > Dashboard , we are experiencing following issues :

1. The value is not getting refreshed for logged in user. I mean the data should show only display the count for which are pending for his/her approval for logged in User.

2. Upon clicking the dashboard we are getting Access Denied Error.

Please assist what needs to be corrected.

Thanks

Manish

Regards
Manish Kumar
If the response answered your query, please Accept As Solution and Kudos
.
2 REPLIES 2

rushikeshvartak
All-Star
All-Star

 

You may also use USERCONTEXT in the query in order to achieve your use case this is not available in runtime analytics. Only disadvantage is you need to schedule report


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Nikitaj
Saviynt Employee
Saviynt Employee

Hi @Manu269 

For 2nd issue, could you please add below feature access to your SAV Role.

Nikitaj_0-1661437711792.png

 


Thanks
Nikita