Data Limits in Jedox
This article provides the technical limitations of Jedox In-Memory DB, Jedox Web, and Jedox Integrator.
Limits of Jedox In-Memory DB
The Jedox In-Memory DB has technical limitations for the size of objects, such as the number of elements in a dimension, or the number of dimensions in a cube. These limits are listed below. Please note that these are technical limitations, not recommended values.
- The number of objects with ID is limited by a 4-byte-long unsigned integer. This corresponds to 2^32 = 4,294,967,296 objects.
- The number of numeric values in a cube is limited to 60 billion (guaranteed - can be expected to be 400 billion due to data compression).
- The length of all string values together in a cube is limited to 4,294,967,296 characters (including terminating zeros).
- The length of all element names together in a dimension is limited to 4,294,967,296 characters (including terminating zeros).
Users |
Max value1) |
Number of user groups |
2^32 |
Number of users |
2^32 |
Number of users per group |
2^32 |
Number of groups per user |
2^32 |
Number of characters in a user name/description |
2^32 |
Number of characters in a user password |
2^32 |
Number of characters in a group name / description |
2^32 |
Number of concurrent connected users |
64 K |
Server / database |
Max value(1) |
Memory usage for one database |
64 GB ^(2) |
Number of databases on one server |
2^64 ^(3) |
Number of dimensions in one database |
2^64 ^(3) |
Number of cubes in one database |
2^64 ^(3) |
Cube |
Max value1) |
Number of dimensions in a cube |
250 / 30 ^(4) |
How often can a dimension be used in a cube |
1 |
Number of characters in cube name / description |
2^32 |
Number of characters in text cells |
2^32 |
Number of rules in a cube |
2^32 |
Number of markers in a cube |
2^32 |
Length of a rule |
2^32 |
Length of a marker |
2^32 |
Length of a rule description |
2^32 |
Number of characters in cell notes |
2^32 |
Number of values in a cube |
2^32 |
Limitations for values to be stored in a cube cell:
Cube values are stored in double-precision floating point format. |
Dimension |
Max value1) |
Number of elements in one dimension |
2^32 ^(5) |
Number of children for one parent |
2^32 |
Number of parents for one child |
2^32 |
Number of consolidations in one dimension |
2^32 |
Number of consolidation levels |
2^32 |
Number of factors in a consolidation |
2^32 |
Number of factors in a dimension |
2^32 |
Number of dimensions |
2^32 |
Number of characters in dimension name/description |
2^32 |
Number of characters in element name |
2^32 |
Sum of the length of element names for a cell address |
2^32 |
Subsets |
Max value1) |
Number of elements in a Subset |
2^32 ^(6) |
Number of stored Subsets (public and private) |
2^32 |
Number of characters in a Subset name |
2^32 |
Attributes |
Max value1) |
Number of attribute tables per database |
2^32 |
Number of attribute tables per dimension |
1 |
Number of characters in an attribute field |
2^32 |
Number of characters in a text field of an attribute table |
2^32 |
Number of fields within an attribute table |
2^32 |
Limits of Jedox Web
Parameter |
Max. value |
Memory usage Web Server | 64 GB |
Memory usage Spreadsheet Server | 64 GB |
Number of Rows in Jedox Spreadsheets |
65,536 |
Number of Columns in Jedox Spreadsheets |
256 |
Upload limit for databases, models, and other files | 200 MB |
Limits of Jedox Integrator
Max. value |
|
Memory usage |
64 GB |
Number of characters for names |
|
for project names |
120 |
for component names |
128 |
for a column name |
128 |
for variable names | 128 |
Number of columns in an extract or transform |
1012 |
Updated September 27, 2024