Known Issues


Important to have the right version of the OLEDB for OLAP provider (PTS Pivot Table Services)

It is important to have the right version of the provider on the portal server and on each client. The version must also match the version used on the OLAP server and the client.


To check which version that is installed locate the following file(s) located in the folder C:\Program Files\Common Files\System\Ole DB, for AS 2008 folder C:\Program Files\Microsoft Analysis Services\AS OLEDB\10:

Msolap110.dll (Analysis Services 2012)

  • 11.0.2100.0, Analysis Services 11.0 Release
  • 11.0.3000.0, Analysis Services 11.0 SP1

Msolap100.dll (Analysis Services 2008)

  • 10.0.1600.0, Analysis Services 10.0 Release
  • 10.0.2531.0, Analysis Services 10.0 SP1
  • 10.0.4000.0, Analysis Services 10.0 SP2
  • 10.0.5500.0, Analysis Services 10.0 SP3
  • 10.50.1600.1, Analysis Services 10.0 R2
  • 10.50.2500.0, Analysis Services 10.0 R2 SP1
  • 10.50.4000.0, Analysis Services 10.0 R2 SP2

Msolap90.dll (Analysis Services 2005)

  • 9.0.1399.0, Analysis Services 9.0 Release
  • 9.0.2047.0, Analysis Services 9.0 SP1
  • 9.0.3042.0, Analysis Services 9.0 SP2
  • 9.0.4035.0, Analysis Services 9.0 SP3
  • 9.0.5000.0, Analysis Services 9.0 SP4

Msolap80.dll (Analysis Services 2000)

  • 8.0.1.94, Analysis Services 8.0 Release
  • 8.0.3.23, Office XP
  • 8.0.384.0, Analysis Services 8.0 SP1
  • 8.0.534.0, Analysis Services 8.0 SP2
  • 8.0.760.0, Analysis Services 8.0 SP3
  • 8.0.2039.0, Analysis Services 8.0 SP4

Msolap.dll (OLAP Services 7.0)

  • 7.0.1073, Original SQL Server 7.0 OLAP Services release
  • 7.0.1295, OLAP Services SP1
  • 7.0.1458, OLAP Services SP2
  • 7.0.1508, OLAP Services SP3

If more than one version of OLEDB for OLAP provider (PTS) installed

If you have more then one OLEDB for OLAP provider installed you may need to specify the version of the provider in the connection string, then use:

  • MSOLAP.1 for MSAS 7.0
  • MSOLAP.2 for MSAS 2000
  • MSOLAP.3 for MSAS 2005
  • MSOLAP.4 for MSAS 2008
  • MSOLAP.5 for MSAS 2012

MSOLAP is a version independent registry key that should point to the latest version of OLE DB for OLAP. If you for example have both OLE DB for OLAP for Microsoft Analysis Services 2000 and OLE DB for OLAP for SQL Analysis Services 7.0 installed make sure that the MSOLAP registry key points to the SQL Analysis Services 2000 version.

The value for the MSOLAP registry key should be: {a07ccd0c-8148-11d0-87bb-00c04fc33942}. Not {a07ccd00-8148-11d0-87bb-00c04fc33942} which is for SQL Analysis Server 7.0. Be careful - It only differs on one digit between the versions.

  • pe/knownissues.txt
  • Last modified: 2014/03/12 12:59
  • by pcbeja