Post reply

SSAS Attribute cannot be found

  • April 17, 2018 at 2:34 pm

    #410430

    The attribute key cannot be found when processing: Table: 'dbo_FACT_PROD_QTY', Column: 'CONTRACT_RATE_KEY', Value: '0'. The attribute is 'CONTRACT_RATE_KEY'.
    The attribute key was converted to an unknown member because the attribute key was not found. Attribute CONTRACT_RATE_KEY of Dimension: ContractRateLevel f

    - I can process the dimension (ContractRateLevel), that the Fact table is pointing to with no problem.
    - The dbo_Fact_Prod_Qty table does have Nulls in column Contract_Rate_Key.
    - There are no Null values in the Dimension table: ContractRateLevel

  • April 19, 2018 at 12:30 pm

    #1987583

    dduffie - Tuesday, April 17, 2018 2:34 PM

    The attribute key cannot be found when processing: Table: 'dbo_FACT_PROD_QTY', Column: 'CONTRACT_RATE_KEY', Value: '0'. The attribute is 'CONTRACT_RATE_KEY'.
    The attribute key was converted to an unknown member because the attribute key was not found. Attribute CONTRACT_RATE_KEY of Dimension: ContractRateLevel f

    - I can process the dimension (ContractRateLevel), that the Fact table is pointing to with no problem.
    - The dbo_Fact_Prod_Qty table does have Nulls in column Contract_Rate_Key.
    - There are no Null values in the Dimension table: ContractRateLevel

    I think you just answered your own question.   If the cube is going to map everything correctly, there would have to be corresponding values, even for NULL.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply