Jedox OLAP documentation

home > API > [/element/replace] >
request url https://[SERVER]:[PORT]/element/replace[?PARAMETER1=value[&...]]
short description Creates or updates an element
long description This request creates or changes an element. For consolidated elements this request replaces the existing elements with the given children elements.
parameters
name type description
database identifier Identifier of the database
name_database string Name of the database. Used only if database parameter is omitted.
dimension identifier Identifier of the dimension
name_dimension string Name of the dimension. Used only if dimension parameter is omitted.
element identifier Identifier of the element
name_element string Name of the element. (alternative for element parameter when the element exists, alternative for new_name parameter when new element is created)
new_name string Name of the new element
type integer Type of the element (1=NUMERIC, 2=STRING, 4=CONSOLIDATED)
children identifier Comma separated list of children identifiers. (Only for type=4)
name_children string Comma separated list of children names. Used only if children parameter is omitted. (Only for type=4)
weights double Optional comma separated list of children weights. (defaults to weight=1 for each child) (Only for type=4)
squash_list boolean If 1 then children and parents list are shortened to intervals (1-10) and weights are shortened to weight:count
sid string Session identifier for a server connection. Use the /server/login request to get a valid session identifier.
result
# name type description
0 element identifier Identifier of the element
1 name_element string Name of the element
2 position integer Position of the element
3 level integer Level of the element
4 indent integer Indent of the element
5 depth integer Depth of the element
6 type integer Type of the element (1=NUMERIC, 2=STRING, 4=CONSOLIDATED)
7 number_parents integer Number of parents
8 parents identifier Comma separated list of parent identifiers
9 number_children integer Number of children
10 children identifier Comma separated list of children identifiers
11 weights double Comma separated list of children weights
examples
description
Create consolidated element with name "new element" and children "6,7,8"
Updates consolidated element "30" and children "6,7,8"
further information