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>"
}
'import requests
url = "http://localhost:9090/activeviam/pivot/rest/v10/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/v10/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/v10/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/v10/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/v10/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/v10/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
/
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>"
}
'import requests
url = "http://localhost:9090/activeviam/pivot/rest/v10/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/v10/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/v10/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/v10/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/v10/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/v10/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?
⌘I