ORA-18515
AGGREGATE INTO cannot be specified on the analytic view dimension "dimension_name" that is based on a fact table with a distinct join.
- dimension_name: The name of the analytic view dimension.
Cause
An analytic view dimension cannot be based on a fact table with a distinct join and have an AGGREGATE INTO clause.
Action
Remove the AGGREGATE INTO clause from the fact-based dimension.