Home Forums Data Warehousing Analysis Services Errors in the OLAP storage engine: The attribute key cannot be found when processing: Even though key Exist in Dim Table.. RE: Errors in the OLAP storage engine: The attribute key cannot be found when processing: Even though key Exist in Dim Table..

  • September 23, 2016 at 3:00 am

    #1902726

    1Ankit1 (12/27/2011)

    For this error, as other empirical solutions: you might as well try the below options:

    1.This error may also crop up if there are NULL values in the dimension attributes. Delete the NULL values from the table for that dimension attribute.

    2. If 1 is not very feasible,to get over this error permanently, you might as well change the "NULL Processing" property of the concerned 'dimension attribute' to unknown and then change the "UnknownMember" property of the 'dimension' to Visible or Hidden. However, be informed that this would add an 'unknown' value in the attribute.

    3. Change the "Trimming" property to NONE (default is 'Right'). This works in some cases for reasons known to god.

    thanks point 3 worked for me