Scott Murray-240410 (10/29/2012)

---

grasshopper26 (10/28/2012)

---

I am new to SQL Server OLAP Cubes. I am having the following issue like

ex I have purchase order and invoice tables which are used in data source view. These two tables are related by purchase order ID which have one to many relationship with invoices.

I am getting the following error for the purcahse orders which i dont have invoices

Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: purchase order

Can anyone throw some light on this to help me

I would first check that your dimensions are fully processed with the most current data. If data has been added to the underlying source, but the dimensions have not been processed, that new data is not reflected in the dimension, so when the cube attempts to join the keys columns from fact to dimension, it is not available. If the dimension is up to date, then you will need to check the underlying source and find which invoices are missing. Generally, you should have a value for all keys or you can choose to how to process these error rows by choosing to ignore the missing values. I do not prefer this second option.