SSAS Cube process failed

Question

Hi, I encountered an error when process cube. Can anyone tell me how to resolve this?
Error: Errors in the OLAP storage engine: The attribute key cannot be found

Answer 1

Hi @ismepopola ,

Thanks for your post,

Please try to follow below steps to find out the root cause:

1. Process All Dimensions one by one. And see in Management Studio that Dimensions are displayed or not. If not please set the Target Server and Database Project Property for Deployment.
2. Set ErrorConfiguration to Custom
3. keyErrorAction --> Set to ConvertToUnknown
4. Give keyErrorLimit as -1.
5. NullKeyConvertToUnknown --> Set to Ignore Error
6. Then Set EstimatedRows
7. And before processing Dimensions/Cube save changes.
8. And then Process Cube.
9. If all Dimensions processed successfully then start Process to Cube.
10. And see you have Administrator rights.
11. And then see that Cube on Server you had set in Deployment Property.

For more information, please refer to below links:
Error messages when you try to process a database or a cube
a similar thread

Best regards,
Carrin

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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

The attribute key cannot be found

That means, you have a attribute key in fact data, which don't exists in the related dimension. You have to take care about referencial integrity.