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.
Articles Related
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: