ORA-37136: (XSCCOMP11) Cannot ROLLUP dimension workspace object which is a base of COMPRESSED COMPOSITE workspace object, use AGGREGATE instead.

ORA-37136: (XSCCOMP11) Cannot ROLLUP dimension workspace object which is a base of COMPRESSED COMPOSITE workspace object, use AGGREGATE instead.
Cause: The user ran ROLLUP on a variable dimensioned by a COMPRESSED COMPOSITE.
Action: Instead of using ROLLUP, generate an aggmap and use AGGREGATE

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:51

ORA-37136：（XSCCOMP11）无法ROLLUP作为COMPRESSED COMPOSITE工作空间对象基础的维度工作区对象，请改用AGGREGATE。,
.原因：用户对由COMPRESSED COMPOSITE确定的变量运行ROLLUP。,
.操作：而不是使用ROLLUP，生成aggmap并使用AGGREGATE,
.

aiaiDBA

13718043309

010-86462881

ORA-37136: (XSCCOMP11) Cannot ROLLUP dimension workspace object which is a base of COMPRESSED COMPOSITE workspace object, use AGGREGATE instead.

1 个回答

相似问题