Skip to Content

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

long time compression of infocube.

Hi Gurus!

I have big problem. In one infocube we have too many uncompress reguests (approx 40 000). When i try compress this infocube everything is OK but compresiion take too much time. When I check this job in SM37 it can be seen that problem is in subproccess ALTER TABLE <table name - it is F fact table of infocube> DROP PARTITION <name of partition - /BIC/F<cubename000000000x>>. Time duration of ALTERING table is aproxx. 4 minutes for one partition and this is big problem because I think that amount of request is equal amount of partiton of F fact table of corresponding infocube.(in my case 40000req x 4min...........)

What can i do for improve PERFORMANCE of compression.

Thank you for all answers!

KOX

Edited by: Michal Pikus on Oct 1, 2008 4:35 PM

Former Member

Helpful Answer

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