How does SID generation on DSO level affect InfoCube load?

[Former Member]

Hi experts,

I am having big performance issue with data load to InfoCube. In the DTP monitor, the step "Conversion of Characteristic Values to SID" takes about 7-8 mins for each data package of 50000 records. I need to load about 20 millions data & this would take ages.

Below illustrates part of the data flow in my scenario:

DSO A   
DSO B   ======>  DSO X =====> Cube 
DSO C   

In the entry layer, I have DSO A, B, and C which contain header, line item records as well as master data. The option "Generate SID upon Activation" is checked for DSO A, B, & C.

Records from these 3 DSOs are consolidated & enriched into DSO X. In order to reduce load time I have unchecked "Generate SID upon Activation" for DSO X.

Data from DSO X will be written to the Cube 1:1 without any additional transformation logic.

My questions:

1. Since I have generated SIDs for the chars in entry layer, why it still takes so much time to for the SID conversion during Cube load?

2. In this case, is it necessary to generated SIDs in DSO X?

Thanks in advance for any advice. I am in desperate need for a solution to this load problem

Regards,

Meng

[Former Member]

Hi All,

Simillar to the above topic, i have one doubt.

In my case we uncheck the SID generatin upon activation option for a DSO to reduce to activation time, since there is no report developed on it.

After one yr we got one new requirement which leads to devloped a report on this DSO. Now we planned to check the SID generation upon activation option.

Here my doubt is after the changes moved to production system data reload is required.

[RamanKorrapati]

Hi JL,

Data load is not mandatory but during bex report time it may take more time to get old data as there is no SID's. chance to get SID issue at bex level.

You need to maintain SIDs then only you can do reporting on DSO other wise it will be problematic.

Thanks

[Charan-V]

Hi All,

I have an issue similar to above. we have load from DSO to Cube. Normally this DTP takes very less time (58min), but some times it takes 2h 30min and when I checked at detailed level most of the killing time is at "Conversion of Characteristic Values to SIDs"(but records are less only). As suggested above I have ran the report SAP_INFOCUBE_DESIGNS and there is no problem at DIM level below screen shot FR.

at this case can we go for Deleting dimension table before cube loading..?, or is there any other solution for DTP performance improvement.

[RamanKorrapati]

Hi,

if possible try to do RSRV test for your SID consistency check.

Thanks