performance issue while loading data from write optimized Dso to Infocube

[srikanth_rapur2]

Hi All,

We are facing performance issue while loading data from write optimized Dso to Infocube(FI related data), it is a full load. Every time before loading the data into the infocube it will delete the previous request.

It suppose to complete with in 8 hrs to execute 78 laks records but suddenely it is taking more than 28 hrs to complete the load.

" Conversion of characteristic values to sid"  step is taking more than 50 - 60 mins for each data packet, before it was taking only 5 to 8 mins in this step.

1). we reduced the data packet size from 50,000 to 30,000 and increased the no of parrel processing from 3 to 9, but no change in performance

2). we checked in RSRV for inconsistency of dimensional table and SID tables.But, everything is fine here.

3). we checked with the program SAP_INFOCUBE_DESIGN,we found one of the dimensional table size showing 111%.

4). sufficient back ground jobs are available, and also triggered the loads in the non business hours, but no improvement.

We are facing this issue after the system upgrade from 7.0 to 7.01, sp 14.

Could you please help into this issue.

Regards

rapur

[colm_boyle]

Hi Rapur,

Please see Andras steps above and also my reply to his thread,

thanks,

Colm