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 |
| Number of rows in Jedox Spreadsheets | 65,536 |
| Number of columns in Jedox Spreadsheets | 256 |
| Upload limit for databases, models, and other files | 2 GB |
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 April 14, 2025