A production SQL Server Analysis Services (SSAS) cube is processed daily. The users query products by using a hierarchy named Products from a dimension named Product.
The DimProduct table in the data source view is used as the source of the Product dimension. The table has the following structure.
The Product dimension has three attribute hierarchies:
- Product
- Subcategory
- Category
The attributes have the following relationships defined: Product > Subcategory > Category. Each attribute has a key and a name sourced from the related key and name columns in the DimProduct table.
During processing, you receive the following error message: ‘Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: ‘dbo_DimProduct’, Column:
‘SubCategoryKey1, Value: "23′. The attribute is Subcategory’."
You verify that the data is accurate.
You need to ensure that the dimension processes successfully.
What should you do?
A. Delete the Products hierarchy.
B. Relate the Subcategory and Category attributes directly to the Product attribute.
C. Remove the duplicate data from the DimProduct table.
D. Remove the Subcategory attribute.
