PERFORMANCE CANVAS

The Best Practice in Financial Control - EPM, CPM, Budgets, Reports, Plans, Dashboards, KPI Management, Scorecards & Consolidation

User Tools

Site Tools


pe:serverconfiguration:start

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

OLE DB Provider for Analysis Server 2008

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

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.

pe/serverconfiguration/start.txt · Last modified: 2014/03/12 14:51 by pcbeja