iris business warehouse legacy business warehouse (lbw) blueprint specification may, 2000

IRIS Business Warehouse

Legacy Business Warehouse (LBW)Legacy Business Warehouse (LBW)

Blueprint SpecificationBlueprint Specification

May, 2000May, 2000

LBW Blueprint Specification

Project ObjectivesProject Objectives Preserve legacy master and detail data Preserve legacy master and detail data

not planned for conversion into the IRIS not planned for conversion into the IRIS R/3 system;R/3 system;

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


Planned Go Live April 2, 2001Planned Go Live April 2, 2001

Legacy Data “Frozen” as of March 31, Legacy Data “Frozen” as of March 31, 20012001

Prototype Implementation Planned for Prototype Implementation Planned for December 1,2000December 1,2000


In Scope DeliverablesIn Scope Deliverables Extraction and Load of UT Legacy Extraction and Load of UT Legacy

System’s Relevant Detail and Master System’s Relevant Detail and Master DataData

Design and Development of LBW Design and Development of LBW “InfoCubes”“InfoCubes”

Identification and Training of Strategic Identification and Training of Strategic Query End UsersQuery End Users


In Scope Deliverables (continued)In Scope Deliverables (continued) Identification and Training of Reporting Identification and Training of Reporting

End UsersEnd Users Deployment of BW ExplorerDeployment of BW Explorer Development of Limited Report Development of Limited Report

Templates and ExamplesTemplates and Examples Establishment of BW Technical Establishment of BW Technical

EnvironmentEnvironment


In Scope Deliverable (continued)In Scope Deliverable (continued) Investigation of Alternate Query, Investigation of Alternate Query,

Reporting and Decision Support ToolsReporting and Decision Support Tools


Out of Scope Actions and DeliverablesOut of Scope Actions and Deliverables Reverse Conversion of IRIS R/3 Data for Reverse Conversion of IRIS R/3 Data for

April, May and June of FY 2001April, May and June of FY 2001 Any Capability for Retroactive Adjust of Any Capability for Retroactive Adjust of

Payroll or Financial DataPayroll or Financial Data Development of BW Queries and Reports Development of BW Queries and Reports

Beyond Templates and ExamplesBeyond Templates and Examples


Out of Scope Actions and Deliverables Out of Scope Actions and Deliverables (continued)(continued) Implementation and Deployment of Any Implementation and Deployment of Any

Query or Reporting Tool Other Than BW Query or Reporting Tool Other Than BW ExplorerExplorer

Inclusion of Legacy Data Sources Not Inclusion of Legacy Data Sources Not Identified in BlueprintIdentified in Blueprint


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

Financial Data SourcesFinancial Data Sources DFNLEDGR database – UT’s Official DFNLEDGR database – UT’s Official

Account Attribute and Accounting Account Attribute and Accounting Balances DatabaseBalances Database


Financial Data Sources (continued)Financial Data Sources (continued) DFNYACTV database – the detailed DFNYACTV database – the detailed

accounting transaction data base accounting transaction data base supporting balancessupporting balances

DFNGRANT database – Grant and DFNGRANT database – Grant and Contract Attribute DataContract Attribute Data


Financial Data Sources (continued)Financial Data Sources (continued) DFNPORDR database – UT’s Financial DFNPORDR database – UT’s Financial

Purchase Order DatabasePurchase Order Database FLVENDOR database – UT’s Vendor FLVENDOR database – UT’s Vendor

DatabaseDatabase DNFPAYEE database – UT’s Payee DNFPAYEE database – UT’s Payee

DatabaseDatabase


Financial Data Sources (continued)Financial Data Sources (continued) GHHISTRY database – UT’s Purchase GHHISTRY database – UT’s Purchase

Order MicroFiche Reference DatabaseOrder MicroFiche Reference Database


Payroll and Human Resources Data SourcesPayroll and Human Resources Data Sources DHREMPLY database – UT’s Primary DHREMPLY database – UT’s Primary

Payroll and Human Resources Attribute Payroll and Human Resources Attribute and Balance Databaseand Balance Database

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

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


LBW SecurityLBW Security Will Parallel IRIS SecurityWill Parallel IRIS Security Two Types of User ProfilesTwo Types of User Profiles

Strategic Query Users – Unlimited Strategic Query Users – Unlimited AccessAccess

Reporting Users – Unlimited Financial Reporting Users – Unlimited Financial Balances AccessBalances Access


BW Explorer – Query, Reporting and DSS BW Explorer – Query, Reporting and DSS ToolTool Easy to Use Excel Like FormatEasy to Use Excel Like Format Visual Basic Link for Additional Visual Basic Link for Additional

Processing PowerProcessing Power 64,000 Row Query Limit64,000 Row Query Limit


Open IssuesOpen Issues Strategy for Campus Access to Strategy for Campus Access to

Referential Files for Chart of Accounts Referential Files for Chart of Accounts and Employee Status Validationand Employee Status Validation

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


Questions?

iris business warehouse legacy business warehouse (lbw) blueprint specification may, 2000

Documents