Description
This elementary test recognizes whether there are several lines thathave different DIMIDs(dimension table key), but have thesame SIDs for the selected dimension table for the InfoCubespecified. (This can occur by using parallel loading jobs). This hasnothing to do with an inconsistency. However, unnecessary storage spaceis occupied in the database.

Repairs
Since the different DIMIDs with the same SIDs are normally usedin the fact tables, they cannot simply be deleted. Therefore, all ofthe different DIMIDS in the fact tables are replaced by one DIMID thatis randomly selected from the equivalent ones. Before a change can bemade to the database, the consent of the user is requested.
DIMIDs that have become unnecessary are deleted in theconnection. In doing so, not only are the DIMDs deleted thatwere released in the first part of the repair, but so are all of thosethat are no longer used in the fact tables (including aggregates). Theconsent of the user is again requested before this change is made.