Check box “data is dense”
Cache persistence
January 13, 2009The following Expression always return 0.00% in a custom OBI EE Repor
January 21, 2009When viewing the properties of a fact column in OBIEE, there is a check box “data is dense” when aggregating by dimension is chosen. What does this check box do? I’m not sure if this only applies to multi-dimensional sources or not.
Solution
This is generally used for FIRST/LAST aggregation rules where data is dense across the time dimension, e.g. inventory values for every period. SQL generation is optimized in this case.
