Skip to Content
author's profile photo crossmen crossmen
crossmen crossmen

MIssing secondary index for DSO

Posted on Sep 25, 2018 at 10:45 AM 37 Views

Hello Experts ,

I have noticed recently a missing secondary index when refreshing DB02 TCODE.Wich impact the performance data loading from this DSO to others infocubes.

to fix this issue I have schueled the report SAP_INFOCUBE_INDEXES_REPAIR to rebuild daily the all missing secondary index .

But unfounthly , some times I get the missing secondary in the middle of the night after the execution the above report .hence . the data loading is impacted

Do you have eplease any idea regarding the root cause of the missing secondary index?

Any alternate solution to avoid this situation?

Many thanks in advance for your help.

BW (SAP Business Warehouse) BW Content and Extractors
Add comment
10|10000 characters needed characters exceeded

1 Answer

  • author's profile photo Eugeniy LANCEV
    Eugeniy LANCEV
    Posted on Sep 25, 2018 at 12:17 PM

    Do you delete/create a indexes for cube (by process "Delete index"/"Build index") when you loading data by process chain? Before loading you must delete indexes and after loading you must build indexes. Check help: https://help.sap.com/saphelp_nw70/helpdata/EN/80/1a6473e07211d2acb80000e829fbfe/content.htm?no_cache=true

    Add comment
    10|10000 characters needed characters exceeded