curl --request POST \
--url http://localhost:9090/activeviam/pivot/rest/v10/cube/query/gaq \
--header 'Content-Type: application/json' \
--data '
{
"cubeName": "<string>",
"measures": [
"<string>"
],
"branch": "<string>",
"context": {},
"coordinates": {},
"filter": {
"isInConditions": {
"values": {}
},
"notInConditions": {
"values": {}
}
},
"timeout": 123
}
'import requests
url = "http://localhost:9090/activeviam/pivot/rest/v10/cube/query/gaq"
payload = {
"cubeName": "<string>",
"measures": ["<string>"],
"branch": "<string>",
"context": {},
"coordinates": {},
"filter": {
"isInConditions": { "values": {} },
"notInConditions": { "values": {} }
},
"timeout": 123
}
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({
cubeName: '<string>',
measures: ['<string>'],
branch: '<string>',
context: {},
coordinates: {},
filter: {isInConditions: {values: {}}, notInConditions: {values: {}}},
timeout: 123
})
};
fetch('http://localhost:9090/activeviam/pivot/rest/v10/cube/query/gaq', 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/gaq",
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([
'cubeName' => '<string>',
'measures' => [
'<string>'
],
'branch' => '<string>',
'context' => [
],
'coordinates' => [
],
'filter' => [
'isInConditions' => [
'values' => [
]
],
'notInConditions' => [
'values' => [
]
]
],
'timeout' => 123
]),
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/gaq"
payload := strings.NewReader("{\n \"cubeName\": \"<string>\",\n \"measures\": [\n \"<string>\"\n ],\n \"branch\": \"<string>\",\n \"context\": {},\n \"coordinates\": {},\n \"filter\": {\n \"isInConditions\": {\n \"values\": {}\n },\n \"notInConditions\": {\n \"values\": {}\n }\n },\n \"timeout\": 123\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/gaq")
.header("Content-Type", "application/json")
.body("{\n \"cubeName\": \"<string>\",\n \"measures\": [\n \"<string>\"\n ],\n \"branch\": \"<string>\",\n \"context\": {},\n \"coordinates\": {},\n \"filter\": {\n \"isInConditions\": {\n \"values\": {}\n },\n \"notInConditions\": {\n \"values\": {}\n }\n },\n \"timeout\": 123\n}")
.asString();require 'uri'
require 'net/http'
url = URI("http://localhost:9090/activeviam/pivot/rest/v10/cube/query/gaq")
http = Net::HTTP.new(url.host, url.port)
request = Net::HTTP::Post.new(url)
request["Content-Type"] = 'application/json'
request.body = "{\n \"cubeName\": \"<string>\",\n \"measures\": [\n \"<string>\"\n ],\n \"branch\": \"<string>\",\n \"context\": {},\n \"coordinates\": {},\n \"filter\": {\n \"isInConditions\": {\n \"values\": {}\n },\n \"notInConditions\": {\n \"values\": {}\n }\n },\n \"timeout\": 123\n}"
response = http.request(request)
puts response.read_bodyExecutes a GAQ and returns the result as an Arrow stream.
Executes a GAQ on the specified cube and branch, with given measures, coordinates, filters, context, and timeout. The result is returned as an Apache Arrow stream.
curl --request POST \
--url http://localhost:9090/activeviam/pivot/rest/v10/cube/query/gaq \
--header 'Content-Type: application/json' \
--data '
{
"cubeName": "<string>",
"measures": [
"<string>"
],
"branch": "<string>",
"context": {},
"coordinates": {},
"filter": {
"isInConditions": {
"values": {}
},
"notInConditions": {
"values": {}
}
},
"timeout": 123
}
'import requests
url = "http://localhost:9090/activeviam/pivot/rest/v10/cube/query/gaq"
payload = {
"cubeName": "<string>",
"measures": ["<string>"],
"branch": "<string>",
"context": {},
"coordinates": {},
"filter": {
"isInConditions": { "values": {} },
"notInConditions": { "values": {} }
},
"timeout": 123
}
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({
cubeName: '<string>',
measures: ['<string>'],
branch: '<string>',
context: {},
coordinates: {},
filter: {isInConditions: {values: {}}, notInConditions: {values: {}}},
timeout: 123
})
};
fetch('http://localhost:9090/activeviam/pivot/rest/v10/cube/query/gaq', 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/gaq",
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([
'cubeName' => '<string>',
'measures' => [
'<string>'
],
'branch' => '<string>',
'context' => [
],
'coordinates' => [
],
'filter' => [
'isInConditions' => [
'values' => [
]
],
'notInConditions' => [
'values' => [
]
]
],
'timeout' => 123
]),
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/gaq"
payload := strings.NewReader("{\n \"cubeName\": \"<string>\",\n \"measures\": [\n \"<string>\"\n ],\n \"branch\": \"<string>\",\n \"context\": {},\n \"coordinates\": {},\n \"filter\": {\n \"isInConditions\": {\n \"values\": {}\n },\n \"notInConditions\": {\n \"values\": {}\n }\n },\n \"timeout\": 123\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/gaq")
.header("Content-Type", "application/json")
.body("{\n \"cubeName\": \"<string>\",\n \"measures\": [\n \"<string>\"\n ],\n \"branch\": \"<string>\",\n \"context\": {},\n \"coordinates\": {},\n \"filter\": {\n \"isInConditions\": {\n \"values\": {}\n },\n \"notInConditions\": {\n \"values\": {}\n }\n },\n \"timeout\": 123\n}")
.asString();require 'uri'
require 'net/http'
url = URI("http://localhost:9090/activeviam/pivot/rest/v10/cube/query/gaq")
http = Net::HTTP.new(url.host, url.port)
request = Net::HTTP::Post.new(url)
request["Content-Type"] = 'application/json'
request.body = "{\n \"cubeName\": \"<string>\",\n \"measures\": [\n \"<string>\"\n ],\n \"branch\": \"<string>\",\n \"context\": {},\n \"coordinates\": {},\n \"filter\": {\n \"isInConditions\": {\n \"values\": {}\n },\n \"notInConditions\": {\n \"values\": {}\n }\n },\n \"timeout\": 123\n}"
response = http.request(request)
puts response.read_bodyBody
The name of the cube to query.
The list of measures to include in the query.
The specific branch of the cube to query. By default, the branch set by activeviam.branch.master property.
Additional context values to configure query execution. Supported context values include:
queriesTimeLimit: Query timeout in seconds (e.g., "30")queriesResultLimit: Maximum number of cells to return (e.g., "10000")
Context values are applied during query execution and reset after the query completes.
Show child attributes
Show child attributes
The coordinates for the query, mapping level descriptions to level members.
Use null or the wildcard string as the value to express a wildcard (all members) for a given level. The wildcard string defaults to [*] and can be configured via the activepivot.location.wildcard system property. For example: {"Currency@Currency@Currency": ["[*]"]}.
Show child attributes
Show child attributes
Filter conditions to apply to the query.
Show child attributes
Show child attributes
The timeout for the query in seconds.
Response
Successful execution of the GAQ.
Was this page helpful?