There are 2 (two) ways to create a Pivot Table to connect to a Analysis
Services’ cube.

Data -> Import External Data -> Import Data -> New Source. At this point,
there are 3 possibilities:
1. Microsoft SQL Server OLAP Services – uses the “Microsoft OLE DB Provider
for OLAP Services”.
2. “Other/Advance” and choose “Microsoft OLE DB Provider for OLAP Services”.
3. “Other/Advance” and choose “Microsoft OLE DB Provider for OLAP Services
8.0” – this is the correct one.

Data -> PivotTable and PivotChart Report… -> External Data Source -> Next ->
Get Data -> OLAP Cubes -> <New Data Source> -> Fill in the name of data
source. At this point, there are the same possibilities as above:
4. Choose “Microsoft OLE DB Provider for OLAP Services”.
5. Choose “Microsoft OLE DB Provider for OLAP Services 8.0”.

The problem we have is that be have a linked cube to a cube in the same
server (using IP address) and it only works if we use with solution 5..
Our environment is composed of a server with Itanium 2 @ 1.5 GHz x 4,
Windows 2003 Server, SQL Server 2000 SP3 and Analysis Services 2000 SP3.

The end users prefer using solution 1. because is easier/faster to use.
However, it does not work with this particular cube, why?

Why is it that solution 3 also does not work if solution 5 does work?

Thanks in advance.