Writen by
Devil
7:11 PM
-
0
Comments
OBIEE - [39008] Logical dimension table does not join to any fact source
[39008] Logical dimension table MyDimension has a source MyDimensionSource that does not join to any fact source.
This Error can occurs when a fact 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 for the Problem
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 in below Places:
- of the dimension (to the detailed level for instance)
- and also in the fact
No comments
Post a Comment