Slow loads in ODS

[Former Member]

Hi

I'm new here but i've been catching up on the readings! My problem is I have a ODS that is taking too long to load (1 hour to load 5000 records). I look at the details of monitor and it looks like update rules take the most time. Any suggestions on how i can improve my performance?

Thank you

[Former Member · Accepted solution]

Hi!

From where do you look up the data per material number? From an ODS object (or any other flat table)?

In this case you may want to create a secondary index containing the material number for the ODS table. This will speed up look-ups a lot.

Or (depending on the number of records) you can read the material data into an internal table in the start routine an then look up the date from the internal table instead of reading it from a database table.

Hope this helps,

Christian

[Former Member]

Do you have a 'start routine'. You can check some ABAP tuning and logic tuning there..?

1 hour for 5000.. ahh.. may be very starange with a poor code in the start routine also..

regards,

Hari

[Former Member]

Hi Hari

I don't have a start routine. I do have update rule routines though for some of my key figures.

[former_member188975]

Hi Satya,

Usually we prefer to place the code in the Start routine as the prcessing is more efficient and faster than in individual update routines. Would it be possible for you to shift the processing (code) from the update routines for your key figures, to the Start Routine?

[Former Member]

Dear Satya,

1) What was that routine does?

2) What is your source system?

3) We normally prefer 'caliculations' in start routine..

regards,

Hari

[Former Member]

1 - I have different routines for each key figures. the routine looks for the latest date of a transaction for a material and saves the sales.

2 - My source is a ODS

3 - Would a start routine allow me to do what i want in #1? I thought start routine only allows u to save global variables and not fill specific key figures

[Former Member]

Dear satya,

You can do them in the start routine verymuch.

regards,

Hari

[Former Member]

Use start routine to fill internal tables with data from the required MD tables..or ODS tables.

Then use READ on internal table in update routine.

This will improve performance.

regards,

Vishvesh

[Former Member]

Hi,

also sort your internal tables according your accesskey so you can use READ with binary search later

/manfred

[Former Member]

Also uncheck the reporting available for reports checkbox if you are not using ods for reports development.

-Vachan