None of the fact tables are compatible with the query request

[Deleted User] · Aug 10, 2017 1:12PM

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 · Aug 10, 2017 4:03PM

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 · Aug 10, 2017 5:14PM

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

Community DW Integration · Aug 10, 2017 5:15PM

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

Oracle Analytics Cloud and Server

Categories

None of the fact tables are compatible with the query request

Answers