SSAS: errors in the OLAP storage module: attribute key could not be found during processing

Question

In my search, I saw that this error text was asked in different contexts, but in particular, I want to know if there is something missing here.

In the basic setup, I have 1 measurement table and 1 measurement table in my DSV. In my test, the measurement table contains about half of the products sold, but the size table contains information about the entire product catalog.

The relationship has a dimension table as a foreign key, and size as a primary. The point is not a problem, since both are integers.

What am I doing wrong? I tried to change the relationship, and I always process the measurement completely before processing the cube in its entirety when I make changes.

To avoid errors, I can either set the error to ignore errors or make sure that the dimension contains only those products that this measure contains. I can do the latter, but I feel that using an unfiltered lookup table is cleaner and more efficient - on this note I say: "Am I missing something?"

Answer 1

Apologies for wasting time on this. I was about to delete the question, but thought I'd share my corrections:

In my example above, I did not mention that the dimension table also had links to other tables. Missing (null) links between these tables led to the absence of a dimension element during processing, so the "attribute coupon could not be found" when processing a cube!