BO 5.1 Universe Designer Join display error??
I am looking at a Universe that was created in BO 5.1 Designer and one of the joins in the Universe looks different than the rest and not sure if it signifies anything specific.
1. All other joins are depicted next to the column on which it join in the Fact table but this one join actually points to the table header/name and not any specific column.
When I right click on this join and select properties:
Now the Expression section gives one column from the fact table joined to one column from the header table.Whereas if we look at the top then multiple columns in the Fact table are selected(shaded blue) which usually depicts that they are used on the join condition.
Can anyone explain what is happening here?is it a bug or is it actually conveying some information?
Mark Prosser replied
It's likely that the PREV_OCCUP_ID column in your #####_DETAIL table has changed (including being dropped and re-added) since the join was created; Designer acknowledges that there was a join but doesn't know how to visually represent it. Find the column again in your column list on the left and it should be fine.