Note: Sisense's default ElastiCube Server Console configuration is optimally tuned for ElastiCube and dashboard performance. It is generally not recommended to change these settings (except for Default server data folder and Rserve).
This article identifies and defines the preferences available for the Sisense ElastiCube Server.
In Sisense 6.7 or earlier, you can access the Sisense server preferences by clicking the cog in the Sisense Server Console:
Setting | Default | Description |
|---|---|---|
Default server data folder | C:\ProgramData\Sisense\PrismServer\ElastiCubeData | Directory where ElastiCubes are stored (see here for details) |
# of simultaneous query executions | Number of CPU logical cores / 2 | Maximum number of queries that will be processed at once. Automatically set in the installation to half the number of logical cores on the server |
Query TCP port | 812 | Port used to query the ElastiCube server from the web application |
Rserve | 120.0.0.1:6311 | IP address and port to connect R with Sisense (more information here) |
Query timeout (in seconds) | 300 | Time alloted to a non-responding query before it times out. |
Query Retries on Failure | 0 | After a query times out, how many retries to attempt |
ElastiCube port | 50000 | Port the ElastiCube runs through |
Backup ElastiCube before each new build | Unchecked | Option to save a .ecdata file of the ElastiCube before each build |
Data-import chunk size | 100000 | Number of records imported at once in a build |
ElastiCube restart timeout (seconds) | 3 | When an ElastiCube times out, how long before it restarts |
Free memory percentile to auto-restart | 30 | Minimum free memory needed in order to restart the service automatically in case it fails (no longer in use) |
Server memory percentile to auto-restart | 0 | Minimum server memory needed in order to restart the service automatically in case it fails (no longer in use) |
Remove EOF Character from textual fields | Checked | Removes hidden characters from text files |
Compress on build | Checked | Compress data when performing builds |
Query CPU cores | Number of CPU logical cores / 2 | Maximum number of CPU cores that can be leveraged to process one query |
ElastiCube memory usage | Dynamic | Percentage of RAM on the machine that the ElastiCube server can use. Dynamic is the default setting and will use Sisense's built-in processes to manage and clear memory. |
Skip data import on connection errors | Unchecked | Continue with a build if there is a connection error on a specific data source |
Recycle queries | Checked | Store query metadata for later use |
In Sisense 7.0 or later, it is available in the Admin screen, Data Management - Data Sources, and by clicking the context menu beside the applicable ElastiCube server (fewer options are available than from the Sisense Server Console):
