BIchick

 Profile Answers by BIchick 

• Feb 5th, 2010

 

There is not such term as "flat aggregation". However, there are something called "flat dimension" - dimension that has no hierarchies. I would think that when you aggregate across flat dimension you will be doing flat aggregation?

JAGADISH RAJU

• Sep 14th, 2011

 

if you create an Aggregate with more than 16 characteristics, then we call that aggregate as FLAT Aggregate. When an aggregate is active then new data is not available for reporting,These aggregates are called Flat Aggregates.

kishore

• Nov 25th, 2013

 

If we create an aggregate on a dimension which has less than or equal to 16 characteristics, then it is act as a line item dimension, This type of aggregates are called flat aggregates.
my personal recommendation is to create line items where ever and when ever possible! If you have less than 13 characteristics in your cube, put each characteristic in one dimension and define it as line item