How does SID generation on DSO level affect InfoCube load?

[#1]

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]

Remove "Generation of SID upon Activation" from DSO A, B & C and then see if it improves the performance.

Regards,

Gaurav

[Former Member]

Hi Gaurav,

could you please explain briefly why the removal of "Generation of SID upon Activation" from DSO A, B & C could improve performance of data load from DSO X to Cube?

Thanks very much.

Regards,

Meng