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 232 = 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).
|
Max value1) |
|
| Users | |
| Number of user groups |
232 |
| Number of users |
232 |
| Number of users per group |
232 |
| Number of groups per user |
232 |
| Number of characters in a user name/description |
232 |
| Number of characters in a user password |
232 |
| Number of characters in a group name / description |
232 |
| Number of concurrent connected users |
64 K |
|
Max value(1) |
|
| Server / database | |
| Memory usage for one database |
64 GB (2) |
| Number of databases on one server |
264 (3) |
| Number of dimensions in one database |
264 (3) |
| Number of cubes in one database |
264 (3) |
|
Max value1) |
|
| Cube | |
| 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 |
232 |
| Number of characters in text cells |
232 |
| Number of rules in a cube |
232 |
| Number of markers in a cube |
232 |
| Length of a rule |
232 |
| Length of a marker |
232 |
| Length of a rule description |
232 |
| Number of characters in cell notes |
232 |
| Number of values in a cube |
232 |
|
Limitations for values to be stored in a cube cell:
Cube values are stored in double-precision floating point format. |
|
|
Max value1) |
|
| Dimension | |
| Number of elements in one dimension |
232 (5) |
| Number of children for one parent |
232 |
| Number of parents for one child |
232 |
| Number of consolidations in one dimension |
232 |
| Number of consolidation levels |
232 |
| Number of factors in a consolidation |
232 |
| Number of factors in a dimension |
232 |
| Number of dimensions |
232 |
| Number of characters in dimension name/description |
232 |
| Number of characters in element name |
232 |
| Sum of the length of element names for a cell address |
232 |
|
Max value1) |
|
| Subsets | |
| Number of elements in a subset |
232 (6) |
| Number of stored subsets (public and private) |
232 |
| Number of characters in a subset name |
232 |
|
Max value1) |
|
| Attributes | |
| Number of attribute tables per database |
232 |
| Number of attribute tables per dimension |
1 |
| Number of characters in an attribute field |
232 |
| Number of characters in a text field of an attribute table |
232 |
| Number of fields within an attribute table |
232 |
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 |
65536 |
|
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, 2022