70-466 Question #153: Real Exam Question with Answer & Explanation

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: CREATE TABLE [dbo].[DimProduct]( [DimensionKey] [int] IDENTITY(1,1) NOT NULL, [ProductKey] [int] NOT NULL, [ProductName] varchar NOT NULL, [SubcategoryKey] [int] NOT NULL, [SubcategoryName] varchar NOT NULL, [CategoryKey] [int] NOT NULL, [CategoryName] varchar NOT NULL ) ON [PRIMARY] 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: 'SubcategoryKey', 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?