OBIEE - [39008] Logical dimension table does not join to any fact source

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

1 - About

When you perform a consistent check, you can get this business model warning:

[39008] Logical dimension table MyDimension has a source MyDimensionSource that does not join to any fact source.

This problem can occurs when a fact table (such as a stock table) is only valid for a defined aggregation grain. You then end up with logical table sources that all have an aggregation level content defined. In such case, you must also define the remaining dimension that makes the aggregation grain to the detailed level.

3 - Solution

Remember that a logical join occurs between a fact logical table and a dimension logical table on the same aggregation grain.

Define the aggregation grain (logical level) on the logical table source:

  • of the dimension (to the detailed level for instance)
  • and also in the fact
Advertising