Skip to Content

This is my first post, and I’d like to share some experiments that I studied to development a business scenario but it is not a lab scenario.


We are building a business scenario for planning and wehave to loaddata from SAP ECC 6.0 to compose the analyses, in this case we using the Data Source 0PU_IS_PS_32.

The image belowshows part of the scenario. In this case we usingaDSO object like a Propagation Layer that receivedall data from Data Source.

/wp-content/uploads/2015/07/001_754539.png

The comparison istwo scenarios to load data:

  • ·        Using DTP with HANA Execution: in this case is mandatoryuse an InfoPackage, because we needa PSA to activate that configuration.
  • ·        Using DTP with direct extration: in this case HANA Executionis disable and we don’thave PSA.

DTP configuration using HANA Execution:

/wp-content/uploads/2015/07/002_754540.png/wp-content/uploads/2015/07/003_754568.png

Process Chain to execute ETL scenario:

/wp-content/uploads/2015/07/004_754569.png

This is the job in SourceSystem – SAP ECC – when we used InfoPackage with PSA.

/wp-content/uploads/2015/07/005_754570.png

This is the monitor of DTP loading data using HANA Execution and PSA.

/wp-content/uploads/2015/07/006_754574.png

Process Chain Start time: 09:42:55

Process Chain Finish time: 10:00:35

Process Chain execution time: 00:17:40

Now I changed the configurations to load data from DTP, but the option to HANA Execution is unavaliable. The filters is the same of InfoPackage above.

/wp-content/uploads/2015/07/7_754585.png

/wp-content/uploads/2015/07/8_754586.png

The Process Chain was changed too.

9[.png

The DTP Monitor with execution data in this case.

/wp-content/uploads/2015/07/10_754588.png

Process Chain Start time: 10:05:01

Process Chain Finish time: 10:18:10

Process Chain execution time: 00:13:09

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply