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:

  • DBL_MAX: 1.7976931348623157e+308
  • -1 * DBL_MAX: -1.7976931348623157e+308
  • (-1 * DBL_MAX) - 0.001: -1.7976931348623157e+308
  • (-1 * DBL_MAX) - 100.0: -1.7976931348623157e+308

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