i want to compress a cube which have 40 mil records in it and in some aggregates it is close to 15 to 20 mil records. we cannot compress aggregates in BWP cause of a sap bug. Now my questions are
1. Before compressing the cube i should deactivate all the aggregates so i dont have to wait to rebuilt the aggregates after compressing some request it will take more time. and also i dont have to worry about to full the logs cause of data granularity.
2.we have a infosource 0ec_pca_1 which is period Zero and this infosource is full update. our business people make some changes in the prior year and carried the 0balance forward from year to year. if i will update this infosource it will double the records in the cube after compression. so i am thinking about to delete this request before compression and update it from PSA after compression in BWP. please advise
thanks in advance