Master Data Management

ADI Strategies › Solutions › Master Data Management

Keeping Metadata in Alignment

network_10392The ability to centrally manage master data (dimensions, hierarchies, reporting structures, and properties) will give your business agility to globally synchronize metadata across disconnected information systems.  Oracle Hyperion Data Relationship Management makes master data synchronization efficient by reducing duplicate manual maintenance efforts while providing centralized exports of master data to downstream systems and applications.  Continue reading below to see why Activision Blizzard, a leading global video game company, relies on Oracle’s Hyperion Data Relationship Management (DRM).

Oracle DRM is a centralized, collaborative change management application that allows you create, update and export dimensions, hierarchies, reporting structures, and properties for consumption by downstream applications.

DRM provides several key capabilities including:

  • Hierarchy, node and property management
  • Business logic-based validations
  • Batch imports of source master data
  • Integrated master data exports with relational or flat-file output
  • Version control with snapshots
  • Comparison-based reporting between versions
  • Hierarchy-based selection to automate report contents
  • Approval workflows and complete auditability

DRM gives your business the access, flexibility, consistency, rigor, quality control and visibility you need to quickly integrate an acquisition, incorporate a new system, or simply add new values to your existing chart of accounts.  DRM is regularly used to ensure successful execution of the following types of business activities:

  • Business (finance) ownership of master data management
  • Regular maintenance of financial master data
  • Chart of accounts redesigns
  • Mapping of values (old-to-new) in mergers and acquisitions
  • Enterprise-wide synchronization of financial master data


DRM Makes Finance Accurate & Flexible

Your enterprise resource planning (ERP), business intelligence, financial planning, analysis, and consolidation tools can stay in sync by moving master data management upstream into DRM.  DRM will give your business the ability to maintain an enterprise view of your financial chart of accounts, cost centers, legal entities, products, etc… Centralizing master data within DRM will keep downstream systems updated with consistent views of your business dimensions.  Once integrations have been configured with target systems, DRM can also move the ownership of master data changes into the business where subject matter experts can directly update master data.

With DRM, Finance can:

  • Align structures and hierarchies for different systems to ensure consistency across the enterprise
  • Comply with Sarbanes-Oxley, Basel II and other regulatory requirements with access controls and full audit capability
  • Analyze, design and implement mergers and acquisitions related structures, hierarchies and mappings with drag and drop simplicity
  • Rationalize, align and maintain business structures with cross mappings and alternate structures
  • Manage hierarchy, node and property changes visually

By automating the input, processing and reporting functions, you will greatly increase ability to govern, rationalize, consolidate and share vital master data while making your infrastructure more agile.

Efficiency Drives IT to Embrace DRM

The value of Information Technology depends directly on the quality and accuracy of the information available in systems and applications across a company.  Implementing DRM will help control the quality and accuracy of information displayed in each reporting interface configured to leverage DRM master data extracts.

With DRM, IT Can:

  • Centralize management of dimensions and hierarchies across disparate systems and platforms
  • Simplify complex relationships between hierarchies, mappings, business rules and attributes with an intuitive interface
  • Strengthen real-time and batch validation and verification processes to enforce business rules and reconcile master data
  • Updates to downstream applications can be batched in parallel with a multi-threaded architecture that ensures updated master data is imported to all systems at the same point in time

DRM lets finance focus on the routine master data changes while IT can focus on the up front configuration of DRM integrations with downstream applications.


Key Benefits:

Accurate Views of Master Data

  • Single source of data
  • Role based access

Reduced Costs

  • Eliminates duplicate maintenance processes
  • Reduce time and money fixing errors
  • Reduced costs of current systems

Fast and Flexible Decision Making

  • Timely intelligence
  • Rollback and what-if tools

Greater Value from Existing Assets

  • Integration of data warehouses, data marts, OLAP cubes and ERP systems

Regulatory Compliance

  • Consistent and reliable export reports
  • Audit trails

M&A reporting

  • Quick data integration


Learn more about our clients here…
Watch a product demo here…

Contact us to learn more about developing a robust master data relationship solution that can help your organization stay in control of metadata.