Oracle Error Message
QSM-01082: Joining materialized view, string, with table, string, not possible
Reason for the Error
A column in the query is not found in the summary. To obtain the column, a join back of materialized view to the table by means of either the primary key, foreign key or rowid of the table is required. The specified materialized view does not have the primary key, foreign key or rowid of the table to perform the join operation.
Solution
Consider building a dimension-table to provide the missing information.
