Hi,
I am having some difficulties in find why Analysis Services reference a
table that is not reference by any dimension when processing the database.
In a previous design, I had reference an Oracle view in the SALES PERSON
dimension; however, the source table was changed to reference a view.

When I process the shared dimension separate from the cube, I receive no
errors. Also, when I process each cube, I don't receive any errors.

It is only when I process the database, that I get an error that the table
or view does not exist.

How can I resolve this so that I can process the entire database at once?

Regards,
Fernando