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.
Requirements for the Server
- 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
Requirements for the Client
- 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.
What is PTS?
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.
PTS for Analysis Server 2000
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.
OLE DB Provider for Analysis Server 2005
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 SP4 (Dec 2010): http://www.microsoft.com/download/en/details.aspx?id=20101
OLE DB Provider for Analysis Server 2008
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 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 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
OLE DB Provider for Analysis Server 2012
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.
Installation
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.
Server 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.
Client 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
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.
Assembly
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.