Hi there

I keep getting this message when trying to run an Analysis Services
cube - "The column prefix XXX does not match with a table name or alias
name used in the query.". The dimension table name that it is
referring to (XXX) is clearly linked to the fact table when viewing the
design schema. I am filtering on a field within this table in the cube
partition - although when I remove the filter, the cube runs fine. I
have tried optimizing and validating the cube structure - and again
this table is recognized. This particular cube is also 1 of 4 physical
cubes that make up a virtual cube. The strangest part of it is that it
will work for a while, and then one day will stop working. Any
suggestions as to why this is occuring and what I can do to fix it?

Thanks!

~Lisa - OLAP Developer