Naming Rules for Jedox Objects

This article describes the naming rules for various objects in Jedox. As a rule, names in Jedox are not case-sensitive.

File names and paths

  • Maximum allowed length of file names for files in Designer: 64 characters.
  • Jedox Web Spreadsheet names should not exceed 40 characters.
  • Maximum allowed length of an overall file path: 4096 characters.

Databases

  • Valid characters: ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789_-
  • Length cannot be 0.
  • Space characters are not allowed.

Dimensions and cubes

  • 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
  • Names cannot begin with a period (.) character
  • Names cannot contain any of the following characters: \ / ? * : | < >
  • The name of a user info dimension must be longer than 2 characters and must start with two hashtags (##)

The following strings are reserved for internal usage and cannot be used as names for dimensions in OLAP:

  • Dimension
  • Cube
  • View
  • Subset
  • List
  • User
  • Group
  • Cell_Properties
  • Configuration

Elements, attributes, and Subsets

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

There are no rules regarding View names.

Names of Folders, Workbooks, worksheets, and ranges

  • The \ / < > [ ] { } ' " characters are not allowed in names of folders, files, and sheets in Jedox.

  • In principle, it is possible to use accents and special characters (such as ß, ä, etc., as well as non-Latin scripts) in these names. However, you should avoid using these characters as it is not possible to reference to these names.

  • Sheet names in a Jedox Spreadsheet workbook must contain at least 3 characters. Single or double quotes are not supported.

  • It is impossible to open two workbooks with the same name in the same session (even if the files have different paths or two different upper- and lower-case spellings.). This is also true for resource workbooks (e.g., globals).

  • named ranges (defined names in spreadsheets) cannot start with a possible cell address. For example, "A1Name" is not allowed in Jedox Spreadsheets.

  • The naming convention for a form element conforms to the naming requirements for named ranges and named formulas in the spreadsheet. Characters that are not allowed to be used in the name of a named range (like space character, minus character, or dash character) are also invalid for naming form elements.

  • If the length of a path (including filename) for a report exceeds 255 characters, that report cannot be opened.

Integrator

  • The characters . \ / ~ are not allowed.
  • Names cannot contain characters with ASCII codes <32 ("control characters"), such as Return, Backspace, Tab, etc.

Jedox OData Hub

  • The following characters in names can cause issues in OData services: % & ' " # and space character.
  • Attributes of elements should not be named "Name" as it can cause errors in the ODATA connection.

Additional Restrictions

  • Sheet names cannot begin or end with single quote characters.

When using Jedox 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 (OLAP)

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.

Updated November 4, 2024