Skip to Content
0

DTPs for Corporate Memory

Dec 07, 2017 at 04:51 AM

180

avatar image
Former Member

Hi All,

In the new HANA Optimized BI content, corporate memory ADSO are positioned as in the below picture.

With this design, will there be two DTPs extracting data from the source system? i.e, DTPs to /IMO/CMFIAP30 and /IMO/D_FIAP30 are both getting data from datasource 0FI_AP_30 only. So, when you execute them, data will be extracted twice? Also, how would that work with Delta extraction?

I am not sure I am understanding the new architecture correctly. Can you please help me understand it better?

Thanks a lot!

Bijesh

corp-memory.png (23.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Ashish K Dec 07, 2017 at 02:56 PM
0

Hi Bijesh

The way I understood is that the DSO : /IMO/CMFIAP30 is the acquisition layer containing all fields of datasource without exclusion thereby sufficing the need for reload/reconstruction of data flow within BW itself rather than extracting it from source system.

The delivered transformation connecting this DSO and the Infosource is to be used during reconstruction purpose.

The data flow to DSO: /IMO/D_FIAP30 is the regular flow of data using the datasource with update mode as delta.

Thanks & Regards

Ashish

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Ashish,

Thanks for the answer.

Since we do not have PSAs in BW/4HANA, regardless of the structure of the ADSOs, both DTPs have to perform extraction from the ODP datasource, right? Or is there any method to perform the datasource extraction only once, and populate two ADSOs with the same data?

Thanks,

Bijesh

0
avatar image
Former Member
Dec 11, 2017 at 08:43 AM
0

Hi Bijesh,

in case you decide to use the corporate memory AND load data directly into the /IMO/D_FIAP30, there will be two DTP with extractions of basically the same data from the source system. However each DTP has its own subscription in the source system, hence will get its own delta packages.

You can also go and load into the corporate memory first and from there into the /IMO/D_FIAP30, resulting in only one extraction from the source system.

Please also have a look at the Purchasing line items data flow (below /IMO/D_PUR11). Here you can find a "more PSA-like" DSO (advanced) /IMO/O_PUR11, which you could model into your data flows.

best regards,

Simon

Share
10 |10000 characters needed characters left characters exceeded