After defining a schema, you need to build your ElastiCube. Building an ElastiCube imports 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:
- In the Data page, open the relevant ElastiCube and click . The Build Options dialog box is displayed.
- Select Replace All, By Table, or Changes Only. Replace All builds the ElastiCube from scratch with the current data from all the sources in the schema. By Table builds the ElastiCube as defined on the table level where all tables not defined are built from scratch. Changes Only builds the ElastiCube with data for tables that were added to the schema or modified since the last build. For an in-depth description of these settings and the implications of each setting, see ElastiCube Build Settings.
- Toggle the switch below to limit the amount of rows imported for each table.
This is useful for building samples of your data and reduces the overall amount of time it takes to build an ElastiCube.
- Click Build.
A log is displayed that describes the build process. When the build is complete, the following message appears in the logs: Build successfully ended.
Building ElastiCubes Remotely
Note: This functionality is only available in the desktop version of Sisense. This functionality will be available Sisense in the near future.
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, 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:
- On the ElastiCube server where the ElastiCube is to be built, open ports 811 and 812 for inbound and outbound access.
- In Sisense, open the Sisense Server Console by clicking +.
- In the Connection Settings window, enter a name for the server and its IP address.
- Click Connect. The list of ElastiCubes for that server are displayed in the Sisense Server Console.
- In Sisense, click Build.
- Under Target Server, select the new server you have just added.
- Define your build settings and click Build.