Hello!
I am advancing in my studies to evaluate whether we will use the Oracle Sql Developer Data Modeler tool.
I found an Oracle documentation, instructing the Generation of the multi-dimensional model.
For educational purposes, this documentation asks us to import the sql file: sh_cre_all.sql. By carrying out the entire documentation process, I am able to achieve the expected result, of having a multidimensional model, with the cube, dimensions and levels.
However, when I manually create a similar relational model, with the same context. When generating the Multidimensional model, using the button: "Engineer From Oracle Model". The cube is not generated.
What do I generate in the relational or logical model to make this happen?