| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
#Value in Analysis Services Pivot Table
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
#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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Refresh and PivotTable with Analysis Services | Excel Worksheet Functions | |||
| Add-In functions not available Analysis Services add-in. | Excel Worksheet Functions | |||
| Pivot Table services | Excel Discussion (Misc queries) | |||
Hybrid Mode
