Oracle Error Message
ORA-30341: dropped level has references
Reason for the Error
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.
Solution
First remove any referenes to the level prior to dropping it, or specify the CASCADE option with the DROP LEVEL clause.