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. In the Database Server screen, on which to install the SEICube database on and specify the connection information.


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

    • Selecting the The Cube will be hosted by an SQL Server Remote Instance option 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. In the Database Files Folders screen, change the location of the OLAP Cube database files if necessary and click Next.


  5. Click Install.


  6. Click Finish.