Attribute Key cannot be found error when processing the table

Question

Hi All
We have a dimension (snowflake), where three tables are related DimEntity, DimUnit and DimProvider.
When i process the dimension i am getting the following error
Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'dbo_DimEntity', Column: 'EntityKey', Value: '832'. The attribute is 'Entity'. Errors in the OLAP storage engine: The attribute key was converted to an unknown member because the attribute key was not found. Attribute Unit of Dimension: Entity - Unit - Provider from Database: BusinessIntelligenceQA, Record: 1101. Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation. Errors in the OLAP storage engine: An error occurred while the 'Unit' attribute of the 'Entity - Unit - Provider' dimension from the 'BusinessIntelligenceQA' database was being processed.
When i looked up the key exists in the DimUnit table only and not in (DimEntity and DimProvider). Please advice.
Thanks

Answer 1

Hi @Amy Jandreau ,

Welcome to Microsoft Q&A!

Sorry for the late reply. This issue occurs because a fact table for a cube has one or more records that contain an attribute key, and this attribute key does not exist in the corresponding dimension table. This behavior may occur when you have not processed the corresponding dimension before you process the cube or when the underlying tables actually have mismatched data. If the "Value:" field in the message has no number after it, the fact table must contain null data. Please refer to this link to get the solution.

Best regards,
Carrin

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Any help please??

Answer 3

@CarrinWu-MSFT
What you said is correct, but that is how the business rule here is, that KEY will make to the DIM Table after some other processes are submitted, is there a way around, i mean ignore the attribute key error?
When using VS SSDT for some reason my screen doesn't show the "change processing option", please see the screen shot.