Dup error in dimension attribute in SSAS (not key of table)

• juanvg1972

  SSC Enthusiast

  Points: 184

  More actions

  January 14, 2018 at 2:27 am

  #148218

  Hi,
  I have a dim in a SSAS cube like this:
  id_customer  name  city .....................1   Peter H.  Paris .................2   Jhon C.   Paris ....................3   Michale G.   London ..................4   George J.    London ...................

  When I generate the cube I have this error:
  Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'TABLE_NAME', Column: 'city'

  A dup error in column city.  My key in the dim is id_customer
  I can go to city dim properties and change 'keycolumn' property to 'id_customer' and 'namecolumn' to 'city'Then the cube process well without errors, but in the browser I can't see different values for city, because I havedifferent values for id_customer and the the city is repeated. I don't like this solution , I want to obtain sums of metrics by city
  How can I fix this problem?
  Why do I have an error if field city is not key of the table or dim?
  Any advice will be greatly appreciated.
  Thanks in advance