#Value in Analysis Services Pivot Table

[Jim Thomlinson]

One of your pivot table cubes has started acting up. The cube is created in
Analysis Services. Recently one of the dimensions was rebuilt after one of
the member names changed. Since then we are intermitently getting a #Value
being returned. I checked a few things including the MDX that is being used
when the error occurs and do not see anything out of the ordinary. My guess
is that somehow something in the cube is corrupted. We re-precessed the cube
but the problem presists...

Any Ideas

 

[Jim Thomlinson]

Found it... It had to do with a write back table that held info about the
member that no longer existed.