In this post, you’ll learn more about the Oracle ErrorORA-30371: column cannot define a level in more than one dimension with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-30371: column cannot define a level in more than one dimension
Reason for the Error ORA-30371: column cannot define a level in more than one dimension
A column was used in the definition of a level after it had already been used to define a level in a different dimension.
How to fix the Error ORA-30371: column cannot define a level in more than one dimension ?
You can fix this error in Oracle by following the below steps
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.