key not found error

1
votes

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

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'.

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?

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.

1
ssasbusiness-intelligence
which version of SSAS are you using? – Bill Anton
also, are you sure you don't have more than 100 records in your source with missing key values? – Bill Anton

1 Answers

1
votes

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.