Skip to Content
0
Former Member
May 23, 2007 at 08:32 PM

Using Aggregate and Compression - Steps

32 Views

I like to use aggregate in our BW 3.5 system to make reports run faster. Could someone with experience please validate if following steps are correct:

a) Build aggregate

b) Allow roll up for the cube

c) Fill up/activate aggregate

d) Compress cube data

Now the question is, is that good enough to get full advantage of newly built aggregate and compression? Or are there other steps I need to execute to get the real benefit of aggregate and compression?

I have close to 2 million rows in the cube.

Any advise will be appreciated.