Oracle Error Message
ORA-30371: column cannot define a level in more than one dimension
Reason for the Error
A column was used in the definition of a level after it had already been used to define a level in a different dimension.
Solution
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.