iris business warehouse
Download
Skip this Video
Download Presentation
IRIS Business Warehouse

Loading in 2 Seconds...

play fullscreen
1 / 17

IRIS Business Warehouse - PowerPoint PPT Presentation


  • 114 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