What happens technically in the Rollup

[Former Member]

Hello Experts,

I know that rollup is required to update data in the aggregates. But I wanted to know what happens technically when a rollup runs. And how it adjusts the data in the aggregates.

I wil be glad to know this information.

Points wil be awarded.

thanks

Bulli

[Former Member · Accepted solution]

Hi Bulli,

Welcome to SDN )

Lets say that you have aggregates on your cube and all requests have been rolled up as of now. Lets say the latest request is 34567...All data is available for reporting now upto request 34567.

Say you loaded your InfoCube again 4 times. These 4 requests are NOT available for reporting if they are not rolled up, even if the query uses aggregate OR NOT. So, if you run a query you will only get data upto request 34567, which was the last rolled up request.

So, if you have aggregates, its a best practice to rollup into the aggregates at the earliest for your reports to show latest data.

check this help document also,

http://help.sap.com/saphelp_nw04/helpdata/en/9a/33853bbc188f2be10000000a114084/frameset.htm

assign points if this helps,

Thanks,

Sudhakar

[dielom]

Hi Bulli,

The rollup process copies information from the cube to the aggregate. Then, you get a new cube with summarized information.

Supose you have a cube with 2 characteristics and a KF:

CH1 CH2 KF

AA BB 10

AA CC 10

if you make an aggregate with CH1 and KF, then you will get this:

CH1 KF

AA 20

It's like if you load data from an infoprovider to another with less characteristics and using addition for the KF.

Hope this helps.

Regards,

Diego

[Former Member]

HI Deigo,

thanks for the reply. but this is general process of the aggregation behaviour. But I wanted to know the exact process technically what happens when we performs the rollup.

thanks

Bulli