Attribute key cannot be found - SSAS

Question

I am getting "Attribute key cannot be found" - there are records in dimension but Fact table does not have record of the key. how can i resolve it? Also, is it true that if fact table has the value and dimension does not have then it's ok but if fact table does not have value and dimension have it then it is violation of the key ?

Thank you,
Kashyap

Answer 1

Hi @K P ,

there are records in dimension but Fact table does not have record of the key. how can i resolve it?

This should be a quite normal scenario, suppose someone is a new sale person, but he/she does not have any sales records existed.
First Process Update the concerned dimension. After this is done, PROCESS FULL the concerned measure group individually.

Also, is it true that if fact table has the value and dimension does not have then it's ok but if fact table does not have value and dimension have it then it is violation of the key

It is not true, If the fact table has the value but dimension does not have, and you have set to ignore the error, then the measures will be mapped to the so called unknown member.

Regards，

Zoe

---

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.