Navigation :

Drillthrough Query

JSON Structure

"queries" : [
  {
    "@type": "DTQuery",
    "pivotId": "",
    "context": {
      "key": "value"
    },
    "locations": [
      "a|b|c|d",
      "x|y|z"
    ], 
    "measures": [
      "measure1",
      "measure2"
    ], 
    "isFormatted": true, 
    "firstResult": 0,
    "maxResults": 1000
  }
]

Property Details

Property	Values	Default Value
pivotId	Name of Cube
context	Map - Context values
locations	List of String locations
measures	List of String - Measure names
isFormatted	Boolean	True
firstResult	Integer - index of first result
maxResults	Integer - Maximum number of results