BUSINESS WAREHOUSE: Assessment Project Enters Last Phase - 11/25/08

Consultants with the Chicago-based firm Tahoe Partners presented their findings for the “Discovery” phase of the Business Warehouse Assessment Project on Nov. 4, when they met with the project’s sponsors and key stakeholders and core team members. Their findings were based on 11 overview or deep dive (in-depth discovery) sessions that focused on gaining a sound understanding of the business requirements related to the key SAP modules defined by the project team.

Less than two weeks later, project sponsors and stakeholders approved the Discovery Deliverable documentation, moving the project to the “Roadmap” phase. The SAP BW roadmap will document several significant modifications to the BW structure to better meet the needs of the SAP reporting community. This will include recommendations that will:

-- Enable rearchitecture of the current BW structure to more efficiently process queries.
-- Add numerous data fields needed by end users to create meaningful reporting.
-- Effectively structure the BW to take advantage of the enhanced reporting capabilities offered by the Cognos reporting tool.
-- Understand and design a data security environment to manage the new BW/Cognos environment.

The result of the Roadmap phase will allow the launch of the next project, the build out of the Business Warehouse. This will be a staged implementation with the initial focus on the components needed for Grants Management - Account Information Management System, according to project co-sponsor Mike Szczepanski. Once this portion of the BW build is complete, development of the GM AIMS can move forward.

The BW assessment project started in July with in-house data gathering sessions. Its targeted completion is mid December. The assessment will position the team for the development of a more robust reporting capability for BW end users, as well as provide groundwork for Cognos as the reporting tool to replace the SAP BEx tool.

Members of the assessment team are: project manager Melissa Burton; key Business Services team members Hans Sigg, Cheryl Gray, Joe Braun and Cheri Rawles; key ITaP BW team members Harry Smith, Linda Kirsch, Debby Upchurch, and approximately 50 other staff at West Lafayette and regional campuses. Brad Skiles is the other co-sponsor and key stakeholders include many Business Services senior staff and Jeff Whitten from ITaP.

More details about the BW assessment project are available on the Business Services Computing Web page.