Creating aggregates in production !!!

[Former Member]

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..

[Former Member · Accepted solution]

Hi all,

Thanks for the replies. If i understood correclty, so basically when i create the aggregate it does not lock the basic cube . it is till reportable ?? right..

[edwin_harpino · Accepted solution]

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.

[Former Member]

thank you ,Riccardo A.H.P.

[edwin_harpino]

hi AC,

to maintain aggregate directly in production,

first you have to allow this in prod,

rsa1->transport connection->object changeability,

choose object type aggregate, switch to changeable.

query will fetch data from basic cube if aggregate not built yet. the rollup process may take time, depend on

volume data in your basic cube and characteristic used

in aggregate.

hope this helps.

[Former Member]

Hi AC,

Yes you can create aggregate directly in PRD, but you will have a reduction of performance during the roll-u activity, it is strongly reccomended to execute this operation when users are not connected.

Ciao.

Riccardo.