compression frequency

[Former Member]

Hello All,

I wanna know the compression frequency that is the rate at which we should compress the data for various kinds of loads to improve the performance..

Can anyone provide ne document which suggests the compression frequency..

Thanks

[stevenm_wilson]

The only thing you need to account for is what you want your system to concentrate on, loading performance or query performance. For anything in which you are not "editing" data in a infocube, for instance deleting requests, you should compress as much as possible.

The only document on Compression I know about is for the 0IC_C03 inventory scenerio. In this scenerio, Compression is key to updating inventory markers and increasing query performance.

Hope this helps!

/smw

Message was edited by: Steve Wilson

[Former Member]

Thanks Raj,

This ofcourse depends on the business requirement as in whenever it is decided that data is clean and need not be modified or deleted after this point of time ,we can go for compression .

But is there any document which says that if following SD/MM/INV/FI cube is loaded say daily or weekly or monthly then it should be compressed at say daily weekly or monthly basis...

Regards

[Former Member]

Hi,

Again, there is no specific document that says, for so many records the compression frequency should be so much...

It depends on how much data you have in the cube, how frequently you load the cube, what is the data volume, what is the growth rate. We have a huge amount of data that is growing, so we compress the cubes weekly. Also you need to determine the number of days after which the requests can be compressed. Typically you would set the number to all requests older than 30 days.

But you need to be careful in the sense that :

a. You can't back out a request that's compressed.

b. If you are using Infospokes with delta mechanism, and if that runs against the cube requests that are compressed, then it won't be able to extract the data. In such cases you can think of compressing requests older than 60 or 90 days.

c. Be careful about compressing cubes that have cumulative and non-cumulative key figs (esp Inventory).

Cheers,

Kedar

[Former Member]

Dear Vishu,

Compression frequency purely depends on the business scenario. This means, if your business requirement doesnt need any data maintenance, then that data can be compressed, but if there is a possibility that a set of data may need maintenance, then , compression should not be done. So, this is based on the business need.

Thanks,

Raj