RSA IGL Recipes : Dashboard - Review Results "Outstanding Reviewers"

[#1]

RSA IGL Version: V 7.2.x

Modules: Governance

Product Area: Dashboards - Dynamic (Applied to Review Results Object Dashboard)

Time to apply: ~20 minutes

Summary

https://community.rsa.com/docs/DOC-115100 , 2020 - Part 1 of 12

The Review Results "Outstanding Reviewers" dashboard was created to provide key details on reviewers and those with outstanding items to be completed.This is a dynamic dashboard with various charts and reports included. Dynamic dashboards are very powerful and allow you to create a single dashboard, which can be applied to multiple objects at the same time. In this instance, one dashboard is created and this is then applied to every "review result" dynamically. The dashboard will update the charts/reports as you view different reviews. 

The goal of this dashboard is to help you understanding the reviewers that have the most outstanding items, so you can work with them, if necessary, to improve the review overall. 

Note: During the early days of the review, this dashboard will be changing a lot and might not be very useful. However it will be useful to help identify the reviewers who have the most items in total. 

Other useful links

• https://community.rsa.com/docs/DOC-115100 
• https://community.rsa.com/community/products/governance-and-lifecycle/exchange/recipes/blog/2019/11/06/reports-charts-dashboards-what-are-they-and-how-can-you-build-them 
• Other Dashboards: Click here for more Dashboards 

Example Image (Click to enlarge)

Key Notes

• This chart/report/dashboard is supplied "as is" - any modification of this item is done at your own risk. 
• If you have issues applying this chart/report/dashboard, please comment below for help, DO NOT contact the RSA Support team.
• If you would like more assistance with this chart/report/dashboard or for help in creating other chart/report/dashboards, then RSA Professional Services (RSA PS) is available to help.
  • Please contact your RSA Account Manager or local RSA Sales Rep or reply below for further assistance.
• Do not forget to set "User Constraints" on your dashboards - otherwise everyone will be able to see them.

Details

The Review Results "Overview" dashboard, contains the following charts and reports, all of which need to be created first, before you can implement this dashboard. Please see these documents for more info on how to create the required dashboard objects first:

1. https://community.rsa.com/docs/DOC-115108 
    Note: You may have already created this chart, with is also used here: https://community.rsa.com/docs/DOC-115105 
2. https://community.rsa.com/docs/DOC-115121 
3. https://community.rsa.com/docs/DOC-115122 

Dashboard Implementation

You MUST follow standard change request process and apply this solution in your lower environments first, before moving this to Production.

1. Create each of the reports/charts as listed above in the "details" section
2. Once all these charts/reports have been created succesfully

3. Go to Admin / Dashboards

4. Under "Object Dashboards" click the "+ Create Dashbboard" button
   
   
   

5. Under the "Dashboard Overview" tab

   Dashboard Name: Outstanding Reviewers

   Enabled: True/Checked

   Display Sequence: 2 (you can update this value in future, to move where this dashboard is shown).

   Layout: Proportional Layout,  select the option with 3 results, as shown below.
   
   
   

6. Under "Dashboard Components" Tab.

7. Click "Add Component" button.

8. Add each of the chards/reports, listed above, you must do this step for each chart/report.

9. Update the order of the reports/charts so that final result is like the image below.
   
   
   
   

10. Under the "User Constraints" tab set the correct level of access for who should see this dashboard. 
    Note: For this dashboard, you might need need to set any constraints, as only specific people can see review-results. If you did want to add something, then you might want to set this to just AveksaAdmin and users with Aveksa System Admin access.

    
    
    This is the "Advanced" SQL that can be used, if you want to copy and paste the below

    /*AveksaAdmin, System Administrators*/
    users."User Id"='AveksaAdmin'
    or users.id has approles (('Aveksa EDC','System Administrator'))‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

11. Click "OK"

12. The new dashboard should now be shown and display data dynamically for each review result

Next Steps

• Please "hit reply" and share your feedback - we would love to see an image of this working in your environment!

• Check out the other content found on the RSA IGL Recipes page: https://community.rsa.com/community/products/governance-and-lifecycle/exchange/recipes 

Thank you! 

Dont forget:

Please login, then "Like"  and "Actions/Follow" this page (Top Right), so as to receive updates and be notified if we modify/change items found here, in future.