View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default #Value in Analysis Services Pivot Table

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

Jim Thomlinson


"Jim Thomlinson" wrote:

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
--
TIA...

Jim Thomlinson