This content is now out of date.

Visit Our Community

Multiple Facts connected to the same dim


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-

Forum 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,