Pivot table from Analysis Services-Problem with calculated cells

A

Alex

Hi, I'm using Analysis Services Enterprise Edition, where I created a cube
with a couple Calculated Cells. I then go to Excel 2003 SP2 and create a
pivot table for the cube.
The cube shows ok in the Cube Browser of AS but in the excel pivot table,
all calculated cells display as #Value!, while the rest of the measures show
ok.
Is this a known problem?
Thanks and happy new year!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 pivot table using analysis services cube as data source 0
Doughnut Chart linked with the slicer in the pivot table 0
Pivot Table Customized Formulas 0
#Value in Analysis Services Pivot Table 1
pivot table rolling 12 month filter? 1
Excel 2007 with SQL Server Analysis Services 2005 0
Alternatives to MS Query for Pivot Tables & Cubes 0
Unable to display cube calculations in Pivot Table 0

Top