Oracle Solution for Error ora-30341

ORA-30341: dropped level has references

What triggered 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.

What should we do to fix it:

First remove any referenes to the level prior to dropping it, or specify the CASCADE option with the DROP LEVEL clause.