Database Error Messages

ORA-30371

column cannot define a level in more than one dimension

Cause

A column was used in the definition of a level after it had already been used to define a level in a different dimension.


Action

Reorganize dimension levels and hierarchies into a single dimension such that no column is used to define levels in different dimensions. There is no limit on the number of levels or hierarchies you can place in a dimension. A column can be used to define any number of levels provided all such levels are in the same dimension and provided no two levels contain identical sets of columns.