Skip to Content
Author's profile photo Former Member

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

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.


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.


High Level Data Flow Diagram

High Level Data Flow.png

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

1. JDBC adapter

2. ESA-SAP adapter

3. Iview adapter


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.


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


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.


developments would be from SAP Side


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

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Thanks for sharing this new concept..