This content has been marked as final. Show 3 replies
Try to set the implicit fact column mapping for the Subject area and try, that should help.1 person found this helpful
If helps mark :)
Your dimensions in the logical layer must be joined by multiple paths. This can end up generating a query using a fact table that does not have right data. If you set implicit fact for the subject area, this problem should be resolved.
FYI, also look at session log for the exact query fired by BI.