DTP - Data extraction from very small cube takes very long
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!