The relation between the fact table and the dimention table should be fact table(many) and dimention table(one). I have it the other way around. We'll have to think of some...
I have a cube that is giving incorrect values via excel. With a sum and group-by query it gives me the right answers. The relations in the cube editor...