ORA-37545: DIMENSION_MEMBER is part of a hierarchy loop.

ORA-37545: DIMENSION_MEMBER is part of a hierarchy loop.
Cause: A hierarchy has loops when the ancestor of a dimension member uses that member as its parent. Note that some loops are created across hierarchies. For example, in hierarchy 1, dimension member A is the parent of B, B is the parent of C and in hierarchy 2, C is that parent of A forms a hierarchy loop.
Action: Change the hierarchies so that the loop is eliminated or move the problem hierarchy to a different dimension.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:51

ORA-37545：DIMENSION_MEMBER是层次结构循环的一部分。,
.原因：当维成员的祖先使用该成员作为其父成员时，层次结构具有循环。请注意，在层次结构中创建一些循环。例如，在层次1中，维度成员A是B的父体，B是C的父体，并且在层次2中，C是A的父体形成层次结构循环。,
.操作：更改层次结构，以便消除循环或将问题层次结构移动到其他维度。,
.

aiaiDBA

13718043309

010-86462881

ORA-37545: DIMENSION_MEMBER is part of a hierarchy loop.

1 个回答

相似问题