I have a dimension table:
Now, in AS Vendor dimension, I drag and drop "AgentName" attribute from tblAgent. This works fine. However, what AS does now, is that it basicly tries to inner join these two tables. So if there is no Agent for Vendor, it doesn't load that Vendor at all.
How can I force it to conver such to unknown?
View Complete Post