Financial Data Warehouse Hyperion Upgrade Project

1
Financial Data Warehouse Hyperion Upgrade Project

• Presented byAlicia Bragg

2
Hyperion Upgrade

• Overview
• Implementation Phases
• Agency Requirements
• Security
• Benefits
• Notional Implementation Schedule

3
Overview

• BRIO 6.6 is at end of life cycle
• Web-based reporting
• E-Authentication utilized for Web Applications
• Upgrade to Hyperion version 9.3
• Phased Approach

4
Implementation Phases

• I. Discovery Phase Completed November, 2006
• Exploration and Documentation of existing system
  architecture
• II. Specification Phase Completed December,
  2006
• Identify and document requirements
• III. Design Phase Completed February, 2007
• Recommendations for hardware/software required
  for implementation

5
Implementation Phases

• IV. Implementation Phase
• Procurement and installation of
  hardware/software.
• V. Test and Validation Phase
• Quality assurance testing and user acceptance
  testing to ensure functionality of new Hyperion
  environment.
• VI. Operational Cutover Phase
• Phased migration of each agency into new Hyperion
  environment.

6
Agency Requirements

• Assignment of agency liaison
• Map BRIO 6.6 software to role in Hyperion
• Intelligence Client with Intelligence Analyzer
  Role formally Insight
• Intelligence Client with Intelligence Dynamic
  Viewer Role formally Quickview
• Assist with mapping of e-Auth user-ids to FDW
  user-ids
• User Acceptance Testing (UAT) participation

7
Security

• Row level security will continue to be maintained
• Web based users will have single point of sign-on
  utilizing USDAs e-Authentication system
• Power users will continue to use TIM/TAM
• Role based security within Hyperion software
• Data will not have to be stored on the users
  desktop

8
Benefits

• Thin-client end user reporting
• Eliminate need for high end workstations for web
  users
• Data results returned incrementally
• Online Analytical Processing (OLAP) interface
• Better integration with Microsoft Office
  applications

9
Notional Implementation Schedule

• June 2007 Award Contract for Phases IV-V
• 4th Quarter 2007 Procurement of
  hardware/software
• 2nd Quarter 2008 Phase IV, Implementation
• 3rd Quarter 2008 Phase V, Testing/Validation
• 3rd Quarter 2008 Phase VI, Operational Cutover