EXCEL 2000 AS A FRONT END TOOL

S

sh

I have created a cube that uses "calculated members" for %
calcs.

The data has processed fine on the SLQSERVER 2000 Analysis
server.

Using Excel 2000 I tried to build a Pivot Table using
the "calculated members" by connecting to the OLAP cube.

Although the summarised fields appear okay,
the "calculated members" do not although they are
available on the filtering list.

"calculated members" do appear to work in Excel 2002 and
Excel 2003.

Can someone please explain why "calculated members" do not
appear in Excel 2000.

Thanks
 
Top