Question Re: Load master data from differents datasource BW/4 in Technology Q&A

Load master data from differents datasource BW/4

former_member726451 — Tue, 15 Dec 2020 13:50:20 GMT

Hi,

I have a BW/4 infoobject time dependant with 2 differents datasources from R/3 in order to load attributes.

The first datasource load all attributes except one (in example field X, not mapped in this transformation), the second datasource load only the field X and the rest of the fields are not mapped in the transformation.

I execute the first load and all fields except field X are successfully populated, but after when I execute the DTP full for second datasource all fields populated by the first datasource are empty.

How can I control this situation?

thanks in advance

Re: Load master data from differents datasource BW/4

FCI — Tue, 15 Dec 2020 14:32:27 GMT

Hi David,

This is not normal. If every attributes is time-dependant, some attributes may become blank on specific period depending on the periods you're loading in both data flows (that are not necessarily the same). But the attributes loaded in the first dataflow should stay filled on the validity period loaded in the first dataflow (though periods may be split after the 2nd dataflow depending on the periods loaded).

1st dataSource : 01/01/2020 - 15/01/2020    X       NA
InfoObject :     
                 01/01/2020 - 15/01/2020    X       BLANK
2nd dataSource : 07/01/2020 - 20/01/2020    NA      A     
InfoObject :                               
                 01/01/2020 - 06/01/2020    X        BLANK
                 07/01/2020 - 15/01/2020    X        A     
                 16/01/2020 - 20/01/2020    BLANK    A

Regards,

FCI

Re: Load master data from differents datasource BW/4

MKreitlein — Tue, 15 Dec 2020 14:48:13 GMT

Hello David,

in theory, several error cases are possible:

1) do you use a start- or endroutine and you have selected all fields but eventually don't use them? I did not find an appropriate link, but with incorrect selection, you will clear fields, unwantedly.

2) is it possible the date-from/date-to values don't match, and the one attribute is available in a different time span than the others?

3) Have you tried activating the first request, before loading the second source? I'm not sure but might be there is only one M version of a record available and the 2nd with only one attribute overwrites the first M version with all other attributes filled.

To really find the solution you need to check this or provide more details and screenshots.

Thanks, Martin

Re: Load master data from differents datasource BW/4

former_member726451 — Tue, 15 Dec 2020 18:30:10 GMT

Hello everyone,

I'm agree with you Frederic, I think that is not normal.

This is the transformation of first datasource, with the field ZNIF no update:

After of execute this DTP for example record, you can see that the all fields are populated:

the second transformation only update key fields and the infoobject ZNIF (with a simple mapping routine, get a substring... this is not the problem):

but after executed the second DTP, all fields are empty except ZNIF:

This same logic in BW 7.3 working because between loads I activated master data, but in BW/4 is not neccesary. is there any option in BW/4 for solve it ?

thanks for your time!

regards,

Re: Load master data from differents datasource BW/4

FCI — Thu, 17 Dec 2020 08:47:59 GMT

You lost the attribute values of the previous flow and the associated period of times ?!?!? Interesting 😞

Re: Load master data from differents datasource BW/4

FCI — Thu, 17 Dec 2020 09:05:49 GMT

I don't see the link with the disappearance of the activation in BW4. In 7.5, it was also working with an activation between the 2 loads (same configuration as yours).

Re: Load master data from differents datasource BW/4

FCI — Thu, 17 Dec 2020 09:39:21 GMT

Debjit Singha Hmm, I must admit I didn't understand why you would assume ZNIF is a composite key.From the screen shots, I'm only seeing 0EMPLOYEE, 0OBJVERS and 0DATETO. Though I'm puzzled by the position of the target keys in the transformation (at the end).

Re: Load master data from differents datasource BW/4

former_member726451 — Thu, 17 Dec 2020 13:16:41 GMT

Hi Debjit Singha,

Thank you for your help in this matter.

I know the load mater data process with time dependant infoobjects.

About your solutions, I prefer don´t create a intermediate DSO and add ZNIF as field of first datasource (0EMPLOYEE_ATTR) and avoid the second load, but your proposition is ok. In any case, I want to understand this problem in BW/4 because en my old system BW 7.3 this logic with the same datasources working. In BW 7.3 I can activate master data between loads (using process chains) but in BW/4 I can´t activate manually infobect (the infoobject activation in auto)

thanks you very much again.

regards

Re: Load master data from differents datasource BW/4

former_member726451 — Thu, 17 Dec 2020 13:58:06 GMT

Hi Martin,

About your comments:

1) I haven't start/end routines in the transformation, but yesterday I did a test adding end routines empty in each transformation but with the fields marked respectively, not worked...

2) I think that interval dates are correct. In my old BW 7.3 these logic working whitout problems (activating master data between loads)

3) In my BW 7.3 yes, but in my current BW/4 I can´t activate 0EMPLOYEE master data before second load, in BW/4 the infoobject are activating automatically.

In BW/4, are there any option but I don´t know?

Thanks for your help!

regards

Re: Load master data from differents datasource BW/4

MKreitlein — Thu, 17 Dec 2020 14:08:33 GMT

Hello David,

I still work in BW 7.5x, so did not know that BW4 is differently.

A short lookup in the SAP Support Portal showed this note: https://launchpad.support.sap.com/#/notes/2753882

Obviously it describes a solution of activating the data via a Function Module.

You could try this once...

Regards, Martin

Re: Load master data from differents datasource BW/4

FCI — Thu, 17 Dec 2020 15:56:27 GMT

Debjit Singha I'm pretty sure but it was few years back. David seems to still have a 7.3 where it is working though.

Re: Load master data from differents datasource BW/4

FCI — Thu, 17 Dec 2020 15:59:16 GMT

Not exactly. This program reorganizes the time dependant attributes. It merges the time periods for which all the attributes are identical.

Re: Load master data from differents datasource BW/4

anishjmenon — Wed, 23 Dec 2020 05:13:20 GMT

Hello David,

You may try this note. We had similar issue and this note resolved it for us.

2923327

Regards,

Anish

Re: Load master data from differents datasource BW/4

former_member821494 — Wed, 04 Jan 2023 11:36:54 GMT

Hello, I have the same problem and I couldn't find the solution. How did you solve it?