Unable to display cube calculations in Pivot Table

D

Dmitri

I have a cube with quite complex calculated cells, which work fine in cube
еру browser or with MDX. The moment I use Excel 2007 Pivot table, it
shows#Value! instead of the numbers. I thought GetPivotData simply returned
values from the cube and did not do any own calculations. I spent a lot of
time to design the cube, but now it cannot be used from Excel... Any help
woul dbe greatly appreciated.
 

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
Alternatives to MS Query for Pivot Tables & Cubes 0
#Value in Analysis Services Pivot Table 1
how to display MDX Query that is fired from excel 2003 0
Pivot table from Analysis Services-Problem with calculated cells 0
suppress warning and locate cube in a pivot table from olap cube 0
Pivot Table accessing data from OLAP cube 0
KPI in pivot table 0

Top