OBIEE - Implicit Fact Column

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - BI Server (OBIS|nqsserver|nqs)

1 - 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.

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

Advertising

3 - Multiple path

3.1 - 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

3.2 - Multiple dimension path

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

4 - Documentation / Reference