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

Flat Aggregate

dear all,

When i am going through the flat aggregates concept in

TBW42-1(BI - Advanced Enterprise Data

Warehousing & Reporting (Part 1))

I am not getting clearly regarding the below issue..

Performance issues:

– “-->Flat Aggregates” are filled/rolled up without loading the data on the

application server (just movement of data on database)

can any one explain this issue in detail.

Thanks in advance,

Regards,

Lokesh

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Jul 13, 2011 at 08:53 AM

    Hi,

    Check these:----


    Flat Aggregate

    FLAT AGGREGATES

    Regards,

    Suman

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 13, 2011 at 08:01 AM

    Hi,

    Refer the following link.

    [;

    Regards,

    Durgesh.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 13, 2011 at 08:09 AM

    Flat aggregate means that in fact table there are directly stored master data IDs (SIDs). There is no separate dimension between fact table and MD as it self.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 14, 2011 at 10:53 AM

    if an aggregate is created on a infocube whichhas a line item dimension then that aggregate is called as flat aggregate , that is when you create an aggregate on a charecteristic which is only one in a dimension of an infocube.

    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.