The UCPath Common Data Warehouse - UCCSC 2014

The UCPath Common Data Warehouse - UCCSC 2014

UCCSC 2014 UCPath Common Data Warehouse The Setting: UCPath A cornerstone project of the UC Working Smarter Initiative Standardize and streamline payroll and human resources processes system-wide Replace UCs 35-year-old payroll/personnel system (PPS) with Oracles PeopleSoft Human Capital Management (HCM)

2 The Issue Oracle PeopleSoft HCM is architecturally distinct from PPS Significant revisions/replacements of existing PPS-based data warehouses for all Locations Data warehousing is not part of UCPath Data warehouse solution left to each Location 3

Business Intelligence Collaboration Group ITLC subcommittee with membership across UC Define direction & establish priorities for system wide data services and business intelligence Recognized the opportunity for Locations to collaboratively design and develop a UCPath Common Data Warehouse Developed and successfully championed the project proposal funded through the Office of the President

4 Goal Ensure efficiencies gained through collaborative design & development among all UC Locations Design once reuse many Assumptions UCLAs existing UCPath DW will serve as initial basis of design Design will adhere to standard star schema

Kimballs dimensional modeling practices 5 Deliverables Fully attributed logical and physical dimensional data models CDW data dictionary Multi-platform DDL - Oracle, SQLServer & DB2 ETL specification mapping Core set of reports, requirements and analytic algorithms

6 Scope - Subject Areas Person/Employee Job Absence Management Labor Ledger Payroll/Commitment Accounting Benefits Budget Ledger Job Position Management 7

Resources BICG Co- Project Leads (UCOP, UCLA) Project Manager Core Team 3 Data Architects (UCB, UCLA, UCOP) ERwin Data Modeler Reports Developer Extended Team UCPath Functional Experts

Location UCPath and DW Experts 8 Process Work one subject area at a time Gather use cases from Locations Review, identify issues, work with functional experts, and revise UCLA dimensional data models as needed Hold Design Review Sessions with all Locations to review deliverables Follow up with comments received, resolve issues and

make final revisions Publish deliverables Hold to Kimballs dimensional modeling design practices 9 Challenges Oracle HCM is new to UC and UC customizations to HCM are still being implemented HCM data model does not contain referential integrity

Data relationships, business logic enforced by application Dependency on functional experts Location requirements, design practices, environments and tool sets are different 10 Immediate Gains UCLAs existing UCPath dimensional models

serve as basis for CDW Version 1.0 Able to leverage the method of Location collaboration and the knowledge gained about HCM from previous work on UCPath DDODS Able to leverage knowledge about HCM from Locations that have already implemented HCM 11 Progress To Date Designs for Person, Job and Absence Management are complete with data dictionary and ETL specification mapping

Use cases provided by Locations have extended UCLAs models to meet common as well as Location specific design requirements Full text data naming in logical model with optional abbreviation algorithm for physical naming provides naming flexibility and an opportunity for short name standardization 12 Key Takeaways Collaboration Works! The common solution IS a collaborative solution

Immediate gains are all due to collaboration All Location alternatives contribute in whole, in part or generating new or hybrid solutions Takes work! Team work! Communication! Holding to Kimballs dimensional modeling practices established the design paradigm, facilitating communication and progress 13

Recently Viewed Presentations

  • Algebra Roots and Radicals Roots and Radicals Radicals

    Algebra Roots and Radicals Roots and Radicals Radicals

    Radical symbol Index Radicand Roots and Radicals Every radical expression has three parts… Index Radicand Radical Roots and Radicals The index of a radical is a whole number greater than or equal to 2. Roots and Radicals The index of...
  • BIRTH! - Miss Warner's Class Site - Home

    BIRTH! - Miss Warner's Class Site - Home

    , which stimulates the uterus to contract and open the birth canal. This process is known as labour & ends with the birth of a new baby. For many reasons, the baby can be delivered through a process called a...
  • Vocabulary Week 10/25-10/29 Quiz 10/29

    Vocabulary Week 10/25-10/29 Quiz 10/29

    The song was so _____ that Elizabeth found it difficult not to cry. Copy the sentence starter and complete the sentence in a way that shows you understand the meaning of the italicized word. The summer help on the highway...
  • スライド 1 - IEEE Standards Association

    スライド 1 - IEEE Standards Association

    Project: IEEE P802.15 Working Group for Wireless Personal Area Networks (WPANs) Submission Title: [TG5 CFA Response: Applications for the Mesh Networks]
  • Quotes from Othello - PC\|MAC

    Quotes from Othello - PC\|MAC

    Iago speaks about Othello's trusting nature - if a man looks honest, he believes that man is honest. Because of this trusting nature, Iago exploits Othello and ruins him through his trust of Iago. Iago lies to Othello at every...
  • Lecture 9: Corporate Equity, Earnings and Dividends

    Lecture 9: Corporate Equity, Earnings and Dividends

    Lecture 10: Corporate Equity, Earnings and Dividends The Corporation [1611] A body corporate legally authorized to act as a single individual, an artificial person created by royal charter, prescription, or act of legislature, and having authority to preserve certain rights...
  • TIPM3 Grades 2 and 3 - University of Michigan

    TIPM3 Grades 2 and 3 - University of Michigan

    TIPM3 Grades 2 and 3 February 15 Monica Hartman ... Perimeter and Area Problem Geometry 2.G. Partition a rectangle into rows and columns of same size squares and count to find the total number of them. Geometric Measurement 3.MD.5 Recognize...
  • Jupiter and Saturn: Lords of the Planets Chapter

    Jupiter and Saturn: Lords of the Planets Chapter

    Jupiter and Saturn are the most massive planets in the solar system Jupiter and Saturn are both much larger than Earth Each is composed of 71% hydrogen, 24% helium, and 5% all other elements by mass Both planets have a...