Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

DTP - Data extraction from very small cube takes very long

Hi all,

I have a cube, which contains only 4 records.

The cube has about 200 key figures and 145 characteristics.

I have configured a loop-load transformation, which basically does nothing else then a sign-reversal for all key figures.

The DTP for this loop-load took more than 5 hours for the step "Extraction from InfoCube ..." and it was defined with a filter on a time characteristic, which basically selected all records in the cube. Transformation and update to cube ran through in about 2 minutes.

We encountered these long-running extraction steps several times. Also with filters on the DTP which were set in a way, that no data should be selected, the extraction took 30 minutes up to 1 1/2 hours on a cube with only 4 records (!).

The cube's statistics and index are active.

Any idea, why the DTP takes so much time for extracting the data?

Thanks for any answers in advance!

Kind regards,

Philipp Hinnah

Not what you were looking for? View more on this topic or Ask a question