Installation

DSP Portal Edition consists of a server part and a client part. The client part consists of the Web Part Wizard (used to create and edit web parts), Analysis Client (used to view AdHoc client) . The server part consists of a Web Part Assembly, dll files and resources used by the Web Parts. See Files installed on your system for a complete list of installed files.

Microsoft Windows 2003/2008/2012 Server.
Microsoft Office System SharePoint Services Product.
PTS (Pivot Table Services) Service Pack 3 for AS 2000 or higher or Analysis Services 9.0 OLE DB Provider for AS 2005 or Analysis Services 10.0 OLE DB Provider for AS 2008 or Analysis Services 11.0 OLE DB Provider for AS 2012.
Important! To be able to use role based security in the cube please read Analysis Server and SharePoint on separate machines.
Important! To be able to use DSP Portal Edition on a 64 bit platform, it is mandatory to configure the Web Part Server to run in COM+ 64 bit platform COM+ configuration

Microsoft Internet Explorer 5.5 or higher (Active scripting must be enabled)
To be able to send analysis and web parts you need to have Outlook 2000 or higher.
To be able to launch an AdHoc client from a Web Part you need at least one of these components on the client:
- Microsoft Office Web Components OWC (2000, XP or 2003)
- MS Data Analyzer
- ProClarity 5.3, 6.0, 6.1, 6.2 or 6.3
- Executive Viewer
PTS (Pivot Table Services) Service Pack 3 for AS 2000 or higher or Analysis Services 9.0 OLE DB Provider for AS 2005 or Analysis Services 10.0 OLE DB Provider for AS 2008 or Analysis Services 11.0 OLE DB Provider for AS 2012.

PTS PivotTable® Service is a collection of dynamic-link libraries (DLLs) that have to be installed on your computer to be able to connect to Analysis Services or a cube file. PivotTable Services does not work with SQL Server 2005 Analysis Services. Therefore, client applications that need connect to Analysis Services in both SQL Server 2000 and SQL Server 2005 will need to install both PivotTable Services 8.0 and Analysis Services 9.0 OLE DB Provider in a side-by-side configuration.

Please visit Microsoft's SQL Server Home page http://www.microsoft.com/sql to find information of latest service pack for SQL Server.

There are two setup programs for PTS, Ptslite.exe and Ptsfull.exe. They are provided on the SQL Server CD-ROM, in the folder \Msolap\Install\Pts. Ptslite.exe installs the PivotTable Service files only. Ptsfull.exe installs the PivotTable Service files and Microsoft Data Access Components (MDAC) that is required for PTS to work.

In this article http://support.microsoft.com/kb/290211/ you can find information about different PTS versions for SQL 2000.

Download Analysis Services 9.0 OLE DB Provider (SQLServer2005_ASOLEDB9.msi) which is a part of the Feature Pack from Microsoft's download page

SQL 2005 (Nov 2005): http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en
SQL 2005 SP1 (Apr 2006): http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en
SQL 2005 SP2 (Feb 2007): http://www.microsoft.com/downloads/details.aspx?FamilyID=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en
SQL 2005 SP3 (Dec 2008): http://www.microsoft.com/downloads/details.aspx?FamilyID=536fd7d5-013f-49bc-9fc7-77dede4bb075&displaylang=en
SQL 2005 SP4 (Dec 2010): http://www.microsoft.com/download/en/details.aspx?id=20101

Download Analysis Services 10.0 OLE DB Provider (SQLServer2008_ASOLEDB10.msi) which is a part of the Feature Pack from Microsoft's download page

SQL 2008 (Okt 2008): http://www.microsoft.com/downloads/details.aspx?FamilyID=228de03f-3b5a-428a-923f-58a033d316e1&displaylang=en
SQL 2008 (Apr 2009): http://www.microsoft.com/downloads/details.aspx?FamilyID=b33d2c78-1059-4ce2-b80d-2343c099bcb4&displaylang=en
SQL 2008 SP2 (Sep 2010): http://www.microsoft.com/download/en/details.aspx?id=6375
SQL 2008 SP3 (Okt 2011): http://www.microsoft.com/en-us/download/details.aspx?id=27596
SQL 2008 R2 (Jun 2010): http://www.microsoft.com/downloads/details.aspx?familyid=CEB4346F-657F-4D28-83F5-AAE0C5C83D52&displaylang=en
SQL 2008 R2 SP1 (Jul 2011): http://www.microsoft.com/download/en/details.aspx?id=26728
SQL 2008 R2 SP2 (Jul 2012): http://www.microsoft.com/en-us/download/details.aspx?id=30440

Download Analysis Services 11.0 OLE DB Provider (SQL_AS_OLEDB.msi) which is a part of the Feature Pack from Microsoft's download page

SQL 2012 (Mar 2012): http://www.microsoft.com/en-us/download/details.aspx?id=29065
SQL 2012 (Jan 2013): http://www.microsoft.com/en-us/download/details.aspx?id=35580

Important! You need to use same version of PTS/OLE DB Provider on all machines. Client machines, SharePoint Service machine and Analysis Service machine. If Analysis Services is not installed on the SharePoint Server a separate installation of PTS/OLE DB Provider on the SharePoint Server is needed.

To be able to add/view DSP BI Web Parts in SharePoint pages you have to install DSP Web Part components on your SharePoint server.

The installation package for DSP Portal Edition consists of one msi file. This file is used both for server and client installation.

The web part package will be installed on all existing virtual servers. If adding a new virtual server after the installation of DSP BI Web Parts you have to run install.bat (..\program files\dsp analysis client\web part). To be able to use shipped demo cube you have to select Custom or Complete installation.

DSP Client must be installed on each computer that will be used to create Web Parts or using the Launch or Send commands from the Web Part. It is possible to install both client and server components on the same machine by selecting Custom or Complete installation.

Upgrading from earlier retail versions will be handled automatically by the installation program. Installed trial versions needs to be removed manually before starting the installation. Web parts created with retail version or trial version will continue to work after this installation of this retail version.

Version 4.3 has no update on assembly Version or PublickeyToken. It will replace existing installed 4.x assembly. Therefore can not version 4.0, 4.1, 4.2 or 4.3 run side by side on one server installation.