Forum Discussion
Measure with duplicates
I have one table A1 B1 A1 B2 and a child table B1 178XX B2 178XX and a fact table 178XX 5 As a result I get in pivot table (this is SSAS, but ok): A1 5 B1 5 B2 5 but th...
Kazu
Helper II
Helper IITable 3 looks like a dimension because of 1:n relationship to Table 2. At the same time it looks like a fact because you have "amount" there and you are calculating SUM.
I guess your real fact table should be either Table 1 or Table 2 and you need to add some measures there. But since everything is dummy, nobody would be able to provide any suggestions. Giving proper name to 1, 2, 3 and A, B, R would make the troubleshooting easier.