Oracle Error Codes

dropped level has references

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.

How to Solve :

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