> ## Documentation Index
> Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Execute XMLA request

> Processes XMLA (XML for Analysis) requests for MDX query execution and OLAP metadata discovery.

This endpoint handles two types of XMLA operations:
- **Execute**: Runs MDX queries against the OLAP cubes and returns cell data
- **Discover**: Retrieves metadata about available cubes, dimensions, hierarchies, measures, etc.

The request body must be a valid XMLA SOAP envelope. The response format depends on
content negotiation headers and can be returned as:
- Standard XML (text/xml or application/xml)
- Binary XML (for improved performance with compatible clients)
- Compressed responses (when supported by the client)

Session management is supported through XMLA session headers for maintaining context
across multiple requests.




## OpenAPI

````yaml post /xmla
openapi: 3.0.0
info:
  title: Atoti REST services
  version: 6.1.18-SNAPSHOT
servers:
  - description: Generated server url
    url: http://localhost:9090
security: []
tags:
  - description: Implementation of the REST API controller for an ActivePivot database.
    name: Database REST API
  - description: >
      XML for Analysis (XMLA) endpoint for executing MDX queries and OLAP
      discovery operations.


      This endpoint implements the XMLA protocol which is used by:

      - Microsoft Excel and other OLAP clients

      - Custom BI tools that support XMLA connectivity


      The endpoint supports both text XML and binary XML formats for improved
      performance.
    name: XMLA API
  - description: Definition of REST API to query data from ActivePivot (V10).
    name: Query REST API (V10)
  - description: Definition of REST API to query data from ActivePivot (V9).
    name: Query REST API (V9)
  - description: Implementation of the REST Bulk API of the content server (version 8).
    name: Bulk REST API
  - description: Implementation of the REST API of the content server.
    name: Content Server REST API
  - description: Implementation of the REST API controller for an ActivePivot database.
    name: Database REST API v9
  - description: ' Definition of the REST service returning the list of services exposed by an application.'
    name: Version REST API
  - description: Rest Service providing the discovery information.
    name: Discovery REST API
  - description: API to access measures information.
    name: Diagnostics API
  - description: JSON Web Token (JWT) endpoint.
    name: JWT API
  - description: >
      Endpoints to retrieve and manage query history.


      **Note:** This API is experimental and may change in future versions
      without notice.
    name: Query History REST API (Experimental)
  - description: Description of REST API to configure an ActivePivot application.
    name: Configuration REST API
  - description: API to export the result of MDX queries
    name: Data Export
  - description: >
      GetAggregatesQuery (GAQ) REST API for executing OLAP queries.


      This API provides a programmatic way to execute GetAggregatesQuery
      operations

      against Atoti cubes. Results and updates are streamed in Apache Arrow
      format for efficient

      data transfer and processing.
    name: Continuous GAQ Query REST API (Experimental)
  - description: Endpoints for AI-based optimization of Atoti cubes
    name: AI Optimizer
  - description: >
      GetAggregatesQuery (GAQ) REST API for executing OLAP queries.


      This API provides a programmatic way to execute GetAggregatesQuery
      operations

      against Atoti cubes. Results are returned in Apache Arrow format for
      efficient

      data transfer and processing.


      **Note:** This API is experimental and may change in future versions
      without notice.
    name: GAQ Query REST API (Experimental)
  - description: Implementation of the REST Bulk API of the content server.
    name: Bulk REST API
paths:
  /xmla:
    post:
      tags:
        - XMLA API
      summary: Execute XMLA request
      description: >
        Processes XMLA (XML for Analysis) requests for MDX query execution and
        OLAP metadata discovery.


        This endpoint handles two types of XMLA operations:

        - **Execute**: Runs MDX queries against the OLAP cubes and returns cell
        data

        - **Discover**: Retrieves metadata about available cubes, dimensions,
        hierarchies, measures, etc.


        The request body must be a valid XMLA SOAP envelope. The response format
        depends on

        content negotiation headers and can be returned as:

        - Standard XML (text/xml or application/xml)

        - Binary XML (for improved performance with compatible clients)

        - Compressed responses (when supported by the client)


        Session management is supported through XMLA session headers for
        maintaining context

        across multiple requests.
      operationId: doPost
      responses:
        '200':
          content:
            text/xml:
              schema:
                type: string
          description: XMLA response with query results or metadata
        '400':
          content:
            '*/*':
              schema:
                $ref: '#/components/schemas/StreamingResponseBody'
          description: Invalid XMLA request - malformed XML or unsupported operation
        '401':
          content:
            '*/*':
              schema:
                $ref: '#/components/schemas/StreamingResponseBody'
          description: Authentication required
        '500':
          content:
            '*/*':
              schema:
                $ref: '#/components/schemas/StreamingResponseBody'
          description: Internal server error during XMLA processing
components:
  schemas:
    StreamingResponseBody:
      type: object

````