Iris business warehouse
This presentation is the property of its rightful owner.
Sponsored Links
1 / 17

IRIS Business Warehouse PowerPoint PPT Presentation


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

IRIS Business Warehouse. Legacy Business Warehouse (LBW) Blueprint Specification May, 2000. LBW Blueprint Specification. Project Objectives Preserve legacy master and detail data not planned for conversion into the IRIS R/3 system;

Download Presentation

IRIS Business Warehouse

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


Iris business warehouse

IRIS Business Warehouse

Legacy Business Warehouse (LBW)

Blueprint Specification

May, 2000


Lbw blueprint specification

LBW Blueprint Specification

  • Project Objectives

    • Preserve legacy master and detail data not planned for conversion into the IRIS R/3 system;

    • Provide continuing computer access to legacy data for query, reporting and decision support.


Lbw blueprint specification1

LBW Blueprint Specification

  • Planned Go Live April 2, 2001

  • Legacy Data “Frozen” as of March 31, 2001

  • Prototype Implementation Planned for December 1,2000


Lbw blueprint specification2

LBW Blueprint Specification

  • In Scope Deliverables

    • Extraction and Load of UT Legacy System’s Relevant Detail and Master Data

    • Design and Development of LBW “InfoCubes”

    • Identification and Training of Strategic Query End Users


Lbw blueprint specification3

LBW Blueprint Specification

  • In Scope Deliverables (continued)

    • Identification and Training of Reporting End Users

    • Deployment of BW Explorer

    • Development of Limited Report Templates and Examples

    • Establishment of BW Technical Environment


Lbw blueprint specification4

LBW Blueprint Specification

  • In Scope Deliverable (continued)

    • Investigation of Alternate Query, Reporting and Decision Support Tools


Lbw blueprint specification5

LBW Blueprint Specification

  • Out of Scope Actions and Deliverables

    • Reverse Conversion of IRIS R/3 Data for April, May and June of FY 2001

    • Any Capability for Retroactive Adjust of Payroll or Financial Data

    • Development of BW Queries and Reports Beyond Templates and Examples


Lbw blueprint specification6

LBW Blueprint Specification

  • Out of Scope Actions and Deliverables (continued)

    • Implementation and Deployment of Any Query or Reporting Tool Other Than BW Explorer

    • Inclusion of Legacy Data Sources Not Identified in Blueprint


Lbw blueprint specification7

LBW Blueprint Specification

  • Ten (10) mainframe data sources identified as important for preservation and continued access via computer.

  • Financial Data Sources

    • DFNLEDGR database – UT’s Official Account Attribute and Accounting Balances Database


Lbw blueprint specification8

LBW Blueprint Specification

  • Financial Data Sources (continued)

    • DFNYACTV database – the detailed accounting transaction data base supporting balances

    • DFNGRANT database – Grant and Contract Attribute Data


Lbw blueprint specification9

LBW Blueprint Specification

  • Financial Data Sources (continued)

    • DFNPORDR database – UT’s Financial Purchase Order Database

    • FLVENDOR database – UT’s Vendor Database

    • DNFPAYEE database – UT’s Payee Database


Lbw blueprint specification10

LBW Blueprint Specification

  • Financial Data Sources (continued)

    • GHHISTRY database – UT’s Purchase Order MicroFiche Reference Database


Lbw blueprint specification11

LBW Blueprint Specification

  • Payroll and Human Resources Data Sources

    • DHREMPLY database – UT’s Primary Payroll and Human Resources Attribute and Balance Database

    • Payroll History File – UT’s “Check Stub” History File

    • Salary Budget File – UT’s Salary Budget and FY Start


Lbw blueprint specification12

LBW Blueprint Specification

  • LBW Security

    • Will Parallel IRIS Security

    • Two Types of User Profiles

      • Strategic Query Users – Unlimited Access

      • Reporting Users – Unlimited Financial Balances Access


Lbw blueprint specification13

LBW Blueprint Specification

  • BW Explorer – Query, Reporting and DSS Tool

    • Easy to Use Excel Like Format

    • Visual Basic Link for Additional Processing Power

    • 64,000 Row Query Limit


Lbw blueprint specification14

LBW Blueprint Specification

  • Open Issues

    • Strategy for Campus Access to Referential Files for Chart of Accounts and Employee Status Validation

    • Disposition of Data Not Converted into IRIS R/3 and Not Preserved in LBW


Lbw blueprint specification15

LBW Blueprint Specification

Questions?


  • Login