Data load along with analyzation

[Former Member]

Hello,

We had a data inconsistency situation and ran RSRV tests. One of the tests is INITIAL KEY FIGURE UNITS IN FACT TABLES. This test gave a red light giving the message "RESULT OF CHECK FOR KEY FIGURE UNITS IN FACT TABLES OF INFO CUBE "ZXXXXX" ARE EMPTY.

The description is as follows:

Message no. RSRV117

Description:

In the fact tables (E and F tables) of an InfoCube, a search is being carried out for those records that contain values other than zero for key figures that have units, but for which the unit of the key figure is blank (has no value).

Since the value of the unit has to correspond to the value of the key figure, such records would indicate an error in the data upload. The values of the units have not been loaded correctly into BW.

Repairs

There are no automatic repair options. Reload the data.

SO do I need to load all my data once again. Is this error because the data coming from R/3 has no units? Do I need to correct anything in the infocube before loading data? Also can somebody give me a link or documentation for step by step procedure for extraction and loading from R/3 to infocube at the same time analyzing the data load at each step?

Thank you

[former_member184494]

When you load data from R/3 for a quantity the extractor would not be created without a unit variable. check your extractor and transfer structure.

And if you are assigning units to a separate quantity then you have to assign units manually using a routine in transfer rules.

Arun

[Former Member]

Hai Arun,

Thanks for taking time to reply. I checked the transfer structure and it does have the currency fields. The currency fields are ZZWAERK(SD document currency) and LCURR(Currency key of the local currency). is that what you are talking about? The extraction was done long back and also the reports are being run.

Can you please clarify what you said based on this information?

THanks once again.

[Former Member]

Hi Visu,

As I understand what he meant is to check the fields in the Extractor that are populating the Currency Key fields that you specified in BW.

If you have a 1-1 mapping in your Transfer structure;

Run the Extractor in RSA3 on R/3 side for the records which have no units comming in.

And then in the output display make sure that those fields are being populated.

If you are using Transfer rules to pupulate those fields debug the transfer rules to find out why you are not getting the units populated correctly..

Let us know ..

Ashish.