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
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