Delta index

[Former Member]

Hi All,

I have a query based upon the Delta Indexes. Please help in this cause. We have an S index table which consists of 652356 records. One of the Sap note states that any index table more than 500000 records to be declared as delta index. Even i have checked in the RSRV test for propose delta index. It also suggested me assign that as the delta index. Is that checks are enough to delcare the index as delta index or if anything is still missed out before moving into main index to delta index.

Please let me know on this if any one come across.

[Former Member]

Thanks..

[Vitaliy-R]

One is the number of records in the index. The second is how often is this index being updated during the day? Is it once during nightly master data load OR more often?

Regards,

-Vitaliy

[Former Member]

Hi Vitality,

Thanks for the reply.

1) Yes its having more than 6 lac records.

2) As for my knowledge this index is updating once in a day, as you said its in the night precisley. By the way is there any way to check how many times its updating this index?

Eager to see ur answers.

[Vitaliy-R]

If I remember correctly Indian "6 lacs" is 600,000, right? Because this is S-table, it can be updated by data loads into the cubes as well.

I would recommend:

1/ Check that master data load and ACR are completed before loads to the cubes that use this InfoObject.

2/ Enable "delta" feature for this S-table. You will need to integrate deltas into main index from time to time, as indicated by the system or periodicaly.

3/ Open OSS Customer Msg to SAP to investigate.

Regards,

-Vitaliy