找不到密钥错误 [英] key not found error

问题描述

我有一个称为客户的维度，其中UnknowMember = True，UnknowMemberName = NA。处理维度时，我会看到所有客户以及一名NA成员。我还配置了ErrorConfiguration = IgnoreError和KeyErrorLimit = 100

I have a dimension called customer, with UnknowMember = True and UnknowMemberName = NA. When I process my dimension, I see all my customers plus a NA member. I also configured ErrorConfiguration = IgnoreError and KeyErrorLimit = 100

我在我的事实上有一行，customerID为NULL，并且多维数据集无法处理此错误（其更改为NULL）到0，不确定是否期望）：

I have a row on my fact with NULL on the customerID and the Cube fails to process with this error (its changing NULL to 0, not sure if it is expected):

Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'dbo_FactSales', Column: 'CustomerId', Value: '0'. The attribute is 'Customer'.

我期望根据维度的配置，将NULL行分配给该维度的NA成员。

I was expecting that, based on my configuration of the dimension, that the NULL row would be assigned to the NA member of the dimension.

我缺少什么？仅供参考：

What am I missing? Is it possible to be done?

仅供参考：我知道我可以在数据库上保存一个Unknow记录，并在ETL流程中进行处理，但是我想使用SSAS

FYI: I know that I could have a Unknow record on my db and deal with it on the ETL process, but I would like SSAS to handle this situation.

推荐答案

嘿小伙子们，感谢您的帮助。
的问题是我正在维度上进行这些配置。我应该在度量组中完成。

hey lads thanks for the help. the problem was that I was doing these configurations at the dimension. I should have done in the Measure group.

这篇关于找不到密钥错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！