Jedox OLAP documentation

home > API > [/cell/drillthrough] >
request url https://[SERVER]:[PORT]/cell/drillthrough[?PARAMETER1=value[&...]]
short description Retrieves detailed data for a cube cell.
long description Depending on the mode the detailed data can be:
  • Historical data which track the changes of a cube cell
  • Source system data if the cube cell has been loaded via an ETL-process or if audit mode is enabled
  • User defined data
The Event OnDrillthrough is raised in Palo Supervision-Server which contains the application logic of Drillthrough. Note that Palo Supervision-Server has to be installed separately. For Audit mode SVS is not required but audit mode has to be enabled.
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
name_path npath Comma separated list of element names. Used only if path parameter is omitted.
area area Comma separated list of element identifiers lists. Each element identifiers list is colon separated. The area is the cartesian product. Only for mode 3.
name_area narea Comma separated list of element names lists. Each element names list is colon separated. The area is the cartesian product. Only for mode 3. Used only if database area is omitted.
mode integer 1 - SVS drillthrough, 2 - SVS secondary mode, 3 - Audit cell history
dimensions identifier Comma separated list of dimension identifiers. Used in combination with mode=3 to retrieve dimension audit.
type integer Default is 0. Value 1 is to be used in combination with mode=3 (audit) and cube to retrieve rule audit.
definition string string encapsulating the info about sorting, example: "USER-D" - sort by USER column descending (only for audit mode)
blocksize integer maximum number of lines retrieved, default 1000 (only for audit mode)
value integer start output result from this line number, default 0 - beginning (only for audit mode)
source string string encapsulating the list filter conditions for non-dimensional columns (only for audit mode)
condition string string encapsulating the filter condition expressions for non-dimensional columns (only for audit mode)
include_bulk boolean include bulk information columns to the result set (only for audit mode)
sid string Session identifier for a server connection. Use the /server/login request to get a valid session identifier.
result
# name type description
0 resultset string Comma separated component-values (columns) of resultset; First row: Component names of resultset-columns
examples
description
Cell drillthrough for cell "1,1,1"
further information