ORA-37543: Hierarchy member DIMENSION_MEMBER is inconsistent across HIERARCHY1 and HIERARCHY2.

ORA-37543: Hierarchy member DIMENSION_MEMBER is inconsistent across HIERARCHY1 and HIERARCHY2.
Cause: Two hierarchies are inconsistent when members that appear in both hierarchies have different ultimate leaves.
Action: This problem is usually resolved by defining a new dimension member for the secondary hierarchy, or fixing the hierarchy table so that the definitions of the member match across hierarchies.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:51

ORA-37543：层次结构成员DIMENSION_MEMBER在HIERARCHY1和HIERARCHY2之间不一致。,
.原因：当两个层次结构中显示的成员具有不同的最终叶时，两个层次结构不一致。,
.操作：通常通过为辅助层次结构定义新的维成员或修复层次结构表，以便成员的定义在层次结构中匹配，来解决此问题。,
.

aiaiDBA

13718043309

010-86462881

ORA-37543: Hierarchy member DIMENSION_MEMBER is inconsistent across HIERARCHY1 and HIERARCHY2.

1 个回答

相似问题