I'm building a cube in SSAS. I have a series of fact tables that have 2 foreign keys for product specific data. Only one of the two dimensions will ever apply to each row. If the row relates to product A, then foreign key A will have a value and foreign key B will be NULL. If the row relates to product B, the reverse will be true.
I'm having troubles with SSAS reporting "The attribute key cannot be found when processing..." This occurs when a valid foreign key is present. I'm setting NULLs to Unknown Members and it seems fine with these.
It just doesn't make sense that SSAS is not finding the attibute key. It's there..! I've pre-processed the dimension, so I know that it's ok. Has anyone else had this issue??