ORA-30341: dropped level has references
Cause: An attempt was made to drop a level using the default or RESTRICT option in a dimension while references to that level remain in the dimension. References can occur in hierarchies and attributes within the dimension
Action: First remove any referenes to the level prior to dropping it, or specify the CASCADE option with the DROP LEVEL clause
https://support.oracle.com/
http://www.oracle.com/