ORA-18509
The join attributes (string) in the REFERENCES clause and the leaf level of every hierarchy are not determined by a non-null level of the analytic view dimension "string"
Cause
There must be a non-null level that determines all the attributes in the join condition and the lowest level of each hierarchy.
Action
Ensure that there is a non-null level that determines all the attributes in the join condition and the lowest level of each hierarchy or change the join relatinship to MANY TO ONE.