After defining a schema, you will need to ‘build’ your ElastiCube. This will import the data from your data sources that you added to your schema.  You must build an ElastiCube at least once before the ElastiCube data can be used in a dashboard.

To build an ElastiCube:

  1. Click ElastiCube in the top menu, and then Build the ElastiCube.

OR

Within your schema, click Build in the top menu. Select Build the ElastiCube.

  1. Define the following options:
  • Target Server: Select the Sisense server location that hosts the ElastiCube.
  • Build Options: Select which data to import. For more information, see Build Settings.
    • Build Schema Changes: Imports data into new tables and fields where a change has been made to the schema since the previous build.
    • Build Entire ElastiCube: Imports data for all tables with a default of overriding existing data in the ElastiCube. If tables and fields in your schema are set to import accumulative data, then an additional option Delete existing Data exists. If selected, all data will be replaced instead of accumulative data where relevant.
  • Click More Settings to reveal the following settings:
    • Build Logging: Specifies the level of detail to store in the build log.
    • Sample data: Specifies the limitation on the number of table rows to import.
  1. Click Build to begin the import process.
  2. A log panel at the bottom of the screen will detail each stage of the build. When the build is complete, the following message appears in the logs: Build successfully ended.

Build Steps

Building ElastiCubes Remotely

You can build the ElastiCube locally on your machine or build the ElastiCube remotely from another machine in which Sisense is installed. This is useful for example when your configuration supports test and production environments. For more information on setting up production environments, click here.

When connecting remotely to your ElastiCube server must have Sisense installed and a unique Sisense license. While you can have multiple administrators working on and building an ElastiCube, only one administrator can work on an ElastiCube at a time to prevent data corruption. In addition, the machine in which the build is performed, must have sufficient resources to be able handle all of your data. See Sisense’s minimum requirements for more information.

To build an ElastiCube remotely:

  1. On the ElastiCube server where the ElastiCube is to be built, open ports 811 and 812 for inbound and outbound access.
  2. In the ElastiCube Manager, open the Sisense Server Console by clicking +.
  3. In the Connection Settings window, enter a name for the server and its IP address.
  4. Click Connect. The list of ElastiCubes for that server are displayed in the Sisense Server Console.
  5. In the ElastiCube Manager, click Build.
  6. Under Target Server, select the new server you have just added.
  7. Define your build settings and click Build as described in Building ElastiCubes.

Build Logs

The build logs record all steps, activities and alerts occurring during a particular build.
These logs can be helpful in determining when the last build occurred, what changes were made, and the status of the ElastiCube.

  1. Click ElastiCube on the top menu.
  2. Click Recent Logs.
  3. The logs will load and appear at the bottom of the screen.
  4. To save the log, click the save icon below the logs panel.

save log