Creating aggregates in production !!!
Hi,
I have a quick question regarding aggregates. Can I create and fill data in production without affecting the original cube. how about the performance. if some users are running queries out of that cube is it going to affect them..
thanks a lot. I will award points for the answers.
AC..
Edwin Harpino replied
hi AC,
as mentioned by Riccardo, suggested fill aggregate when
no users access report from that cube.
also take a look thread
mentioned program (by Ali) may useful
SAP_AGGREGATES_DEACTIVATE: deactivate the aggregates of an infoCube
SAP_AGGREGATES_ACTIVATE_FILL: activate and fill the aggregates of an infoCube
hope this helps.