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 https://{host}/activeviam/pivot/rest/v9/cube/query/mdx/drillthroughheaders \
--header 'Content-Type: application/json' \
--header 'arg0: <arg0>' \
--data '""'import requests
url = "https://{host}/activeviam/pivot/rest/v9/cube/query/mdx/drillthroughheaders"
headers = {
"arg0": "<arg0>",
"Content-Type": "application/json"
}
response = requests.post(url, headers=headers)
print(response.text)const options = {method: 'POST', headers: {arg0: '<arg0>', 'Content-Type': 'application/json'}};
fetch('https://{host}/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_URL => "https://{host}/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 => "\"\"",
CURLOPT_HTTPHEADER => [
"Content-Type: application/json",
"arg0: <arg0>"
],
]);
$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 := "https://{host}/activeviam/pivot/rest/v9/cube/query/mdx/drillthroughheaders"
payload := strings.NewReader("\"\"")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("arg0", "<arg0>")
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("https://{host}/activeviam/pivot/rest/v9/cube/query/mdx/drillthroughheaders")
.header("arg0", "<arg0>")
.header("Content-Type", "application/json")
.body("\"\"")
.asString();require 'uri'
require 'net/http'
url = URI("https://{host}/activeviam/pivot/rest/v9/cube/query/mdx/drillthroughheaders")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["arg0"] = '<arg0>'
request["Content-Type"] = 'application/json'
request.body = "\"\""
response = http.request(request)
puts response.read_body""[
{
"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 https://{host}/activeviam/pivot/rest/v9/cube/query/mdx/drillthroughheaders \
--header 'Content-Type: application/json' \
--header 'arg0: <arg0>' \
--data '""'import requests
url = "https://{host}/activeviam/pivot/rest/v9/cube/query/mdx/drillthroughheaders"
headers = {
"arg0": "<arg0>",
"Content-Type": "application/json"
}
response = requests.post(url, headers=headers)
print(response.text)const options = {method: 'POST', headers: {arg0: '<arg0>', 'Content-Type': 'application/json'}};
fetch('https://{host}/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_URL => "https://{host}/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 => "\"\"",
CURLOPT_HTTPHEADER => [
"Content-Type: application/json",
"arg0: <arg0>"
],
]);
$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 := "https://{host}/activeviam/pivot/rest/v9/cube/query/mdx/drillthroughheaders"
payload := strings.NewReader("\"\"")
req, _ := http.NewRequest("POST", url, payload)
req.Header.Add("arg0", "<arg0>")
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("https://{host}/activeviam/pivot/rest/v9/cube/query/mdx/drillthroughheaders")
.header("arg0", "<arg0>")
.header("Content-Type", "application/json")
.body("\"\"")
.asString();require 'uri'
require 'net/http'
url = URI("https://{host}/activeviam/pivot/rest/v9/cube/query/mdx/drillthroughheaders")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["arg0"] = '<arg0>'
request["Content-Type"] = 'application/json'
request.body = "\"\""
response = http.request(request)
puts response.read_body""[
{
"caption": "<string>",
"name": "<string>",
"type": "<string>",
"visible": true
}
][
{
"caption": "<string>",
"name": "<string>",
"type": "<string>",
"visible": true
}
]Headers
Show child attributes
Show child attributes
Body
application/json
The MDX query for query plan inspection.
Response
The result of the MDX query.
Was this page helpful?