duplicate attribute key issue in cube processing

• sandhya.msbi

  SSC Veteran

  Points: 270

  More actions

  June 10, 2015 at 5:39 am

  #297600

  ERROR MESSAGE :

  "errors in the olap storage engine: table 'policy' ,column 'term' , value '1-ABCren',column 'policykey' ,value 'o1mj90',column 'quotekey' ,value 'osfa-201', The attribute is Term."

  my dimension hierarchy is having 4 levels and all are having compiste keys as key column.

  hieracrhy : policy -> Term -> episode ->section(all levels of hieracrhy is having composite keys)

  attribute relation is as : policykey->section->episode->Term->Policy

  please discuss the possibilities for this error occurance.

  TR,

• suresh.arumugham

  Right there with Babe

  Points: 717

  More actions

  July 3, 2015 at 3:58 pm

  #1810250

  Do you have an SQL queries to substantiate that your keys are unique(rows are not duplicated)?

  Could you try the SQL that is used during cube processing?