Skip to Content

BW cube Compression is running long time

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 11, 2017 at 09:08 PM

    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

    Add comment
    10|10000 characters needed 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