Client Connectivity Enhancements in PivotTable Service
Enhancements to PivotTable® Service provide new connection options and support new cube and security features introduced in this release of Microsoft® SQL Server™ 2000 Analysis Services. Additional new functionality in PivotTable Service can be used by client applications when connected to an Analysis server or when working offline. For more information, see What's New in PivotTable Service.
Connecting to the Analysis Server
Client applications can communicate with the Analysis server through Microsoft Internet Information Services (IIS) using HTTP or HTTPS. Third-party security providers can also be used.
Allocated Writeback
You can write data to aggregation cells in a cube and, using one of four different allocation formulas, automatically distribute the data to the lowest level members. For more information, see Using Writebacks.
Managing Local Cubes
Many of the new features for server cubes, such as new dimension types, custom rollups, and calculated members, can also be used in local cubes.
Data Mining
PivotTable Service supports the advanced data mining and analysis techniques that are available in SQL Server 2000 Analysis Services. You can create and use data mining models to analyze data in server cubes or local databases.