Multiple inputs in an InfoCube dimension

Message type: E = Error

Message class: RSRV -

Message number: 112

Message text: Multiple inputs in an InfoCube dimension



Description
This elementary test recognizes whether there are several lines that
have different <SE><AB>DIMID</></>s(dimension table key), but have the
same <AB>SID</>s for the selected dimension table for the InfoCube
specified. (This can occur by using parallel loading jobs). This has
nothing to do with an inconsistency. However, unnecessary storage space
is occupied in the database.

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.



Repairs
Since the different <EX>DIMID</>s with the same SIDs are normally used
in the fact tables, they cannot simply be deleted. Therefore, all of
the different DIMIDS in the fact tables are replaced by one DIMID that
is randomly selected from the equivalent ones. Before a change can be
made to the database, the consent of the user is requested.
<EX>DIMID</>s that have become unnecessary are deleted in the
connection. In doing so, not only are the <EX>DIMD</>s deleted that
were released in the first part of the repair, but so are all of those
that are no longer used in the fact tables (including aggregates). The
consent of the user is again requested before this change is made.


How to fix this error?



Procedure for System Administrators


Error message extract from SAP system. Copyright SAP SE.