QSM-02022
aggregate selections
Cause
The capability in question is not supported when the materialized view uses an aggregate expression in the HAVING clause.
Action
Re-phrase the query to avoid the use of an aggregate in the HAVING clause.