重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛

标题: ORA-37542: DIMENSION_MEMBER makes hierarchy HIERARCHY1 unbalanced. [打印本页]

作者: michaeljet 时间: 2016-9-7 10:45
标题: ORA-37542: DIMENSION_MEMBER makes hierarchy HIERARCHY1 unbalanced.

Cause: A hierarchy is balanced if: 1)All members of a level are at the same depth

from the root of the hierarchy and 2) All the members indifferent levels are at

different depths from the root of the hierarchy.

Action: Fix the hierarchy so that itis balanced. This is often done by looking for

nulls in the middle levels of a hierarchy.

欢迎光临重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)