A production SQL Server Analysis Services (SSAS) cube is processed daily.
The users query facts by using a hierarchy named Geography from a dimension named Geography.
The DimGeography table in the data source view is used as the source of the Geography dimension.
The table has the following structure :
CREATE TABLE [dbo].[DimGeography](
[DimensionKey] [int] IDENTITY(1,1) NOT NULL,
[CityKey] [int] NOT NULL,
[CityName] [varchar](50) NOT NULL,
[StateProvinceKey] [int] NOT NULL,
[StateProvinceName] [varchar](50) NOT NULL,
[CountryKey] [int] NOT NULL,
[CountryName] [varchar](50) NOT NULL) ON [PRIMARY]
The Geography dimension has three attribute hierarchies:
– City
– State-Province
– Country
The attributes have the following relationships defined:
City > State-Province > Country.
Each attribute has a key and a name sourced from the related key and name columns in the DimGeography
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_DimGeography’, Column: ‘StateProvinceKey’,
Value: ’23’.
The attribute is ‘State-Province’.”
You verify that the data is accurate.
You need to ensure that the dimension processes successfully.
What should you do?
A.
Delete the Geography hierarchy.
B.
Remove the State-Province attribute.
C.
Relate the State-Province and Country attributes directly to the City attribute.
D.
Remove the duplicate data from the DimGeography table.