Share via

Attribute Key cannot be found error when processing the table

Amy Jandreau 61 Reputation points
2021-08-26T15:33:05.247+00:00

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

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,249 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CarrinWu-MSFT 6,856 Reputation points
    2021-08-27T02:15:14.973+00:00

    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.

    127366-ignore.png

    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.

    1 person found this answer helpful.
  2. Amy Jandreau 61 Reputation points
    2021-08-26T20:46:43.137+00:00

    Any help please??

    0 comments
  3. Amy Jandreau 61 Reputation points
    2021-08-27T14:24:51.783+00:00

    @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.
    127162-capture.png