Implementing the Apparity solution helped us meet a regulatory requirement around EUC governance. Beyond that, Apparity has helped the program become more streamlined and has helped us implement more robust spreadsheet controls. Additionally, the Apparity team has provided exceptional customer service that has been essential to enterprise-wide adoption of a new software solution and the associated program and culture changes.
Single Pane of Glass for All Modules
Apparity understands that there are multiple facets to a comprehensive EUC or Spreadsheet Management policy and caters to each with its Discovery, Registration and Active Management modules. While the modules can operate independently for organizations seeking to address a singular need, Apparity recognizes that these modules must seamlessly integrate with one another when used together.
With Apparity, a file detected using Discovery can be moved to Registration with a click of a button in the Apparity Inventory Management System (AIMS). Files under Active Management automatically populate the AIMS Managed/Registered inventory for a complete look into the EUC environment. The connectivity between modules saves time and enhances user experience. Apparity provides a single unified view of EUCs at all stages.
Multiple User Roles
EUC and Spreadsheet Management policies must consider a number of user roles such as Owners, Approvers/Managers, Department Heads, Compliance Officers and Auditors. Apparity is designed to provide value for each of these unique types of users and the goals they aim to achieve. Owners and Approvers/Managers, who are more connected to the EUC’s regular use, are given user tools such as Excel Version History Tools, and Integrity Check to make file management more convenient.
Reports and inventory details can be reviewed by designated Department Heads to give insight into the EUC usage within the department. Full insight into the EUC landscape, from Discovery to Registration to Active Management, gives Compliance Officers and Auditors the information they need to make informed decisions about the scope and strength of EUC policy fulfillment.
Enterprise-wide Governance, Risk and Compliance (GRC) Integration
Apparity makes it easy to correlate and tie in EUC and Spreadsheet governance with the bigger GRC picture in a customer’s organization. Apparity can enable connectivity to enterprise GRC systems, such as RSA Archer, IBM Open Pages, etc. The Apparity GRC Integration Bridge expands a company’s ability to identify the inherent risk associated with EUCs and Spreadsheets.
It also links the issues, management and controls associated with their risk into the organizations GRC application and strategy. Apparity provides organizations with the ability to identify, monitor and assess the inherent risk associated with their applications and to update any GRC application with the data, key events and controls required to manage the residual risk.
EUC Policy/Spreadsheet Management Policy Configuration
An organization’s EUC policy and company structure have a significant impact on how they will incorporate a technology to address EUC risk management, so Apparity is configurable to meet customers’ needs. The Apparity Services Team dedicates time at the beginning of the project to understand the policy, goals and success criteria for optimal configuration.
An Apparity customer can feel confident that the Apparity Services Team will utilize their depth of experience in implementations, and the more general EUC and Spreadsheet risk management space, to achieve mutual success.
End User Benefits
Apparity goes beyond a basic compliance tool intended to satisfy the needs of regulators and auditors by providing its end users with their own set of handy tools. This toolkit allows end users to maintain complex spreadsheets with ease and confidence. Keep reading to find out more about Apparity’s end user benefits:
- Version History
Whenever the end user is working with an Apparity managed file, Apparity presents the file’s modification history in an easily accessible manner. This allows the end user to easily view the modification history in chronological order along with custom comments entered by the modifier. Version History also includes review and approval statuses of a file.
- Rollback Feature
When the end user would like to discard all changes and go back to a clean slate as in the past, the Apparity rollback feature allows them to revert their working copy to a previous version. End users can make modifications knowing that they don’t have to manually create temporary copies of files. This reduces the amount of redundant files and any confusion finding the right version of a file.
- Historical Version Export
Apparity functions as a time machine for spreadsheet that allows the end user to export a historical version of the file for use at any time without explicitly having to store a copy of the file.
- Change Tracking
Apparity allows and end user to view content differences across the various versions or copies of a file. Apparity’s change comparison tool is built to show changes side by side or in a redline format that allows users to understand in context how the file was modified. The in-session compare feature allows users to easily look at changes they have made during that particular edit session.
- Automated Workflow
End users do not have rely on email exchanges to collaborate on files and review them. Apparity’s review and approval system allows both the submitter and reviewer to examine the changes using the same view and record their approval. Built-in email notifications make the workflow easy to manage. In addition, review requests and approvals are recorded in the Version History for any user to refer to approved versions of the file.
- Error Identification
Excel spreadsheets are complicated applications and mistakes that are not identified early can be costly to fix. Apparity’s Integrity Check feature allows end users to use a tool to check for common calculation and data errors in a file at any time. The Integrity Check tool can be used in all stages of the spreadsheet life cycle from design to maintenance.