Oracle Error Message
QSM-01034: materialized view, string, needs a dimension level to join table, string
Reason for the Error
One or more hierarchical relationship(s) in the table(s) could not be established.
Solution
Consider adding a level in the dimension to provide the missing intra- table relationships.