Can somebody help me develop a Customer Dimension. I have a customer table with CustomerID, City, State, Country. The error is that for City e.g Different states with a similar city name throws an error.

The likelyhood is high that the following forum is more appropriate for your issue: SQL Server Analysis Services Can you specify where you get the error and what is the exact error message? Thanks.Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM

Here is the Error i get ------------------ Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_DimCustomer', Column: 'City', Value: 'Berlin'. The attribute is 'City'. Thank you

Check out the following thread: http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/9f1773d5-9693-483f-b913-77b880d772f5 Also, this is the wrong forum as noted above.Kalman Toth, SQL Server & Business Intelligence Training; SQL 2008 GRAND SLAM