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/v9/cube/query/mdx/drillthroughheaders \
--header 'Content-Type: application/json' \
--data '
{
"context": {},
"mdx": "<string>",
"queriesTimeLimit": "<string>"
}
'import requests
url = "http://localhost:9090/activeviam/pivot/rest/v9/cube/query/mdx/drillthroughheaders"
payload = {
"context": {},
"mdx": "<string>",
"queriesTimeLimit": "<string>"
}
headers = {"Content-Type": "application/json"}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {'Content-Type': 'application/json'},
body: JSON.stringify({context: {}, mdx: '<string>', queriesTimeLimit: '<string>'})
};
fetch('http://localhost:9090/activeviam/pivot/rest/v9/cube/query/mdx/drillthroughheaders', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_PORT => "9090",
CURLOPT_URL => "http://localhost:9090/activeviam/pivot/rest/v9/cube/query/mdx/drillthroughheaders",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'context' => [
],
'mdx' => '<string>',
'queriesTimeLimit' => '<string>'
]),
CURLOPT_HTTPHEADER => [
"Content-Type: application/json"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "http://localhost:9090/activeviam/pivot/rest/v9/cube/query/mdx/drillthroughheaders"
payload := strings.NewReader("{\n \"context\": {},\n \"mdx\": \"<string>\",\n \"queriesTimeLimit\": \"<string>\"\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("http://localhost:9090/activeviam/pivot/rest/v9/cube/query/mdx/drillthroughheaders")
.header("Content-Type", "application/json")
.body("{\n \"context\": {},\n \"mdx\": \"<string>\",\n \"queriesTimeLimit\": \"<string>\"\n}")
.asString();require 'uri'
require 'net/http'
url = URI("http://localhost:9090/activeviam/pivot/rest/v9/cube/query/mdx/drillthroughheaders")
http = Net::HTTP.new(url.host, url.port)
request = Net::HTTP::Post.new(url)
request["Content-Type"] = 'application/json'
request.body = "{\n \"context\": {},\n \"mdx\": \"<string>\",\n \"queriesTimeLimit\": \"<string>\"\n}"
response = http.request(request)
puts response.read_body{
"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
}
}[
{
"caption": "<string>",
"name": "<string>",
"type": "<string>",
"visible": true
}
][
{
"caption": "<string>",
"name": "<string>",
"type": "<string>",
"visible": true
}
]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.
Executes the given MDX query and returns only the query plan.
POST
/
activeviam
/
pivot
/
rest
/
v9
/
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/v9/cube/query/mdx/drillthroughheaders \
--header 'Content-Type: application/json' \
--data '
{
"context": {},
"mdx": "<string>",
"queriesTimeLimit": "<string>"
}
'import requests
url = "http://localhost:9090/activeviam/pivot/rest/v9/cube/query/mdx/drillthroughheaders"
payload = {
"context": {},
"mdx": "<string>",
"queriesTimeLimit": "<string>"
}
headers = {"Content-Type": "application/json"}
response = requests.post(url, json=payload, headers=headers)
print(response.text)const options = {
method: 'POST',
headers: {'Content-Type': 'application/json'},
body: JSON.stringify({context: {}, mdx: '<string>', queriesTimeLimit: '<string>'})
};
fetch('http://localhost:9090/activeviam/pivot/rest/v9/cube/query/mdx/drillthroughheaders', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_PORT => "9090",
CURLOPT_URL => "http://localhost:9090/activeviam/pivot/rest/v9/cube/query/mdx/drillthroughheaders",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "POST",
CURLOPT_POSTFIELDS => json_encode([
'context' => [
],
'mdx' => '<string>',
'queriesTimeLimit' => '<string>'
]),
CURLOPT_HTTPHEADER => [
"Content-Type: application/json"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"strings"
"net/http"
"io"
)
func main() {
url := "http://localhost:9090/activeviam/pivot/rest/v9/cube/query/mdx/drillthroughheaders"
payload := strings.NewReader("{\n \"context\": {},\n \"mdx\": \"<string>\",\n \"queriesTimeLimit\": \"<string>\"\n}")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("Content-Type", "application/json")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.post("http://localhost:9090/activeviam/pivot/rest/v9/cube/query/mdx/drillthroughheaders")
.header("Content-Type", "application/json")
.body("{\n \"context\": {},\n \"mdx\": \"<string>\",\n \"queriesTimeLimit\": \"<string>\"\n}")
.asString();require 'uri'
require 'net/http'
url = URI("http://localhost:9090/activeviam/pivot/rest/v9/cube/query/mdx/drillthroughheaders")
http = Net::HTTP.new(url.host, url.port)
request = Net::HTTP::Post.new(url)
request["Content-Type"] = 'application/json'
request.body = "{\n \"context\": {},\n \"mdx\": \"<string>\",\n \"queriesTimeLimit\": \"<string>\"\n}"
response = http.request(request)
puts response.read_body{
"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
}
}[
{
"caption": "<string>",
"name": "<string>",
"type": "<string>",
"visible": true
}
][
{
"caption": "<string>",
"name": "<string>",
"type": "<string>",
"visible": true
}
]Body
application/json
The MDX query for query plan inspection.
Response
The result of the MDX query.
Was this page helpful?
Queries the cube using an MDX query (either SELECT or DRILLTHROUGH).
Previous
Gets the query plans for an MDX SELECT query. Note that the given MDX is run and the result is computed but only the query plans are returned.
Next
⌘I