aiaiDBA

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

13718043309

010-86462881

XOQ-02520: The mapped dimension in the cube dimensionality map of a query-rewrite-enabled cube materialized view must be the lowest hierarchy level on all hierarchies in the dimension.

XOQ-02520: The mapped dimension in the cube dimensionality map of a query-rewrite-enabled cube materialized view must be the lowest hierarchy level on all hierarchies in the dimension.
Cause: "The mapped dimension in the cube dimensionality map of a query-rewrite-enabled cube materialized view was not the lowest hierarchy level on a hierarchy in the dimension."
Action: "Change the mapped dimension in the cube dimensionality map of a query-rewrite-enabled cube materialized view to a hierarchy level or a dimension level that is the lowest hierarchy level on all hierarchies in the dimension."

请先 登录 后评论

1 个回答

小智
XOQ-02520:启用查询重写的多维数据集实体化视图的立方体维度图中的映射维度必须是维度中所有层次结构的最低层级。,
.原因: “支持查询重写的多维数据集实体化视图的立方体维度图中的映射维度不是维度中层次结构上最低的层次结构级别。,
.操作: “将启用查询重写的多维数据集实体化视图的多维数据集维度图中的映射维度更改为维度中所有层次结构上层次结构级别或维度级别。,
.
请先 登录 后评论