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.