None of the fact tables are compatible with the query request

[Deleted User]

So as I said you need to completely remodel it. Starting with drawing the model you want on a sheet of paper with actual names that make sense.

Thomas Dodds

I had begun to write this up the other day ... then realized I was attempting to remodel the whole thing in a forum post ... unfortunately @skull, it's what you are going to have to do  ... boil the physical transaction snowflake into ONE OR MORE logical fact stars (preferably with conformed dimensions).

Community DW Integration

Thanks @Christian Berg I will give it a try and let you know.

Community DW Integration

Thanks @Thomas Dodds I will give it a try and let you know.