Jedox OLAP documentation

home > API > [/cell/goalseek_estimate] >
request url https://[SERVER]:[PORT]/cell/goalseek_estimate[?PARAMETER1=value[&...]]
short description Returns an estimation of the number of affected cells. No writing is performed.
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 1-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 1-2: Target cell path. Type 3-4: Source cell of transfer.
type integer The type of goal-seek algorithm. 1 equal allocation, 2 relative, 3 transfer, 4 full transfer.
area area Comma separated list of element identifiers lists. Each element identifiers list is colon separated. Type 4: Not used. Type 1-2: Siblings to reallocate for each dimension. Type 3: Target area of transfer.
name_area narea Comma separated list of element names lists. Each element names list is colon separated. Used only if area parameter is omitted. Type 4: Not used. Type 1-2: Siblings to reallocate for each dimension. Type 3: Target area of transfer.
path_to path Comma separated list of element identifiers. Type 4 only: Target cell of full transfer.
name_path_to npath Comma separated list of element names. Used only if path_to parameter is omitted. Type 4 only: Target cell of full transfer.
value double Type 1-2: The numeric value of the target cube cell. Type 3-4: The numeric value to transfer from source cell to target.
show_splash_threshold boolean If 1 return also splash_threshold (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 cell_count double Number of affected cells
1 splash_threshold double Splash threshold
examples
description
Estimates the number of affected cells of the goalseek operation.
further information