LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Refresh and PivotTable with Analysis Services Marco Russo Excel Worksheet Functions 2 August 8th 07 04:20 PM
Add-In functions not available Analysis Services add-in. UBoatCaptain Excel Worksheet Functions 2 February 6th 07 07:54 PM
Pivot Table services Craig Excel Discussion (Misc queries) 5 January 19th 05 06:11 PM


All times are GMT +1. The time now is 04:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"