Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Analysis Services (2000)  #Value! appears in Excel from cube

Author  Topic  sotn Starting Member 1 Post Posted - 2006-06-23 : 06:08:57 I have a cube that was working fine until yesterday, but at the moment even though all the dimensions are working fine the measures are appearing as #Value! in the excel pivot table. This only happens for people in a 'role' with a dimension restriction (of salesperson). If I run the 'test role' from AS manager then it works fine. If I run from excel as a person with no dimension filters it works fine. This is SQL 2000 not SQL 2005. Any ideas?