Jedox Data Functions Overview

Jedox software includes standard spreadsheet functions, Subset filter functions, and array functions. Here you find the functions classified by their intended use, followed by a list of possible parameters.

Parameters

Name Possible entry
Server/Database A text entry (Name) such as "localhost/Demo" or a coordinate such as A1
Cube A text entry (Name) such as "Sales" or a coordinate such as A2
Dimension A text entry (Name) such as "Europe" or a coordinate such as A4
Element/Consolidated element A text entry (Name) such as "Variance" or a coordinate such as B8
Coordinate Can be an element
Type "n" for numeric, "s" for String/Text and "c" for consolidated
Weighting factor A number
Delete TRUE or FALSE (TRUE if existing entries should be deleted)
Position of base element A number
Position A number
Number of consolidated elements A number
Old name, new name Two coordinates such as A1,B1.
The names to be changed are in the coordinates.
Position of the sibling element A number
Value The coordinate containing the value to be written. Instead of a coordinate such as A1, you can also use a formula such as A1*B1. This is described in the push rules.
Splash TRUE or FALSE (TRUE = write in consolidated element)
Error A coordinate, e.g. B10. This refers to the cell in which the corresponding PALO.SETDATA function is executed.
Storage location (path) A path such as C:/Documents and Setting/Own Files/Error log.txt. In this case the faulty data records of an import are saved in the "Error log.txt" file.
Empty String In the current version, various functions have been extended to accept the argument "Empty String". If you enter "TRUE" as actual argument here, a possible error message will not be displayed. Instead, the cell will be left empty! If you enter "TRUE" as actual argument here, a possible error message will not be displayed. Instead, the cell will be left empty!

Notes:

  • You might have to replace the comma (,) with a semicolon (;) and the apostrophe (‘) with quotation marks ("). This depends on country settings.
  • If an argument remains empty in a formula, two quotation marks ("") are normally set to generate an empty string.

Updated November 5, 2024