How To Fix RSD_TREX518 - Größe der InfoCube-Faktentabelle mit dem Faktenindex vergleichen

SAP Error Message - Details

• Message type: E = Error

• Message class: RSD_TREX - Messages from TREX Aggregate Area

• Message number: 518

• Message text: Größe der InfoCube-Faktentabelle mit dem Faktenindex vergleichen

Description
The test calculates the number of records in both fact tables (E and F
tables) for the InfoCube and compares them with the number of records in
the fact index of the BWA index.
If the number of records in the BWA index is significantly greater (>
10%) than the number of those in the InfoCube, you can improve query
performance by rebuilding the BWA index.
A difference in the number of records can be caused by the following:
The InfoCube was compressed after the BWA index was built. Since the BWA
index is not compressed, it can potentially contain more records than
the InfoCube.
Requests were deleted from the InfoCube after the BWA index was built.
The requests are deleted from the BWA index in the package dimension
only. The records in the fact index are therefore no longer referenced
and no longer taken into account when the query is executed; they are
not, however, deleted.
<ZH>Note that the database statistics</> for calculating the size of the
fact table <ZH>must be up to date</>, since the test does not recount
it uses the database statistics from the tables.
Repair
It is not mandatory to rebuild the indexes, but this could be advisable
if the difference is significant.

Das System gibt eine Fehlermeldung aus und erlaubt Ihnen nicht, mit dieser Transaktion fortzufahren, bis der Fehler behoben ist.

Fehlermeldungsextrakt aus SAP-System. Copyright SAP SE