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

标题: ORA-37541: Hierarchy element DIMENSION_MEMBER can aggregate into element [打印本页]

作者: michaeljet 时间: 2016-9-7 10:44
标题: ORA-37541: Hierarchy element DIMENSION_MEMBER can aggregate into element

ORA-37541: Hierarchy element DIMENSION_MEMBERcan aggregate into element

MEMBER_ANCESTOR through multiple paths.

Cause: When a low level hierarchyelement can reach an aggregate element by

more than one path through the hierarchy, it is said tohave multiple paths. The

danger is that the value of the low level hierarchyelement will have its value

counted multiple times (once per path) in the total ofthe aggregate element.

Action: Eliminate multiple paths fromthe hierarchy.

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