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

Aggregate - Roll up

Hi experts,

I have to perform the first roll up on an InfoCube with 100.000.000 records on the F+Etable.

How can I determine the average time of the first aggregate loading?

I need to be sure that this operation ends before the next process chain loading ( scheduled daily) and the amount of data in quality environment is not reliable.

thanks in advance

best regards

Filippo Corvi

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Jan 11, 2007 at 06:01 AM

    Filippo,

    The operation would be comparable to loading data and compressing the same - it would be a function of :

    1. Availability of work processes

    2. CPU size

    3. Memory available

    4. Heap memory available

    5. Load on the system

    For instance to roll up about 25 Million records into an aggregate for a cube it took us about 2 hours - with users hitting the system for queries... also the aggregate rollup is done in blocks and hence your process chains will not affect the same and if any other dialog process comes inbetween then the aggregate rollup is temporarily halted at the current block and then continued after the process is complete..

    Arun

    Assign points if useful

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 07:46 PM

    Hi Filippo,

    One option would be to embed the aggregate rollup into the process chain and have the next load or process chain triggered by the successful completion of the aggregate rollup.

    Getting a time estimate would be difficult because it depends not only on the number of records but the physical setup of the servers.

    Regards,

    Adam

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2007 at 10:35 PM

    Hi Filippo Corvi,

    It is very difficult to measure exact time to fill aggregate. As the aggregate fill will not only considers number of records to be aggregated but also the aggregation level .

    Best Regards,

    Ramesh

    Add a comment
    10|10000 characters needed characters exceeded

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.