Suppose you as admin have created common reports and dashboard to be used or shared across the Org by different teams and such reports and dashboard being common sometimes some new users start modifying such reports and dashboard may be thinking its for their team that is they start adding some filter criteria in these report and in that case for other user from different team, the same report will not return results as expected.
Overall, these reports and dashboards which were meant to be used org wide ended with modifications because people didn't realize they were used org wide and thought these were meant for them and started adding some filter criteria like region etc. and now that the report returns data for someone and for others it may return blank.
But being common report, you want to allow users to modify reports or reuse report instead of creating a new one like they can 'save as' so that report can be cloned and reused instead.
Additionally, you need to know - who is actually modifying the reports and dashboards?
Solution:
Create the report of Reports that is:
Create a custom report type
Primary - Report > Secondary - Dashboard Components
In report layout, field properties > add field related via lookup > that means you can add field from any other record that you can traverse to e.g. every record have the 'created by' field so traverse to created by profile, even role so that you can use this as part of filter. Repeat the same thing in 'last modified by' field. You can even add the filter to narrow down results for certain dashboard that has common or org words in the dashboard title. Some additional filters like created by system admin profile (use contains instead where needed) and another criteria would be 'last modified by' not system admin profile (use contains instead where needed).
Any time the report from any of such common dashboard are modified by someone who is not admin, it should be reflecting now in this new report, now add to the appropriate folder which only admin can access may be. You can add report subscriptions (schedule daily) so that once a day. If there's some data returned in this new report that means someone made some changes.
Overall, now you can track updates made and this reduces down to how long a report might be modified like if someone has filtered by their region or added some other filter you can view this that is go to the report to find made the changes. You may individually communicate to the person who made the change, guide, explain the impact and explain how this user can instead use 'save as' to clone and reuse the report instead. Now as admin, the changes done by the user can be removed by you since you know the difference or what's changed or added and have the correct report details returned in this report of reports.
Visual: https://www.youtube.com/watch?v=ruYFstMjEXU
Reference : https://admin.salesforce.com
Comments
Post a Comment