SAP BLOG To Reduce Gaps between SIDs for an InfoObject in SAP BW

SAP Blog

Kayıtlı Üye
Katılım
22 Ara 2017
Mesajlar
1,743
Tepki puanı
7
Puanları
6
Business Case: Large gaps between SIDs. Due to this, if SIDs reach 2 billion records. Then, data load is not possible to dependent target.

Execute a Program: ZSAP_SIDVALDISTRIB to find the Gaps by providing inputs as shown in below screen shot

First.png


Output of Program with percent filled between the splits

Screen Shot for reference:

Second.png


Solution: Implemented following solutions to reduce the GAPs

  1. Apply Semantic Grouping in DTP based on Uniqueness value (even consider Compounding InfoObject also, if main InfoObject is part of Semantic group)
    Third.png
  2. Apply settings to parallel Buffering in Transaction code: SNRO for corresponding InfoObject
    Four.png

Changed to Parallel Buffering
Five.png


Result: Executed Program: ZSAP_SIDVALDISTRIB, by providing inputs to find the Gaps by providing inputs as shown in below screen shot
Six.png


Output: No gaps between SIDs and 100 percent filled
Seven.png


Above implemented solutions, will not minimize / remove the gaps for already existing gaps.

Note:

If need to remove SID Gaps for already existing between SIDs, need to consult SAP for execution of program: ZSAP_SIDHI2LO. Because, SAP team will check which is the best appropriate solution.

Key points:

  1. Apply Semantic Grouping in DTP based on Uniqueness value
  2. Apply settings to parallel processing in Transaction code: SNRO for corresponding InfoObject
  3. Use SAP standard program: ZSAP_SIDHI2LO (with SAP Consulting) for renumbering of SIDs
  4. Program will be provided by SAP from OSS Note: 1331403
    1. ZSAP_SIDMAXGET – To find the InfoObject with Maximum SIDs
    2. ZSAP_SIDHI2LO – To renumber the already SID
    3. ZSAP_SIDVALDISTRIB – To find the percent filled between distribution of SIDs



Reference:

1331403 – SIDs, Numberranges and BW Infoobjects – SAP ONE Support Launchpad

Okumaya devam et...
 
Üst