Oracle Error QSM-01048: join back level(s) not present (string)

Oracle Error Message

QSM-01048: join back level(s) not present (string)

Reason for the Error

Query Rewrite requires joining back to a level of a dimension to find a missing information.

Solution

Consider creating a dimension.