Hello my friends, thanks for the time reading and hopefully anwsering my question:
All the joins are well connected on my physical side, as well as in my business model and mapping. My fact table has all its connections to the respective dimensions and its foreign keys. That being said, on the business layer, should every logical dimension linked to the fact have a logical level defined in the fact's content? And if so, should it always be the last child/part of the hierarchy such as the "Detail"?
For example, this particular logical dimension that I highlighted won't be able to show results in Oracle Analytics because it doesn't have a link and would return an error:
"State: HY000. Code: 14020. [nQSError: 14020] None of the fact tables are compatible with the query request."
:
The reason I ask this is nothing else but to be sure of what I'm doing. I was navigating through old repositories in the company I work for, and I found a fact table perfectly working on the presentation/analytics side but with all the logical levels unchecked like the one on the screenshot, which confused me.
