Jedox OLAP documentation

home > API > [/cell/goalseek] >
request url http://[SERVER]:[PORT]/cell/goalseek[?PARAMETER1=value[&...]]
short description Puts value into cell and calculates values for sister cells in order to parents remain unchanged.
long description
parameters
name type description
database identifier Identifier of the database
name_database string Name of the database. Used only if database parameter is omitted.
cube identifier Identifier of the cube
name_cube string Name of the cube. Used only if cube parameter is omitted.
path path Comma separated list of element identifiers. Type 0-2: Target cell path. Type 3-4: Source cell of transfer.
name_path npath Comma separated list of element names. Used only if path parameter is omitted. Type 0-2: Target cell path. Type 3-4: Source cell of transfer.
type integer The type of goal-seek algorithm. 0 complete allocation, 1 equal, 2 relative, 3 transfer, 4 full transfer (0 default).
area area Comma separated list of element identifiers list. Each element identifiers list is colon separated. Type 0: Not used. Type 1-2: Siblings to reallocate for each dimension. Type 3: Target area of transfer. Type 4: Target cell of full transfer.
name_area narea Comma separated list of element names list. Each element names list is colon separated. Used only if area parameter is omitted. Type 0: Not used. Type 1-2: Siblings to reallocate for each dimension. Type 3: Target area of transfer. Type 4: Target cell of full transfer.
value double Type 0-2: The numeric value of the target cube cell. Type 3-4: The numeric value to transfer from source cell to target.
wait boolean If 1 then waits until the asynchronous part of operation is finished (optional, default is 0)
sid string Session identifier for a server connection. Use the /server/login request to get a valid session identifier.
result
# name type description
0 OK boolean "1" means OK
examples
description
Put 7 in cell "5,5" and calculate other values.
further information