XOQ-00703: Error executing OLAP DML command "(GROUPINGID PRODUCT_PARENTREL

来源:互联网 发布:无人深空优化 编辑:程序博客网 时间:2024/04/29 12:54
If a user creates a dimension with N levels and M attributes where N * M >
   31, and if the user selects "Create level attribute columns in views" in AWM
  for each of those attributes, then the server will incorrectly calculate
attribute GROUPING IDs for those levels. This can lead in some cases to the
   following type of error during dimension build.

   XOQ-00703: Error executing OLAP DML command "(GROUPINGID PRODUCT_PARENTREL
   INTO
   PRODUCT_ATTR_CGID USING PRODUCT_LEVELREL GID : ORA-36979: Property ***GID
   dimension status mismatches level dimension status*** can only be set by the
   GROUPINGID command.

  A partial workaround for this issue is to uncheck "Create level attribute
  columns in views" for each attribute until the number N * M (above) goes
  below 31.

原创粉丝点击