Naming Conventions in Jedox

image_pdfimage_print

Names in Jedox are not case sensitive.

Rules for database names:

  • Valid characters: ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789_-
  • Names cannot begin with a period (.) character
  • Length cannot be 0.
  • Space characters are not allowed.

Rules for element, attribute, dimension*, and cube* names:

  • Length cannot be 0.
  • Names cannot begin or end with a space character.
  • Names cannot contain any characters with a character code < 32, e.g. Return, Tab, etc.
  • A sequence of two or more space characters is not allowed.

* In addition, the following rules also apply to dimension or cube names:

  • Names cannot begin with a period (.) character.
  • Names cannot contain any of the following characters: \ / ? * : | < >
  • The name of a user info dimension has to be longer than 2 characters and has to start with two hashtags (##).
Additional restrictions when Jedox is operated in a browser:
  • Element names cannot begin with  “< “.
  • In string-type cube cells, an entry cannot start with  “< “. Entries consisting only of the words “true” or “false” are not allowed.

ICU Comparison in the In-Memory DB

In the Jedox In-Memory database, the databases, cubes, dimensions, elements, and attributes are named in compliance with the ICU comparison Level 2. This means that, for example, in one single dimension, you cannot have two elements named m2 and m2. The “first one wins” principle is applied, and the higher levels are ignored.

image_pdfimage_print