September 14, 2011 at 5:12 pm
Hi all,
I have a Project Table that has primary key made up of two fields CompanyCode + ProjectCode.
The same table contains ParentCompanyCode + ParentProjectCode fields to provide a parent child hierarchy.
The cube deploys correctly but then errors during processing with the error:
Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_Project', Column: 'ProjectCode', Value: 'C0031'. The attribute is 'Project Code'.
There are multiple values of the ProjectCode in error but there are no duplicates CompanyCode + ProjectCode combinations.
When I look at my datasource it is correctly showing both fields as the key field.
The Parent/Child Hierarchy is successfully setup on the Project Dimension and contains both CompanyCode and ProjectCode references.
We are using SQL Server 2008 R2.
Any help appreciated.
Cheers,
Sean
September 14, 2011 at 6:19 pm
Hi,
The problem was caused by adding the ProjectCode field (one of the primary key fields) as an attribute of the dimension. After removing this field from the attribute the dimension processed successfully.
Cheers,
Sean
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply