financial master data management in a heterogeneous … · financial master data management in a...

Financial Master Data Management in a Heterogeneous IT Environment

Kristin PollockDell Finance Product Manager

Agenda• Project Background• Project Goals• The Implementation Approach• Technical Challenges• Project Benefits and Challenge

3

Dell Inc. listens to customers and delivers innovative technology and services they trust and value. Uniquely enabled by its direct business model, Dell sells more

systems globally than any computer company, placing it No. 34 on the Fortune 500

Revenue for the last four quarters totaled $58.2 billion and the company employs approximately 90,400 team

members around the globe.









In order to get to globalCommercial revenue, you

would have to manually compileall of the Commercial data under

EMEA /APJ/Americas

Current State of InformationCurrent State of Information

Current reporting hierarchies create inconsistency across applications, regions, and segments resulting in various versions of the “truth”.

Numerous employees workextensively to

get your answer

Your Answer…Is it Accurate, Consistent, and

Repeatable?

HSB

COM

Benelux

EMEA

Switzerland

Americas

ABU

Consumer

APJ

Koreas COM

Japan

HSB

COM

APAC

Korea

Current State of TechnologyCurrent State of Technology

* High level structure only. Not all applications are pictured.

HFM and DDW are being used as master

data management

tools.

HFM

CCRP

Oracle

GPS

HyperionPlanning

DDW

SCM

HRDirect

DOMS D2

Omega Gears

Ariba

Manual

Manual

Phoenix

WOW

MTrack

Manual

No single No single source of source of truth exists.truth exists.

The current decentralized technology structure has led to redundant hierarchies, inconsistent reference data, and an intensive maintenance processes.

test

- takes flight September, 2007

8

Project Monarch GoalsProject Monarch Goals

What Does the Project Achieve?A centralized Master Data Management tool will allow for standardized hierarchies, enable visibility ofdata, reduce manual processes, improve data integrity, and reduce reconciliations.

• High level structure only. Not all applications are pictured.

DRM Provides:•Consistent Hierarchies•Consistent Reference Data•Single Point of Maintenance

HyperionPlanning HFM DDW

AribaOracle

DRM

HR Direct

Phoenix

WOW

MTrack

Presenter�

Presentation Notes�

DRM Does not feed directly into GPS�

Global End Users within finance and outside of finance are impacted by Project Monarch.

Who is affected by Project Monarch? Where do the end users sit?

Americas2,022 Affected End UsersFinance: 1,576Non-Finance: 446Change Agents: 20

APJ1,151 Affected End UsersFinance: 934Non-Finance: 217Change Agents: 12

EMEA1,008 Affected End UsersFinance: 940Non-Finance: 68Change Agents: 10

Approximately 20% of the affected end users are outside of the finance organization andrepresent virtually every organization within Dell.

Supply Chain

Human ResourcesProcurementProduct Group

Marketing Customer Care

Sales

IT

Change Agents for each region will assist with communicating

end user impacts.

The DRM ImplementationThe DRM Implementation

DRM Configuration Team Structure• A joint effort between Dell and Oracle Consulting Services• Team Members Included:

• Dell Project Lead (1) – fully dedicated• Oracle Consulting Lead (1)• Oracle Consultants (2) • Dell Functional Team Members (2) – fully dedicated• Dell I/T Team Members (2) • Representation from each downstream system – not direct

members of the project team

Scope of the DRM Implementation• Identify common reference data• Centralize the Source, Centralize the Maintenance


AribaOracle

DRM

HR Direct

Phoenix

WOW

MTrack

Oracle

•AFF Segment Values including Account, Cost Center and Product

•Segment attributes

•Descriptive flexfield information

Hyperion Planning

•Global Hierarchies

•Application specific reference data - 6 global applications

•HYP model was introduced concurrently

•Due to the complexity of planning at Dell, this was the most challenging

Hyperion Financial Mgmt

•Global Hierarchies

•Application specific reference data

•Due to the new hierarchy structures an application redesign occurred at the same time

Ariba/WOW/Pheonix/MTrack

•Decommissioned the current cost center role application and replaced with DRM

•Requires a daily feed of Dell employees and background processing

Dell Data Warehouse

•Interface the Global Hierarchies

•Interface required common reference data

•New hierarchies required a rewrite of existing model and reports

Implementation Example – Interfacing Chart of Account Segment Values to Oracle from DRM

TOPLF = Dell Legal Structure

1049 = Legal Entity

2049 = Business Unit

220985 = Cost Center

Properties and their values

Properties = Reference

Data

Analysts enter hierarchy information and limited

reference data.

DRM defaults and derives other reference data

Data flows through a series of verifications and is then sent

downstream

The DRM Implementation Approach• Perform scoping analysis to determine key systems• Gather system requirements for interface designs• Conduct data reviews with each system to clearly define

property configurations (define defaults, derivation logic, and system verifications). Design a template!

• Define the maintenance and governance approach – centralized, decentralized, request systems, workflow, etc…

• Begin loading test data into DRM – start validating the data. Validation is key. If multiple sources have been maintaining the same data, it’s going to have differences.

• Build back-end processes where necessary• Complete the testing phase – this is tough – lots of data!• Accomplish a Successful Production Release!

Technical ChallengesTechnical Challenges

The Technical Challenges…How did we get it to work?Analyzed the Data…

DRM Architecture

A Service Oriented Architecture



AribaOracle

DRM

HR Direct

Phoenix

WOW

MTrack

• Single Source of Truth• Single Point of Maintenance

DB Tables

Dell decided on a SOA architecture to provide increased data integrity by controlling data distribution cycles and …

Presenter�



DRM Runner fits in the Monarch Architecture

DRM Application

Server

DDW StagingDatabase Server

Teradata Servers

D3 SQL Server

TERADATA[TDPROD1/2]

DRM AdminUser

DDW StagingOracle

DDW Staging

Load Job

InformaticaServer

InformaticaServer

InformaticaServer

Informatica Repository

Oracle

DDW Teradata Load Job Hierarchical

Table (Changes Only)

Teradata Staging then Base

HierarchyExtracts

D3 Pub

ShareD3

Extracts BO Universe SAS

DDW User DDW User DDW User

Phoenix User

WOW User

HR BOBJ User

HFM User

Planning User

HALSCM-DC (Phase II)

API

DRM/SOA Application

Server

SOA Novora User

Ariba User

MTrack UserHR Direct User

Automator Hyp Database

EBI Schema

DRM Schema

Full DeltaPivotView

GPS User???

Views

MAugust 08

T W T F S S1 2 3

4 5 6 7 8 9101

112

13

14

15

16

171

819

20

21

22

23

242

526

27

28

29

30

31

• Creates AsOf Versions

• Runs Daily Exports

• Full – complete data sets

• Delta – data changes

• Sets System Parameters

• Custom Application (API)

Governance and MaintenanceGovernance and Maintenance

Dell Governance Model

Exec Council

BusinessSegments

StrategicNew Data

Execution• Ensures compliance with definitions• Reviews / manages exceptions

Global Data GovernanceGroup

• Drives the governance process• Drives policies and procedures• Documents & communicates• Ensures integrity & compliance • Performs maintenance• Defines workflows

• Submits hierarchy change request maintenance

• Completes template(s)• Understands data model definitions

TacticalMaintenance

Meta Tables


HFM Prod

DRM

HFM Meta

DB Tables

At Dell, a typical monthly maintenance cycle includes up to 10,000 rows of data changes. With application reference data now being stored in DRM, off-cycle maintenance will increase.

How is Maintenance Technically Processed?

Current Version Copied

•A copy of the current version in DRM is copied to a “Meta” version

Meta Maintenence

•The monthly maintenance is loaded into the Meta version and extracted to the “Meta” tables

HFM Reconciliation

•HFMMeta loads from the “Meta” tables in order to test the maintenance ties out

Maintenance to PROD

•Once the data ties out, the maintenance can be loaded into the Current version in DRM

Presenter�

