Load master data from differents datasource BW/4

[former_member726451]

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

[former_member726451]

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

[former_member726451]

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,

[FCI]

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

[FCI]

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).

[FCI]

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).

[FCI]

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.