Aggregates for Full Load Everday.

[Former Member]

I've an infocube with full load from ODS with around 5million records. I've created an aggregate (using Propose by Query) on this infocube. This cube gets full load everynight. What is the best way to fill that one aggregate I created after the full load. I know that we can do this manually by (Activate and Fill) in Manage Aggregates screen. But can this be automated and included in a process chain. I tried the process type 'Initial Fill of New Aggregates', but seems it didn't work. Can someone please me the steps to fill this aggregate(like do I need delete indices, etc,.) automatically in a process chain.

[Former Member · Accepted solution]

Hi ,

yes,use abap program process type

cheers,

Swapna.G

[Former Member]

Hi ,

you can use below programs to automate the process

The programs are:

SAP_AGGREGATES_DEACTIVATE: deactivate the aggregates of an infoCube

SAP_AGGREGATES_ACTIVATE_FILL: activate and fill the aggregates of an infoCube.

cheers,

Swapna.G

[Former Member]

Swapna,

Can I automate these jobs to run thru Process Chain? How do I do it?

[Former Member]

Hi ,

once an aggregte bulit on any infocube,we will fill the data into aggregate which is ONETIME

afterwards we will rollup the subsequent data into info cube

you can automate this rollup part of process chain

cheers,

Swapna.G

[Former Member]

Swapna,

But we are doing full load everyday(delete the content of the cube, and load data again from ODS). Rollup option might not work here.