I have a fact table with field ItemNo.
This links to Item dimension.
Sometimes, this field is empty. I have enabled CovertToUnknown for this measure group and KeyNotFound. This puts such entries under Unknown Item.
All that is good.
However, now I want to add another dimension link. Dimension Responsible is linked to fact table through reference dimension Item. Fact -> Item -> Responsible.
However, as soon as I do this, AS does an inner join to table Item when loading fact table. And as such, it does not pick up any records where ItemNo is empty.
Why does it do that and how do I keep ConvertToUnknown working?
View Complete Post