Skip to content Skip to sidebar Skip to footer
Home / Analysis / Cubes / Sql Server / Ssas

Error In Deploying Ssas Cube To Sql Server Analysis

Post a Comment
I am having issue deploying SSAS package to SQL Server Analysis. It is complaining of duplicates keys whereas the column is referencing is not a primary key column. I queried the d

Solution 1:

Their is two solutions for this issue :

  1. to avoid key duplicate error when processing a dimension you just need to set the dimension property ProcessingGroup to ByAttribute instead of ByTable.
  2. Force SSAS to ignore key duplicate error by setting KeyDupplicate to IgnoreError in dimension key errors tab. To achieve this go to SSMS OR SSVS -> process -> in process tab click change setings -> dimension key errors -> Use costume error configuration -> set KeyDupplicate to IgnoreError.

visit : https://www.mssqltips.com/sqlservertip/3476/sql-server-analysis-services-ssas-processing-error-configurations/

Post a Comment for "Error In Deploying Ssas Cube To Sql Server Analysis"