Data in request 0 is inconsistent

[Former Member]

Hi Experts,

While compressing the infocube 0IC_c01, The compression failes with the following error message.

"Data in request 0 is inconsistent (several records with identical keys)"

When I click on the messsage it shows the procedure to correct this problem.

Procedure

Reorganize the data in request 0, or try to eliminate the error by restructuring the InfoCube.

What does this means?

How can I correct this problem.

Thanks

[Former Member]

Sunil,

<u><b>Resstructuring Infocube</b></u>.

With this function, you can fill an InfoCube with requests that have already been loaded into a BW, or into another InfoCube. You can, therefore, create a new InfoCube in BW, and use data that has already been loaded successfully into the PSA or into the IDOCs to fill the new InfoCube.

In the InfoCube tree, choose the InfoCube that you want to fill > right click > Administrate.

Choose Reconstruct > Selection, and, using the selection options, determine the requests that you want to use to reconstruct the InfoCube.

Select the corresponding requests from the list, and choose Reconstruct.

<b>NOTE:</b>

This function is particularly useful, if you are loading deltas, that is, data that you cannot request again from the source system.

Let me know if you need any further clarifications.

Thanks

Ramu

<u></u><u></u><u></u><i></i>