Master Data lookup in Update Rule problem

[Former Member]

Hi all,

I am currently having a problem loading data to an InfoCube using flat files.

The architecture is as follows:

1) The source of the data is a flat file

2) The data is loaded thru an Update Rule and is of type Full-Update

3) The Update Rules determines the Profit Center using the Master Data of the WBS-Element

4) The data is written in an InfoCube

This solution however does not always work as planned. In the following situation a problem occurs:

1) The flat file contains WBS-element RD.00753.02.01, which has a Profit Center attribute value 8060

2) When I load the flat file, the PC value 8060 is written into the row in the InfoCube, which is correct

3) Then I change the master data of the WBS-element by setting the Profit Center attribute value to 8068

4) I run the Attribute Change Run

5) Then i load a flat file again, which also contains WBS-element RD.00753.02.01

6) The master data attribute value should now write the value 8068 into the InfoCube. HOWEVER, this is when the evil occurs. BW does not write a PC value of 8068, but it write the value 8060. This is wrong.

Why does BW not take the newest version of the Master Data to performe the attribute value look-up? Or why doesn't BW write the correct Profit Center into the cube?

Thanks,

Onno

[Former Member · Accepted solution]

Hi Onno,

please check your routine and control if you have the statement: select... from... where... and OBJVERS = 'A'.

Maybe you are not selecting from /BIC/P... table the active data.

Ciao.

Riccardo.

[Former Member · Accepted solution]

Hi Riccardo,

The attribute value is not being selected using a routine, but the standard "Master Data Attribute Of..." option in the Update Rule source definition. Shouldn't this always use the active, current version of the Master Data?

Onno

[Former Member · Accepted solution]

Hi Onno,

do not use this kind of update rules.

Use ABAP code, it is better and more performant.

Also check from Debug via PSA where is the problem during upload.

Ciao.

Riccardo.

[Former Member · Accepted solution]

Hi Ricardo,

The debug via PSA simulation of the update indicates that the CORRECT Profit Center value is to be written into the InfoCube.

However, if I check the contents of the cube (after the load has finished) using the request-id the WRONG Profit Center value is shown. This indicates that the correct Master Data is used, however the update of the Cube is wrong. Why does this happen. the load is of type full-update, so should add a new row in the cube using the value in the data from the UR.

Onno

[Former Member · Accepted solution]

Hi Onno,

try with these steps:

1)Introduce ABAP code in update rules for this field and activate once again update rules.

2)RSA1 --> Tools --> Change attributes / hierachies --> Execute.

3)Upload once again data in your cube.

Hope this help.

Ciao.

Riccardo.

[Former Member · Accepted solution]

Hi Riccardo,

Without changing ANYTHING i have tried to re-run the load as i wanted to re-try the simulation. Strangely the records have been booked into the cube correctly this time. It feels my BW system is trying to get me crazy...

Thnx for your answers!

Onno

[Former Member · Accepted solution]

Hi Onno,

Happy for you, but to avoid future problems chenge the update rule setting introducing the ABAP code.

Ciao.

Riccardo.