Flat Aggregate

[Former Member]

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

[former_member182470 · Accepted solution]

Hi,

Check these:----

---

Regards,

Suman

[Former Member]

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.

[MartinMaruskin]

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.

[Former Member]

Hi,

Refer the following link.

[;

Regards,

Durgesh.