Allowed and not-allowed Characters in Jedox

image_pdfimage_print

Names in Jedox are not case sensitive.

Allowed characters and regulations for database names:

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

The name of an element has to obey the following regulations:

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

The name of an attribute must obey the rules for element names.

The name of a dimension or cube must obey the rules for element names. Additionally, it has to meet the following requirements:

  • 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