ORA-30341

Error: ORA-30341: dropped level has references

Causa: 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.

Acción: First remove any references to the level prior to dropping it, or specify the CASCADE option with the DROP LEVEL clause.