Skip to Content
1
Former Member
Jul 20, 2007 at 04:11 PM

Performance of the update rule routine

12 Views

Hi ,

I have to update the value of the Source system ID during the ODS to Infocube update rule.

Source system id is added object in the infocube. ODS doesn't have sourcesystem id . I have populate the value from Service order master data .

Update rule - characteristic - I have created a routine - value is populating properly.

During the data load it is taking long time(5 million records) .

For improving the performance - Do I need to update the code in the Start routine of the update rule.

Data_package doesn't have a component called source system.

Code in the routine :

data: IT_SS LIKE /BI0/PCS_ORDER-SOURSYSTEM .

SELECT SOURSYSTEM FROM /BI0/PCS_ORDER INTO IT_SS

WHERE CS_ORDER = COMM_STRUCTURE-CS_ORDER.

ENDSELECT.

  • result value of the routine

IF SY-SUBRC = 0.

RESULT = IT_SS.

ENDIF.

Please advise me how can I improve the performance of the dataload because of this routine.