by Juan Rier » Thu, 11 Feb 1999 04:00:00
by Olivier Matra » Fri, 12 Feb 1999 04:00:00
It is true that the PivotTable feature in Excel2000 now uses the Microsoft
OLAP engine (specifically the client-side OLAP Engine called PivotTable
Service).
This allows in particular to go beyond the size limitations experienced in
former implementation of pivot tables, to do drills, etc. and thus to
perform true OLAP analysis.
This feature is available in Microsoft Office 2000 beta2.
Since PTS uses OLE-DB to connect to a data source, only OLAP Engines that
are also an OLE-DB provider are supported.
So far that means either MS OLAP Services or Applix TM1 Server7.
Olivier.
Quote:>Hi,
>I have read that Excel 2000 has made an evolution from pivot tables to an
>OLAP analysis tool. Is this option available on beta evaluation kit? Will
>Excel 2000 pivot tables able of reading metacubes from Essbase, IMB OLAP
>Server, Informix Metacube and/or others, or only PLATO?
>Thanks,
>Juan Riera
1. Excel 2000 Pivot Table - Full Data to Replicate Problem
2. psql and Latin-2 characters
3. Excel 2000 Pivot Table Limit?
4. JDBC connect to specific partition on EEE
5. Retrieving the properties of Dimensions from Excel 2000 Pivot Tables
6. Wanted: Mac DB program (Not FM Pro)
8. *** Am I being thick or what ? ***
9. Performance Issues using Excel 2000 Pivot Table functionality and Analysis Services
10. Pivot table in Excel 2000 vs Excel XP
11. URGENT!: Problems refreshing Excel pivot tables with SQL Server 2000
12. Excel Pivot Table: Difference between Office 2000 and XP
13. Using an OLAP Pivot Table in Excel 2000.