Skip to main content

Set Up OLAP Cube for SQL Server

The OLAP database, known as OLAP Cube, stores OLAP cubes extracted from your data sources to support reporting and analytics. Use the dedicated installer to create this database on Microsoft SQL Server.

To install the OLAP cube, locate your installation folder and run either Nectari OLAP For SQL Server.exe or SEI OLAP For SQL Server.exe depending on your product name. Then follow the steps below.

important

This procedure is required only when installing SEI on Microsoft SQL Server. If you are using Oracle, skip this step.

Installation steps​

  1. Run the Nectari/SEI OLAP For SQL Server setup and click Next.
  2. Accept the license agreement by selecting I accept the terms in the license agreement, then click Next.
  3. On the Database Server screen, select the SQL Server where you want to install the OLAP cube database.
  4. Enter the connection information for your SQL Server instance.
  5. Select the collation for the new database:
    • To use the default server collation, leave Use the Server Collation selected.
    • To specify a different collation, clear the checkbox and enter the desired collation.
  6. If hosting the OLAP cube on a remote SQL Server instance (such as RDS), select The Cube will be hosted by an SQL Server Remote Instance.
    When you select this option, you cannot change the database file location.
  7. On the Database Files Folders screen, change the location of the OLAP cube database files if needed, then click Next.
  8. Click Install to begin the installation.
  9. Click Finish once the installation is copmplete.