OBIEE - Implicit Fact Column

Bi Server Architecture With Client

About

You can find this functionality in the general property of a subject area in the repository.

The goal of this definition is to guide the BI Server to make the best choice between two possibles query path:

  • for a logical fact table: Multiple fact path
  • for a logical dimension: Multiple dimension path

To guide OBIEE in the best choice, you need to select a fact attribute (measure) as an implicit fact column.

Obiee Implicit Fact Column

The implicit fact column is used for queries that only select dimension attributes (no facts) from two or more dimensions.

Multiple path

Multiple fact path

(ie as BI Server uses the star schema data model between two fact tables) Multiple fact path occurs when you choose two attributes of dimensions that links together to two fact tables.

For instance, this case can occurs when:

  • you create a dashboard prompt when the values of a column constraints an other.
  • you want to make analysis between dimension (and then without measures)
  • you want to see the constraint result of a filter

Multiple dimension path

Multiple dimension path occurs for a report with only one dimension attribute and multiple possible logical table source.

Documentation / Reference





Discover More
Obiee Dense Analytics By Members
OBIEE - Densification / Dimensions Preservation Possibilities

You may want to view the data in dense form, with rows for all combination of dimension values displayed even when no fact data exist for them. A MOLAP environment give you automatically this feature...
Obiee Fact Cross Join
OBIEE - Densification with the fact-based fragmentation capabilities

You may want to view the data in dense form, with rows for all combination of dimension values displayed even when no fact data exist for them. The preservation of the dimensions is is also well known...



Share this page:
Follow us:
Task Runner