ORA-37541: Hierarchy element DIMENSION_MEMBER can aggregate into element MEMBER_ANCESTOR through multiple paths.

ORA-37541: Hierarchy element DIMENSION_MEMBER can aggregate into element MEMBER_ANCESTOR through multiple paths.
Cause: When a low level hierarchy element can reach an aggregate element by more than one path through the hierarchy, it is said to have multiple paths. The danger is that the value of the low level hierarchy element will have its value counted multiple times (once per path) in the total of the aggregate element.
Action: Eliminate multiple paths from the hierarchy.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:51

ORA-37541：层次结构元素DIMENSION_MEMBER可以通过多个路径聚合成元素MEMBER_ANCESTOR。,
.原因：当低级别层次结构元素可以通过层次结构中的多个路径到达聚合元素时，称为具有多个路径。危险在于，低级层次元素的值将在聚合元素的总计中具有被计数多次（每个路径一次）的值。,
.操作：从层次结构中消除多个路径。,
.

aiaiDBA

13718043309

010-86462881

ORA-37541: Hierarchy element DIMENSION_MEMBER can aggregate into element MEMBER_ANCESTOR through multiple paths.

1 个回答

相似问题