error processing cube, attribute key not found

[tekkerguy]

I'm getting the following error when trying to process the database (please note I'm new to MS AS 2005)

I happens on a number of records but I'm just sending one. Also note that when I run a query to see if the key value is missing from the PK_TABLE, it is there, as well as the other table. So this has to be something that I'm just not familiar with.

Errors in the OLAP storage engine: The attribute key cannot be found: Table: FK_TABLE, Column: COMPANY_ID, Value: 61603. Errors in the OLAP storage engine: The attribute key was converted to an unknown member because the attribute key was not found. Attribute PK_TABLE of Dimension: Company Location from Database: New Analysis Server Project, Cube: CMP_CUBE, Measure Group: FK_TABLE, Partition: FK_TABLE, Record: 10853.

Any help is appreciated

 

[RiverGuy]

Try processing the dimensions first, then try the cube.

 

[tekkerguy]

Tried that and no go.

 

[tekkerguy]

Actually to be more specific, the dimensions processed no problem, when I did the cube afterwards, it failed.

 

[tekkerguy]

The problem turned out to be that the dimension was referencing a table that did not have a record with the referencing id. so I had to add it.