Monday, 21 May 2012

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

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.

No comments:

Post a Comment