ORA-18504
invalid measure in filter fact clause
Cause
A base measure that was built over an expression that was not a single column was used in the filter fact clause of the derived analytic view.
Action
Ensure that the base measures used in the derived analytic view filter fact clause have a single column expression.