Sap decision support environments in higher education
This presentation is the property of its rightful owner.
Sponsored Links
1 / 23

SAP Decision Support Environments in Higher Education PowerPoint PPT Presentation


  • 99 Views
  • Uploaded on
  • Presentation posted in: General

SAP Decision Support Environments in Higher Education. Session Code: 2204. Todd Orr, Duke University Neal Wormsley, University of Tennessee. Duke University Background. Duke University & Duke University Health System $2.2 billion in revenue 30,000 employees

Download Presentation

SAP Decision Support Environments in Higher Education

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Sap decision support environments in higher education

SAP Decision Support Environments in Higher Education

Session Code: 2204

Todd Orr, Duke University

Neal Wormsley, University of Tennessee


Duke university background

Duke University Background

  • Duke University & Duke University Health System

    • $2.2 billion in revenue

    • 30,000 employees

    • DUHS composed of 3 hospitals, physician practices, hospice, and other health related entities

  • In production with FI/CO/MM/FM/PS/AM since March 1999

    • Initial focus on Health System; 1,800 current users

    • Rollout of financials to University in next two years

  • Implementing SAP HR/Payroll - go live by end of 2001


If we have r 3 why dss

If We Have R/3, Why DSS?

  • Difference between OLTP and OLAP

    • OLTP: On Line Transaction Processing - R/3

    • OLAP: On Line Analytical Processing - DSS

  • DSS/OLAP allows us to leverage the investment in R/3

  • Existing Duke experience with query/OLAP tools


Role of decision support at duke

Role of Decision Support at Duke

  • Decision Support (DSS) key component of our original design for R/3 strategy because:

    • Lack of easy-to-use query and reporting tools in R/3

    • Problems associated with running reports & queries against the production database

    • Limited accessibility of R/3 for query & reporting

  • DSS planned to provide financial, procurement and HR/Payroll data

  • DSS for Duke is not data warehousing


Original dss design

Original DSS Design

Supported Query &

Reporting Tool(s) -

canned and ad hoc

reports

Hyperion

Supported OLAP

Tool(s)

Standard

Financial

Reporting

Tool

Security Authorization Layer

R/3 Decision Support Database

Summary Financial

Data by Period

Position and

Employee Data

Summary Procure-

ment Data

Data Extraction Layer

  • Monthly/Quarterly/Annual Updates

  • Pay Period Updates

R/3 Production Database

Financial

HR/Payroll

Procurement


Duke dss tool environment

Duke DSS Tool Environment

  • Investigated ETL tools (Informatica, SAS)

  • DSS data stored in Oracle; use standard Oracle tools

  • Front-end tools:

    • Hyperion Enterprise

    • Hyperion Essbase

    • Query tools: Access, Brio Query


Why not bw

Why not BW?

  • Duke reviewed BW in 1999 when it was at version 1.2; first version left a lot to be desired

  • Existing investment in other OLAP tools (Essbase)

  • Level of overhead associated with BW implementation

  • BW in context of larger data warehouse strategy at Duke

  • Door is still open


Dss current status

DSS Current Status

  • Financial DSS was completed this month

    • Series of Oracle tables/views

    • Summarized actuals/budgets at the Fund-Commitment Item-Fiscal Period-Fiscal Year level

    • Source for extracts to front-end tools (Essbase)

    • Directly accessible with query tools

  • Procurement DSS

    • Requirements analysis underway

    • Will be looking at front-end tools

  • HR/Payroll DSS - need to go live first


Financial dss model

Financial DSS Model

Standard ABAP Extract each month

DSS Staging Area

R/3

SQL/Oracle tools to load DSS tables

DSS Tables

Standard monthly extract

Standard monthly extract

Queries via MS Access, Bio Query, etc.

Hyperion Enterprise

Hyperion Essbase

Central/Mgt Ctr Users

Consolidated Health System financial reporting

University web-based financial reporting

Ad-hoc query & reporting


The university of tennessee

The University of Tennessee

  • Land Grant Institution in Tennessee

  • $1.2 billion in revenue

  • 30,000 active accounts

  • 24,300 employees

    14,650 regular employees

    2,050 temporary 7,600 student employees

  • 3,900 faculty


The university of tennessee system

The University of Tennessee System

  • Chattanooga

  • Knoxville

  • Martin

  • Tullahoma

  • Medical School in Memphis

  • Institute of Agriculture

  • School of Veterinary Science

  • Institute for Public Service

  • University Administration


Sap software

SAP Software

  • Purchased SAP software in June 1999

  • Implementation began February 2000

  • Phased Go-Live

    Financials - April and May 2001

    Business Warehouse - May 2001

    HR and Payroll - July 2001

    WorkPlace – Pilot May 2001

    Knowledge Warehouse/iTutor - ??

  • 2,000 named users


Sap business information warehouse

SAP Business Information Warehouse

  • A separate application (add on)

  • Is independent from SAP R/3. Has its own release and shipment cycle.

  • SAP R/3 processes the University’s day-to-day business activities with limited reporting

  • BW is an application that supports business decisions and management


Bw offers the best solution for ut s data warehousing

BW offers the best Solution for UT’s Data Warehousing

  • Integrated with SAP IRIS

  • Delivered Business Content

  • WorkPlace Integration

  • WEB Enabled

  • Support Using existing knowledge base

    • BASIS

    • ABAP

  • Integrated front to back One Solution

    • Extraction

    • Administration

    • Query


Role of business warehouse at university of tennessee

Role of Business Warehouseat University of Tennessee

  • To provide an integrated database used solely for management reporting

  • To support automated standardized reporting for individuals who have MySAP.com Workplace

  • To provide a warehouse for data generated from various systems within the University, including

    - SAP R/3

    - Legacy systems (Financial, HR and Payroll)

    - Student systems

    • Alumni and Development system


Sap bw implementations architecture

SAP BW Implementations & Architecture


Sap bw implementations architecture1

SAP BW Implementations & Architecture


Sap bw implementations architecture2

SAP BW Implementations & Architecture


Sap bw implementations architecture3

SAP BW Implementations & Architecture


Bw reporting tool

BW Reporting Tool

  • BEx Analyzer is implemented as an add-in to Microsoft Excel

  • Tool that is used to:

    Define queries

    Execute queries

    Data is analyzed

    Workbooks are listed


Business explorer analyzer

Business Explorer Analyzer


Business explorer browser

Business Explorer Browser


Sap decision support environments in higher education

Thank you for attending!

Please remember to complete and return your evaluation form following this session.

Session Code: 2204


  • Login