Limits of Jedox Software Components

image_pdfimage_print

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 value 1)

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-bit Windows OS)

 64 GB 2)

Memory usage for one database (64-bit Linux OS)

 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 value 1)

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:

  • 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.

 

 

Max value 1)

   
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 value 1)

   
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 value 1)

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

 

File sizes
Maximum .bin, .csv, and .archive file size is limited only by the maximum file size of the underlying file system.
Journal .log files are split into chunks of 100,000,000 bytes each.
Practical maximum .log file size is limited only by the maximum amount of files per directory of the underlying file system.

Limits of Jedox Web

Parameter

Max. value

Memory usage Web Server

 

 – on 64-bit Windows OS

 64 GB

 – on 64-bit Linux OS

 64 GB

   

Memory usage Spreadsheet Server

 

 – on 64-bit Windows OS

 64 GB

 – on 64-bit Linux OS

 64 GB

   

Size of Jedox Spreadsheets

 

Number of Rows

65536

Number of Columns

256

Limits of the Jedox Integrator

 

Max. value

Memory usage

 

 – on 64-bit Windows OS

 64 GB

 – on 64-bit Linux OS

 64 GB

   

Number of characters for names

 

 – for project names

120

 – for component names

128

 – for a column name

128

   

Number of columns in an extract or transform

1012

 

1) The maximum level applies to the sum of individual values as specified at the beginning.
2) The data storage needs approximately 10-15 bytes for a numeric value. A sample database with a realistic dimension with 1.3 million elements needs about 305 MB.
3) We recommend a number in the hundreds range.
4) The number is technically limited by the processing limitations of the PALO.DATA functions to 250 dimensions, but it is strongly recommended not to use more than 30 dimensions in a cube.
5) Tested with 13 million elements.
6) In Jedox Web, the maximum result size of subsets, such as in ComboBoxes, is limited to 65,336 elements by default. This limit can be changed by adding a new entry max_result_size in the file ..\core\palo_config.xml under the section <palo_configuration>. For example: <max_result_size>256000</max_result_size>

image_pdfimage_print