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.
curl --request POST \
--url https://{host}/activeviam/pivot/rest/v9/cube/query/mdx/queryplan \
--header 'Content-Type: application/json' \
--data '""'import requests
url = "https://{host}/activeviam/pivot/rest/v9/cube/query/mdx/queryplan"
headers = {"Content-Type": "application/json"}
response = requests.post(url, headers=headers)
print(response.text)const options = {method: 'POST', headers: {'Content-Type': 'application/json'}};
fetch('https://{host}/activeviam/pivot/rest/v9/cube/query/mdx/queryplan', 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/queryplan",
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"
],
]);
$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/queryplan"
payload := strings.NewReader("\"\"")
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("https://{host}/activeviam/pivot/rest/v9/cube/query/mdx/queryplan")
.header("Content-Type", "application/json")
.body("\"\"")
.asString();require 'uri'
require 'net/http'
url = URI("https://{host}/activeviam/pivot/rest/v9/cube/query/mdx/queryplan")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["Content-Type"] = 'application/json'
request.body = "\"\""
response = http.request(request)
puts response.read_body""[
{
"aggregateRetrievals": [
{
"filterId": 123,
"horizontalDispatching": {
"dispatchingPerApplication": [
{
"applicationName": "<string>",
"dispatchingPerLevel": {}
}
]
},
"location": [
{
"dimension": "<string>",
"hierarchy": "<string>",
"level": [
"<string>"
],
"path": [
"<unknown>"
]
}
],
"measureProvider": "<string>",
"measures": [
"<string>"
],
"measuresData": [
{
"name": "<string>"
}
],
"partialProviderName": "<string>",
"partitioning": "<string>",
"resultSizes": [
123
],
"retrievalId": 123,
"timingInfo": {},
"type": "<string>",
"underlyingDataNodes": [
"<string>"
],
"underlyingRetrievalType": "<string>"
}
],
"databaseDependencies": {},
"databaseRetrievals": [
{
"condition": "<string>",
"fields": [
"<string>"
],
"joinedMeasure": [
"<string>"
],
"resultSizes": [
123
],
"retrievalId": 123,
"store": "<string>",
"timingInfo": {}
}
],
"dependencies": {},
"planInfo": "<unknown>",
"queryFilters": [
{
"description": "<string>",
"id": 123
}
],
"querySummary": {
"measures": [
"<string>"
],
"partialProviders": [
"<string>"
],
"partitioningCountByType": {},
"resultSizeByPartitioning": {},
"retrievalsCountByType": {},
"totalDatabaseResultSize": 123,
"totalRetrievals": 123
}
}
][
{
"aggregateRetrievals": [
{
"filterId": 123,
"horizontalDispatching": {
"dispatchingPerApplication": [
{
"applicationName": "<string>",
"dispatchingPerLevel": {}
}
]
},
"location": [
{
"dimension": "<string>",
"hierarchy": "<string>",
"level": [
"<string>"
],
"path": [
"<unknown>"
]
}
],
"measureProvider": "<string>",
"measures": [
"<string>"
],
"measuresData": [
{
"name": "<string>"
}
],
"partialProviderName": "<string>",
"partitioning": "<string>",
"resultSizes": [
123
],
"retrievalId": 123,
"timingInfo": {},
"type": "<string>",
"underlyingDataNodes": [
"<string>"
],
"underlyingRetrievalType": "<string>"
}
],
"databaseDependencies": {},
"databaseRetrievals": [
{
"condition": "<string>",
"fields": [
"<string>"
],
"joinedMeasure": [
"<string>"
],
"resultSizes": [
123
],
"retrievalId": 123,
"store": "<string>",
"timingInfo": {}
}
],
"dependencies": {},
"planInfo": "<unknown>",
"queryFilters": [
{
"description": "<string>",
"id": 123
}
],
"querySummary": {
"measures": [
"<string>"
],
"partialProviders": [
"<string>"
],
"partitioningCountByType": {},
"resultSizeByPartitioning": {},
"retrievalsCountByType": {},
"totalDatabaseResultSize": 123,
"totalRetrievals": 123
}
}
]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.
Executes the given MDX query and returns only the query plan. Since revision 5, a new measuresData field is available in the response. The measures field is deprecated in favor of measuresData. Since revision 6, retrievals on a partial provider expose the type of the retrieval that performed their aggregation, through a new underlyingRetrievalType field, and its timings, through the new underlyingStartTime and underlyingElapsedTime entries of timingInfo.
POST
/
activeviam
/
pivot
/
rest
/
v9
/
cube
/
query
/
mdx
/
queryplan
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.
curl --request POST \
--url https://{host}/activeviam/pivot/rest/v9/cube/query/mdx/queryplan \
--header 'Content-Type: application/json' \
--data '""'import requests
url = "https://{host}/activeviam/pivot/rest/v9/cube/query/mdx/queryplan"
headers = {"Content-Type": "application/json"}
response = requests.post(url, headers=headers)
print(response.text)const options = {method: 'POST', headers: {'Content-Type': 'application/json'}};
fetch('https://{host}/activeviam/pivot/rest/v9/cube/query/mdx/queryplan', 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/queryplan",
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"
],
]);
$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/queryplan"
payload := strings.NewReader("\"\"")
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("https://{host}/activeviam/pivot/rest/v9/cube/query/mdx/queryplan")
.header("Content-Type", "application/json")
.body("\"\"")
.asString();require 'uri'
require 'net/http'
url = URI("https://{host}/activeviam/pivot/rest/v9/cube/query/mdx/queryplan")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Post.new(url)
request["Content-Type"] = 'application/json'
request.body = "\"\""
response = http.request(request)
puts response.read_body""[
{
"aggregateRetrievals": [
{
"filterId": 123,
"horizontalDispatching": {
"dispatchingPerApplication": [
{
"applicationName": "<string>",
"dispatchingPerLevel": {}
}
]
},
"location": [
{
"dimension": "<string>",
"hierarchy": "<string>",
"level": [
"<string>"
],
"path": [
"<unknown>"
]
}
],
"measureProvider": "<string>",
"measures": [
"<string>"
],
"measuresData": [
{
"name": "<string>"
}
],
"partialProviderName": "<string>",
"partitioning": "<string>",
"resultSizes": [
123
],
"retrievalId": 123,
"timingInfo": {},
"type": "<string>",
"underlyingDataNodes": [
"<string>"
],
"underlyingRetrievalType": "<string>"
}
],
"databaseDependencies": {},
"databaseRetrievals": [
{
"condition": "<string>",
"fields": [
"<string>"
],
"joinedMeasure": [
"<string>"
],
"resultSizes": [
123
],
"retrievalId": 123,
"store": "<string>",
"timingInfo": {}
}
],
"dependencies": {},
"planInfo": "<unknown>",
"queryFilters": [
{
"description": "<string>",
"id": 123
}
],
"querySummary": {
"measures": [
"<string>"
],
"partialProviders": [
"<string>"
],
"partitioningCountByType": {},
"resultSizeByPartitioning": {},
"retrievalsCountByType": {},
"totalDatabaseResultSize": 123,
"totalRetrievals": 123
}
}
][
{
"aggregateRetrievals": [
{
"filterId": 123,
"horizontalDispatching": {
"dispatchingPerApplication": [
{
"applicationName": "<string>",
"dispatchingPerLevel": {}
}
]
},
"location": [
{
"dimension": "<string>",
"hierarchy": "<string>",
"level": [
"<string>"
],
"path": [
"<unknown>"
]
}
],
"measureProvider": "<string>",
"measures": [
"<string>"
],
"measuresData": [
{
"name": "<string>"
}
],
"partialProviderName": "<string>",
"partitioning": "<string>",
"resultSizes": [
123
],
"retrievalId": 123,
"timingInfo": {},
"type": "<string>",
"underlyingDataNodes": [
"<string>"
],
"underlyingRetrievalType": "<string>"
}
],
"databaseDependencies": {},
"databaseRetrievals": [
{
"condition": "<string>",
"fields": [
"<string>"
],
"joinedMeasure": [
"<string>"
],
"resultSizes": [
123
],
"retrievalId": 123,
"store": "<string>",
"timingInfo": {}
}
],
"dependencies": {},
"planInfo": "<unknown>",
"queryFilters": [
{
"description": "<string>",
"id": 123
}
],
"querySummary": {
"measures": [
"<string>"
],
"partialProviders": [
"<string>"
],
"partitioningCountByType": {},
"resultSizeByPartitioning": {},
"retrievalsCountByType": {},
"totalDatabaseResultSize": 123,
"totalRetrievals": 123
}
}
]Body
application/json
The MDX query for query plan inspection.
Response
The query plans resulting from the MDX SELECT query.
Was this page helpful?