Skip to Content
0

BW cube Compression is running long time

May 09, 2017 at 03:08 PM

67

avatar image

Hi All,

Recently ,we have reloaded historical data for entire fiscal year period and it fetched 68 lakhs records.we have executed collapse step and its running long time (2 days).

Also,throwing dumps at background process.

Note:Now daily Data loads are running to the cube ,couldn't able compress as previous request compression not done.

solution pls

Regards,

Giridharan R

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

John Hawk May 11, 2017 at 09:08 PM
0

Hi Giridharan

Are you compressing with zero row elimination? Do you want zero row elimination?

It's the zero row elimination which takes the most time.

If this is a reload from a standard DSO , I would turn off zero elimination for the historical request, since there should be no reversing entries to create a zero row anyway. The check for zero rows will be skipped. It's the check which takes the most time.

Otherwise, consider reloading and compressing by Fiscal Period or day to create smaller chucks to compress.

Let us know if this helps,

John Hawk

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi John,

Thanks for the prompt reply

Collapse is not with zero Elimination.Its running more than two days and not getting completed for just 7 million records.

Note:we have reloaded the data from base staging dso based on fiscal year period.

Thank you.

Regards,

Giridharan R

0