将SSAS多维数据集部署到SQL Server Analysis时出错 [英] Error in deploying SSAS cube to SQL Server Analysis
问题描述
我在将SSAS软件包部署到SQL Server Analysis时遇到问题.它抱怨重复的键，而该列引用的不是主键列.我查询维度表，以查看受影响的列中的主键具有相同的值，这是正常且可能的.在SSDT中，属性用法和类型属性已设置为常规.请在下面找到我收到的错误.我将很乐意解决此问题.谢谢.
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 dimension table to see that the primary keys have same values in the affected columns which is normal and possible. The attribute usage and type property are already set to regular in SSDT. Please find the error I am receiving below. I will appreciate an idea to fix this issue. Thank you.
响应中的错误和警告
服务器:当前操作被取消，因为另一个操作在交易失败.OLAP存储引擎中的错误:A处理时发现重复的属性键:表:'dwh_Dim_By_Answers'，列:'QB_AnswerText'，值:'hazard'.这属性为"QB答案文本".
Server: The current operation was cancelled because another operation in the transaction failed. Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dwh_Dim_By_Answers', Column: 'QB_AnswerText', Value: 'hazard'. The attribute is 'QB Answer Text'.
推荐答案
这是针对此问题的两种解决方案:
Their is two solutions for this issue :
- 为避免在处理维度时出现重复键错误，您只需将维度属性ProcessingGroup设置为ByAttribute而不是ByTable.
- 通过在维度键错误选项卡中将KeyDupplicate设置为IgnoreError，强制SSAS忽略键重复错误.要实现此目的，请转到SSMS或SSVS->处理->在处理"标签中，点击更改设置->尺寸键错误->使用服装错误配置->将KeyDupplicate设置为IgnoreError.
这篇关于将SSAS多维数据集部署到SQL Server Analysis时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
