Oracle Error Message
QSM-01101: rollup(s) took place on mv, string
Reason for the Error
If query’s GROUP BY has one of the higher levels of columns found in the materialized view, then the lower level columns in the materialized view will be rolled up to compute the desired results.
Solution
None