Preparations for CXO Installation (Version 20) for Microsoft SQL Server Analysis Services

This document describes the prerequisites and preparations for installing and configuring the CXO as a dashboard on SSAS environment. It does not describe the installation and configuration itself.

The tables should be used as a check-list:  either the indicated piece of information must be provided (enter it in the ‘Information’ column) or the specified action should be carried out / component should be installed (put a checkmark in the Done column).

CXO Application Server

Provide the following information for the CXO application server. We also support virtual servers.

Microsoft Components

The following Microsoft Components should be available on the server

Service Account

For communication between the Web-application and the OLAP database and for running the CXO services, we need a service account.  If Analysis Services (see below) is installed on the CXO application server, this service account can be a local machine account. Otherwise it should be a Domain account. The password of the account should never expire.

SQL Server

Data and meta-data of a CXO application are stored in SQL Server databases. A SQL Server should be available, or SQL Server should be installed on the CXO Application Server.

Analysis Services

The OLAP database in which we store the data runs on SQL Server Analysis Services. As a rule, Analysis Services is installed on the same Windows Server as the SQL Server Database Engine, but this is not a requirement. Only provide information if it differs from the SQL Server specifications.