PivotTable: qalculated cells

  • Thread starter Thread starter Andrey Savchenko
  • Start date Start date
A

Andrey Savchenko

Hi, All!

I have a problem with pivottable. When I am connecting to the OLAP cube
in MS SQL 2k AS which contain calculated cells it seems that Excel
process them on the client side.

Example: I have 2 measures: quantity and total quantity by dimension.

And seems that total quantity by dimension calculated depending on data,
that Excel received from OLAP server.

How can I prevent this and say to the excel do not recalculate this
measure.


PS: other BI clients process this situation ok.

-- -
wbr
Andrey Savchenko
 
Back
Top