""[
{
"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
/
v10
/
cube
/
query
/
mdx
/
queryplan
""[
{
"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?