Skip to Content
0
Former Member
Oct 24, 2005 at 06:28 PM

Aggregate Compression - how many requests to keep uncompressed

23 Views

I'm creating a new aggregate for one of my InfoCubes and I am filling it right now. I'm working on adding the rollup operation to my process chain and I notice that by default, the rollup operation will compress the requests in the aggregate, and you can specify a certain number of requests in the aggregate that you want to leave uncompressed in case they need to be backed out.

What is a standard/good practice for how many requests you should leave uncompressed in the aggregate for a daily delta load? Is a week's worth a good number? A month?

For that matter, should this number match how many requests you leave uncompressed in the InfoCube as well?

I want to be careful about this as I see the documentation says that if you need to back out a compressed request from an aggregate you have to empty and refill the aggregate all over again.

Thanks,

Chris