I am getting the below error when I try to process my dimension in Analysis services from SQL Server Management Studio.
Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'AB_MATERIAL', Column: 'MAT_DESC', Value: 'SD DF44002R-N010 2.4L (Q) '. The attribute is 'MAT_DESC_Attribute'.
I checked the dimension table AB_MATERIAL and am able to see the said missing value. However, whenever I browse the dimension is AS, I cannot see this value.
Can anyone help please.