Iris business warehouse
Download
1 / 17

IRIS Business Warehouse - PowerPoint PPT Presentation


  • 113 Views
  • Uploaded on

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;

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' IRIS Business Warehouse' - vanna


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



ad