aiaiDBA

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

13718043309

010-86462881

ORA-33042: (XSAGDNGL20) In AGGMAP workspace object, VALUESET workspace object must qualify all relations dimensioned by workspace object.

ORA-33042: (XSAGDNGL20) In AGGMAP workspace object, VALUESET workspace object must qualify all relations dimensioned by workspace object.
Cause: A VALUESET over a hierarchy dimension qualifies some RELATIONs but not all RELATIONs dimensioned by the same hierarchy dimension.
Action: Use the same VALUESET to qualify all the RELATIONs dimensioned by the same hierarchy dimension.

请先 登录 后评论

1 个回答

小智
ORA-33042:(XSAGDNGL20)在AGGMAP工作空间对象中,VALUESET工作空间对象必须限定由工作空间对象确定的所有关系。,
.原因:层次结构维上的VALUESET限定一些RELATION,但不限制由同一层次结构维度确定的所有RELATION。,
.操作:使用相同的VALUESET来限定由同一层次结构维度确定的所有RELATION。,
.
请先 登录 后评论