Spreadsheet EUC Active Management Module
Apparity’s Active Management module helps organizations take care of risk-prone spreadsheets and EUCAs, while empowering end users to get the job done.
Organizations have an important need for a tool that combats the risk associated with critical spreadsheets and other EUCAs. More importantly, this tool must empower the end users with their daily tasks. Apparity fulfills this need by providing the Active Management module.
Thanks to a seamless integration, the Active Management module can be used with the Registration and Discovery modules. More specifically, Active Management is designed for files that require an additional amount of controls. Once an EUCA is placed under Active Management, Apparity keeps a detailed Version History of the file by recording all significant changes that take place. These changes can then be submitted to an approver through an automated change approval workflow. Apparity offers the following features within Active Management:
Reporting & Analytics
The Apparity Reporting & Analytics Dashboard gives detailed reports through an intuitive web interface. Managers, auditors, and internal controllers can access real-time information about their files. This includes controls relating to access, versioning, and change management.
Excel Version History Tools
The Excel Version History is a powerful feature within the Active Management module. In addition to review workflows, it provides a number of useful tools for end users. It captures standard change information (date, time, user information) and also allows custom commentary for each modification.
Secondly, it has a quick export feature that gives historical versions for reporting, evidence, and distribution purposes. Thirdly, it offers the ability to go back to a previous version in case there’s an error. Lastly, Version History gives the users the ability to perform an “in-session compare,” so that they can easily analyze their work.
Apparity offers a helpful tool that analyzes potential errors within a spreadsheet. Integrity Check finds Excel errors in the file (like null values, cell errors, inconsistent formulas). Then, it gives a complete list with a meaningful error breakdown that allows users to correct these mistakes.
With other risk management software, inventory management is a siloed function in which discovery data has to be manually imported into inventory. Unlike competitors, Apparity Inventory Management System (AIMS) is integrated into our entire product suite and provides the ability to manage all your spreadsheet and EUC inventory regardless of stage (discovered, registered, managed).
The Managed/ Registered Inventory consists of all files that are registered and those that are placed under management for more surveillance. As a first step, Registration allows an organization to document certain file properties for EUC inventory. If more care is necessary, files can be placed under management in order to use change management and versioning controls. The Managed/Registered Inventory is designed to help organizations effectively manage their critical files from one location.
The Unregistered Inventory includes all of the files that were picked up from Discovery scans. These listings will include information about each file. When files appear to be versions of the same application, Apparity uses an algorithm to group them. AIMS also gives the user tools to group and filter the EUC inventory in order to view the data in a personalized and meaningful way.