Hi guys,
I have 2 dimensions. CC and employee which join to fact F1.
I have combined CC and Employee on a common column being "code" in a database view via a 1:1 relationship (inner join).
When i filter on CC->item1 and F1 , I get the correct result
When i filter on the combined Employee/CC->item1 and F1 , i get a different result
Does anyone know what i need to be doing for them to display the same result? Am i joining incorrectly?
Thx for any tips
Check your database view. The view column that is used for joining with the fact should still have unique values. In other words, when the view generates 1000 rows, then the join column should yield 1000 distinct values.
Are you also sure that combining the two dimensional objects through an inner join does not result in data-loss?
Also, do not make the mistake of thinking an inner join translates to 1:1 cardinality, it only precludes either end from being 0