OBIEE - What means Data is dense ?

Bi Server Architecture With Client

About

When setting up a aggregate rules for a measure column, you can specify that data is dense only if all the logical table sources to which it is mapped are dense.

In a logical column if you check “Based on Dimension” (aggregating by dimension is chosen), you will have the option Data is dense.

Obiee Data Is Dense

What it means in general ? : Dimensional Data Modeling - What means Data is dense/sparse ?

What it means in OBIEE ?

By default, data is considered sparse. However, on rare occasions you might have logical table source with dense data.

A logical table source is considered to have dense data if it has row for every combination of its associated dimension levels.

When setting up a aggregate rules for a measure column, you can specify that data is dense only if all the logical table sources to which it is mapped are dense.

Specifying data is dense when any table source that is used by this column does not contain dense data will return incorrect results

This is used for FIRST/LAST aggregation rules (of generally for SQL Function - Window Aggregate (Analytics function)) where data is dense across the time dimension, e.g. inventory values for every period. SQL generation is optimized in this case.

Specifying data is dense when any table source that is used by this column does not contain dense data will return incorrect results.





Discover More
Star Schema
Dimensional Data Modeling - What means Data is dense/sparse ?

Sparse and dense are a storage property of the values of an attribute. Data is normally stored in sparse form. If no event has happened, there is no data stored. In dimensional modeling, if...
Obiee Data Is Dense
OBIEE - Repository Aggregation rules based on dimension (dimension-specific aggregate)

Obiee offer the possibility to have differents measure aggregation rule based on the dimension. This functionality is really tied to the last and first function (in order to define its grain ?) ...
Obiee Measure Column
OBIEE 10G/11G - Measures (Columns|Attributes)

A measure column is a logical column with an aggregate function. Any column with an aggregation rule is a measure. Examples include Revenue or Units Sold. Measures need to be defined in a logical fact....



Share this page:
Follow us:
Task Runner