Installing OLAP for SQL Server Cube database

Important

This step is only required for an installation of SEI under Microsoft SQL server.

Oracle does not use a separate SEICube database. If you are installing SEI in Oracle, skip this step and go directly to Installing the SEI Server (Basic) or Installing the SEI Server (Advanced).

To install the SEI OLAP Cube database, use the SEI OLAP for SQL Server.exe installation package. Some steps will be required later to complete the Cube setup and to refresh it.

  1. Run the application SEI OLAP for SQL Server.exe and click Next.

  2. In the License Agreement screen, click I accept the terms in the license agreement and click Next.

  3. Select the Database Server on which to install the SEICube Database on and specify the connection information.

    • Leave the Use the Server Collation checkbox ticked to use the collation of the server for the database. Otherwise, untick it and type the desired collation in the field that appears.

    • Ticking the The Cube will be hosted by an SQL Server Remote Instance checkbox will allow you to create the SEICube database in an SQL remote instance such as an RDS architecture, and you will not have the option to change database files path.

  4. Change the Location of the OLAP Cube Database files if necessary and then click Next.

  5. Click Install.

  6. Click Finish.