Oracle Solution for Error ora-30371

ORA-30371: column cannot define a level in more than one dimension

What triggered 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.

What should we do to fix it:

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.