You’re offline. This is a read only version of the page.
364
Hello Friends,
Am getting the following error while processing cube report
Warehouse dimension
Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'INVENTLOCATIONEXPANDED', Column: 'DATAAREAID', Value: 'dec'. The attribute is 'DATAAREAID'. Errors in the OLAP storage engine: The record was skipped because the attribute key is a duplicate. Attribute: DATAAREAID of Dimension: Warehouses from Database: Dynamics AX initial, Record: 4.
Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'INVENTLOCATIONEXPANDED', Column: 'DATAAREAID', Value: 'nil'. The attribute is 'DATAAREAID'. Errors in the OLAP storage engine: The record was skipped because the attribute key is a duplicate. Attribute: DATAAREAID of Dimension: Warehouses from Database: Dynamics AX initial, Record: 7.
Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'INVENTLOCATIONEXPANDED', Column: 'DATAAREAID', Value: 'laz'. The attribute is 'DATAAREAID'. Errors in the OLAP storage engine: The record was skipped because the attribute key is a duplicate. Attribute: DATAAREAID of Dimension: Warehouses from Database: Dynamics AX initial, Record: 5.
Product dimension
Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'INVENTTABLEEXPANDED', Column: 'DATAAREAID', Value: 'nil'. The attribute is 'DATAAREAID'. Errors in the OLAP storage engine: The record was skipped because the attribute key is a duplicate. Attribute: DATAAREAID of Dimension: Released products from Database: Dynamics AX initial, Record: 5.
Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'INVENTTABLEEXPANDED', Column: 'DATAAREAID', Value: 'laz'. The attribute is 'DATAAREAID'. Errors in the OLAP storage engine: The record was skipped because the attribute key is a duplicate. Attribute: DATAAREAID of Dimension: Released products from Database: Dynamics AX initial, Record: 6.
Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'INVENTTABLEEXPANDED', Column: 'DATAAREAID', Value: 'dec'. The attribute is 'DATAAREAID'. Errors in the OLAP storage engine: The record was skipped because the attribute key is a duplicate. Attribute: DATAAREAID of Dimension: Released products from Database: Dynamics AX initial, Record: 7.
Resource dimension
Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'WRKCTRTABLEEXPANDED', Column: 'DATAAREAID', Value: 'laz'. The attribute is 'DATAAREAID'. Errors in the OLAP storage engine: The record was skipped because the attribute key is a duplicate. Attribute: DATAAREAID of Dimension: Resources from Database: Dynamics AX initial, Record: 3.
can anyone suggest me what is the issue.
*This post is locked for comments
I have the same question (0)
You can edit the query from
SELECT NAME, INVENTLOCATIONTYPE, INVENTLOCATIONID, INVENTSITEID, DATAAREAID, PARTITION, RECID, INVENTLOCATIONID AS INVENTLOCATIONID_NAMECOLUMN, DATAAREAID AS DATAAREAID_NAMECOLUMN,
0 AS BI_ISNOTAPPLICABLE
FROM INVENTLOCATIONEXPANDED
WHERE (PARTITION = 5637144576)
UNION ALL
SELECT NOTAPPLICABLE.NAME, NOTAPPLICABLE.INVENTLOCATIONTYPE, NOTAPPLICABLE.INVENTLOCATIONID, NOTAPPLICABLE.INVENTSITEID, KEYCOLUMNS.DATAAREAID, NOTAPPLICABLE.PARTITION,
NOTAPPLICABLE.RECID, NOTAPPLICABLE.INVENTLOCATIONID_NAMECOLUMN, NOTAPPLICABLE.DATAAREAID_NAMECOLUMN, 1 AS BI_ISNOTAPPLICABLE
FROM (SELECT DISTINCT DATAAREAID
FROM INVENTLOCATIONEXPANDED AS INVENTLOCATIONEXPANDED_1
WHERE (PARTITION = 5637144576)) AS KEYCOLUMNS CROSS JOIN
(SELECT CAST(N'N/A' AS NVARCHAR(3)) AS NAME, NULL AS INVENTLOCATIONTYPE, '' AS INVENTLOCATIONID, CAST(N'N/A' AS NVARCHAR(3)) AS INVENTSITEID, 0 AS PARTITION, 0 AS RECID,
CAST(N'N/A' AS NVARCHAR(3)) AS INVENTLOCATIONID_NAMECOLUMN, CAST(N'N/A' AS NVARCHAR(3)) AS DATAAREAID_NAMECOLUMN, 1 AS BI_ISNOTAPPLICABLE) AS NOTAPPLICABLE
to be like this
SELECT NAME, INVENTLOCATIONTYPE, INVENTLOCATIONID, INVENTSITEID, DATAAREAID, PARTITION, RECID, INVENTLOCATIONID AS INVENTLOCATIONID_NAMECOLUMN, DATAAREAID AS DATAAREAID_NAMECOLUMN,
0 AS BI_ISNOTAPPLICABLE
FROM INVENTLOCATIONEXPANDED
WHERE (PARTITION = 5637144576)
UNION ALL
SELECT NOTAPPLICABLE.NAME, NOTAPPLICABLE.INVENTLOCATIONTYPE, NOTAPPLICABLE.INVENTLOCATIONID, NOTAPPLICABLE.INVENTSITEID, KEYCOLUMNS.DATAAREAID, NOTAPPLICABLE.PARTITION,
NOTAPPLICABLE.RECID, NOTAPPLICABLE.INVENTLOCATIONID_NAMECOLUMN, NOTAPPLICABLE.DATAAREAID_NAMECOLUMN, 1 AS BI_ISNOTAPPLICABLE
FROM (SELECT DISTINCT DATAAREAID
FROM INVENTLOCATIONEXPANDED AS INVENTLOCATIONEXPANDED_1
WHERE (PARTITION = 5637144576)) AS KEYCOLUMNS CROSS JOIN
(SELECT CAST(N'N/A' AS NVARCHAR(3)) AS NAME, NULL AS INVENTLOCATIONTYPE, '' AS INVENTLOCATIONID, CAST(N'N/A' AS NVARCHAR(3)) AS INVENTSITEID, 0 AS PARTITION, 0 AS RECID,
CAST(N'N/A' AS NVARCHAR(3)) AS INVENTLOCATIONID_NAMECOLUMN, CAST(N'N/A' AS NVARCHAR(3)) AS DATAAREAID_NAMECOLUMN, 1 AS BI_ISNOTAPPLICABLE) AS NOTAPPLICABLE WHERE NOTAPPLICABLE.NAME !='N/A'
so we add in the end of the query
WHERE NOTAPPLICABLE.NAME !='N/A'
Share
Report
All responses (
Answers (
