ERROR | detail query cannot be derived |
CAUSE | If an ORANIZATION CUBE MV is to automatically derive its loading clause, then its definition query cannot contain set operators (eg UNION ALL), a HAVING clause, START WITH or a SQL MODEL clause. The definition query contains these or other unsupported syntax. |
ACTION | Use an explicit ORGANIZATION CUBE clause, or simplify the defining query. |