ORA-30341: dropped level has references Cause: An attempt was madeto 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 anyreferenes to the level prior to dropping it, or specify the
CASCADE option with the DROP LEVEL clause.