cancel
Showing results for 
Search instead for 
Did you mean: 
intapiuser
Community Team Member
Community Team Member
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):
Rate this article:
Version history
Last update:
‎03-02-2023 08:54 AM
Updated by:
Contributors