Skip to Content
author's profile photo Former Member
Former Member

What happens technically in the Rollup

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.



Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 12, 2007 at 01:53 PM

    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,

    assign points if this helps,



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 12, 2007 at 01:34 PM

    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.



    Add a comment
    10|10000 characters needed characters exceeded

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



Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.