ORA-18452
unable to retrieve materialized view SQL for dimension "string" because the cache star type is not MATERIALIZED
Cause
An attempt was made to retrieve materialized view SQL for a non-MATERIALIZED dimension.
Action
Alter the dimension so that the cache star type is MATERIALIZED or select a dimension with a MATERIALIZED cache star type.