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

Bi Server Architecture With Client

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.

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





Discover More
Bi Server Architecture With Client
OBIEE 10G/11G - Administration Tool (admintool, datamodel)

admintool.exe is the Administration tool to manage OBIEE server and have some capabilities to automate some repetitive tasks and principally his embedded tools. Oracle Business Intelligence Administration...



Share this page:
Follow us:
Task Runner