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 January 29, 2024