Skip to main content
POST
/
activeviam
/
pivot
/
rest
/
v10
/
cube
/
query
/
mdx
/
drillthroughheaders
Gets the possible column headers for a given drillthrough MDX query. The request has the same format as the request for the actual drillthrough query, just the URL changes.
curl --request POST \
  --url http://localhost:9090/activeviam/pivot/rest/v10/cube/query/mdx/drillthroughheaders \
  --header 'Content-Type: application/json' \
  --data '
{
  "context": {},
  "mdx": "<string>",
  "queriesTimeLimit": "<string>"
}
'
{
  "aggregateRetrievals": [
    {
      "filterId": 123,
      "horizontalDispatching": {
        "dispatchingPerApplication": [
          {
            "applicationName": "<string>",
            "dispatchingPerLevel": {}
          }
        ]
      },
      "location": [
        {
          "dimension": "<string>",
          "hierarchy": "<string>",
          "level": [
            "<string>"
          ],
          "path": [
            {}
          ]
        }
      ],
      "measureProvider": "<string>",
      "measures": [
        "<string>"
      ],
      "partialProviderName": "<string>",
      "partitioning": "<string>",
      "resultSizes": [
        123
      ],
      "retrievalId": 123,
      "timingInfo": {},
      "type": "<string>",
      "underlyingDataNodes": [
        "<string>"
      ]
    }
  ],
  "databaseDependencies": {},
  "databaseRetrievals": [
    {
      "condition": "<string>",
      "fields": [
        "<string>"
      ],
      "joinedMeasure": [
        "<string>"
      ],
      "resultSizes": [
        123
      ],
      "retrievalId": 123,
      "store": "<string>",
      "timingInfo": {}
    }
  ],
  "dependencies": {},
  "planInfo": {},
  "queryFilters": [
    {
      "description": "<string>",
      "id": 123
    }
  ],
  "querySummary": {
    "measures": [
      "<string>"
    ],
    "partialProviders": [
      "<string>"
    ],
    "partitioningCountByType": {},
    "resultSizeByPartitioning": {},
    "retrievalsCountByType": {},
    "totalDatabaseResultSize": 123,
    "totalRetrievals": 123
  }
}

Documentation Index

Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt

Use this file to discover all available pages before exploring further.

Body

application/json

The MDX query for query plan inspection.

context
object
mdx
string
queriesTimeLimit
string

Response

The result of the MDX query.

aggregateRetrievals
object[]
databaseDependencies
object
databaseRetrievals
object[]
dependencies
object
planInfo
object
queryFilters
object[]
querySummary
object