Jedox OLAP documentation

home > API > [/cell/drillthrough] >
request url http://[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 list. Each element identifiers list is colon separated. The area is the cartesian product. Only for mode 3.
mode integer 1 - SVS drillthrough, 2 - SVS secondary mode, 3 - Audit cell history
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)
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