Attribute Key Not found Error while processing the cube in SSAS

Posted by sathya on Geeks with Blogs See other posts from Geeks with Blogs or by sathya
Published on Fri, 23 Apr 2010 02:09:08 GMT Indexed on 2010/04/23 2:54 UTC
Read the original article Hit count: 285

Attribute Key Not found Error occurs in SSAS due to the following reasons :

 

1. Dimensions processed after measure groups
2. Null values / references in Keys
3. Please check for the Null values in Interrelated dimensions.

(For Ex : You might have a dimension table employees, employees relates to table sub department, subdepartment relates to table department.

If by chance there exists a Null value in the mapping between subdepartment and department you will get this error).

 

© Geeks with Blogs or respective owner