aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

ORA-33072: (XSAGDNGL35) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must be specified for every relation dimensioned by that hierarchy dimension.

ORA-33072: (XSAGDNGL35) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must be specified for every relation dimensioned by that hierarchy dimension.
Cause: Multiple dimensions share the same hierarchy dimension, but it is only qualified within a subset of the AGGMAP relations.
Action: Adjust the AGGMAP so that it uses consistent qualified data references.

请先 登录 后评论

1 个回答

小智
ORA-33072:(XSAGDNGL35)在AGGMAP 工作区对象,在维度层次结构维度的QDR 工作区对象必须由层次结构维度的尺寸每一种关系来指定。,
.原因:多个维度具有相同的层次结构维度,但它只在AGGMAP关系的子集中限定。,
.操作:调整AGGMAP,以使其使用一致的限定数据引用。,
.
请先 登录 后评论