Oracle Error QSM-01077: materialized view, string, is grouping at a higher level than query

Oracle Error Message

QSM-01077: materialized view, string, is grouping at a higher level than query

Reason for the Error

If a query column, which is not present in the materialized view, can be obtained by a rollup within the materialized view, then it should group at a higher level than the materialized view.

Solution

None