Automation of Extraction from Project Portfolio Data Base for BW Reporting

Business Need/Purpose:

Current Situation:

Project management and Continuous Improvement tracking is maintained in multiple
systems (Quick Base, XLS). Tracking of Projects or Continuous Improvements,
staffing, and costs within each of these systems is handled differently
depending on organization ownership.
Interfaces, reporting, staffing requirements, and cost information
varies by system and organization ownership / user group. 

Key issues as a result of the current
situation

With use of
varied systems and project methodologies tracking and reporting of Projects
against results, staffing demand and costs is difficult.  Because of these varied  methods of tracking and reporting,
information shared with customers,
sponsors, stakeholders, boards, and upper management causes inaccuracy’s
and misunderstanding of the data and additional work to provide clarity and or
modification of reporting to ensure apple to apple comparison / information.

Proposal:

A Report would
be built to have a standardized tracking and reporting process. The single
report to be used for driving consistency in project methodology, staffing,
cost tracking.

Procedure:

High Level Data Flow Diagram

Lists of Possible adapters that can help to bring the data’s into SAP

1. JDBC adapter

2. ESA-SAP adapter

3. Iview adapter

Scenario1:

1) Creation of
view in Oracle data base.

2) Pass the
data into SAP PI though Push operations.

3) The above
can be achieved by writing an exit (SAP Term) from oracle side and it triggers
the data into sap PI.

4) Data’s from
SAP PI can be send to SAP BI by real time data acquisition method.

Merits

Performance
would be better as when ever project is created in portal then it wil send the
data into sap PI.

De-Merits:

Development
required from oracle side.

Scenerio 2:

1)Creation of View in oracle data base

2)PI will pull the data into sap

3)Scheduling can be don’t to make it automated

4)Data’s from SAP PI can be send to SAP BI by real time data acquisition method.

Merits:

Maximum
developments would be from SAP Side

Demerits:

Performance
would be bit low as SAP PI triggers every time (every day if scheduled) to take
the delta records