When processing a dimension in SSAS 2005 we get the following error
messages:

1. Errors in the high-level relational engine. The
'dbo_Dim_McomSubscriber' table that is required for a join cannot be
reached based on the relationships in the data source view.

2. Errors in the OLAP storage engine: An error occurred while the
dimension, with the ID of 'Dim Customer Account 1', Name of 'Dim
CustomerTestNate' was being processed.

3. Errors in the OLAP storage engine: An error occurred while the 'Dim
Customer Account' attribute of the 'Dim CustomerTestNate' dimension
from the 'ProdDB_Cubes' database was being processed.

We haven't been able to find any documentation about the first error
and we believe that if we fix the first one the other two will go away.
Has anybody ran into a similar error? The join in the data source
view is correct. Help please!!!

I figured it out in case you receive the same error. I had to indicate
a logical primary key in each table where the join was taking place and
join on a seperate FK relationship. For example in our Customer table
we have Customer_ID as the PK and Acom_Customer_ID as the PK of the
AcomSubscriber table. The join goes from Acom_Customer_ID in the
Customer Table (FK) to the PK Acom_Customer_ID in the AcomSubscriber
table. If you need more explanation, let me know.

nskousen (AT) gmail (DOT) com wrote: