We're trying to build a view that has multiple Fact tables connected to the same time dim.
Right now the result set returns incorrect numbers when using measures from different facts.
Is there a way to solve this and allow multiple fact on one View?
attached is an example image-
Another question- is it possible to connect the same shared dims with different fact?
It is urgent for us, and will be happy if you could reply as soon as you can.
Thanks in advance,