Executes an MDX definition statement.
curl --request POST \
--url http://localhost:9090/activeviam/pivot/rest/v10/cube/configuration/execute \
--header 'Content-Type: application/json' \
--data '
{
"owner": [
"<string>"
],
"owners": [
"<string>"
],
"reader": [
"<string>"
],
"readers": [
"<string>"
],
"statement": "<string>"
}
'import requests
url = "http://localhost:9090/activeviam/pivot/rest/v10/cube/configuration/execute"
payload = {
"owner": ["<string>"],
"owners": ["<string>"],
"reader": ["<string>"],
"readers": ["<string>"],
"statement": "<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({
owner: ['<string>'],
owners: ['<string>'],
reader: ['<string>'],
readers: ['<string>'],
statement: '<string>'
})
};
fetch('http://localhost:9090/activeviam/pivot/rest/v10/cube/configuration/execute', 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/configuration/execute",
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([
'owner' => [
'<string>'
],
'owners' => [
'<string>'
],
'reader' => [
'<string>'
],
'readers' => [
'<string>'
],
'statement' => '<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/configuration/execute"
payload := strings.NewReader("{\n \"owner\": [\n \"<string>\"\n ],\n \"owners\": [\n \"<string>\"\n ],\n \"reader\": [\n \"<string>\"\n ],\n \"readers\": [\n \"<string>\"\n ],\n \"statement\": \"<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/configuration/execute")
.header("Content-Type", "application/json")
.body("{\n \"owner\": [\n \"<string>\"\n ],\n \"owners\": [\n \"<string>\"\n ],\n \"reader\": [\n \"<string>\"\n ],\n \"readers\": [\n \"<string>\"\n ],\n \"statement\": \"<string>\"\n}")
.asString();require 'uri'
require 'net/http'
url = URI("http://localhost:9090/activeviam/pivot/rest/v10/cube/configuration/execute")
http = Net::HTTP.new(url.host, url.port)
request = Net::HTTP::Post.new(url)
request["Content-Type"] = 'application/json'
request.body = "{\n \"owner\": [\n \"<string>\"\n ],\n \"owners\": [\n \"<string>\"\n ],\n \"reader\": [\n \"<string>\"\n ],\n \"readers\": [\n \"<string>\"\n ],\n \"statement\": \"<string>\"\n}"
response = http.request(request)
puts response.read_bodyExecutes an MDX definition statement.
The statement itself defines on which ActivePivot instance it applies. There are various types of statements that are supported by the API. The full list and examples are provided by this documentation page.
POST
/
activeviam
/
pivot
/
rest
/
v10
/
cube
/
configuration
/
execute
Executes an MDX definition statement.
curl --request POST \
--url http://localhost:9090/activeviam/pivot/rest/v10/cube/configuration/execute \
--header 'Content-Type: application/json' \
--data '
{
"owner": [
"<string>"
],
"owners": [
"<string>"
],
"reader": [
"<string>"
],
"readers": [
"<string>"
],
"statement": "<string>"
}
'import requests
url = "http://localhost:9090/activeviam/pivot/rest/v10/cube/configuration/execute"
payload = {
"owner": ["<string>"],
"owners": ["<string>"],
"reader": ["<string>"],
"readers": ["<string>"],
"statement": "<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({
owner: ['<string>'],
owners: ['<string>'],
reader: ['<string>'],
readers: ['<string>'],
statement: '<string>'
})
};
fetch('http://localhost:9090/activeviam/pivot/rest/v10/cube/configuration/execute', 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/configuration/execute",
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([
'owner' => [
'<string>'
],
'owners' => [
'<string>'
],
'reader' => [
'<string>'
],
'readers' => [
'<string>'
],
'statement' => '<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/configuration/execute"
payload := strings.NewReader("{\n \"owner\": [\n \"<string>\"\n ],\n \"owners\": [\n \"<string>\"\n ],\n \"reader\": [\n \"<string>\"\n ],\n \"readers\": [\n \"<string>\"\n ],\n \"statement\": \"<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/configuration/execute")
.header("Content-Type", "application/json")
.body("{\n \"owner\": [\n \"<string>\"\n ],\n \"owners\": [\n \"<string>\"\n ],\n \"reader\": [\n \"<string>\"\n ],\n \"readers\": [\n \"<string>\"\n ],\n \"statement\": \"<string>\"\n}")
.asString();require 'uri'
require 'net/http'
url = URI("http://localhost:9090/activeviam/pivot/rest/v10/cube/configuration/execute")
http = Net::HTTP.new(url.host, url.port)
request = Net::HTTP::Post.new(url)
request["Content-Type"] = 'application/json'
request.body = "{\n \"owner\": [\n \"<string>\"\n ],\n \"owners\": [\n \"<string>\"\n ],\n \"reader\": [\n \"<string>\"\n ],\n \"readers\": [\n \"<string>\"\n ],\n \"statement\": \"<string>\"\n}"
response = http.request(request)
puts response.read_bodyWas this page helpful?
Gets all defined editable calculated members defined in a given ActivePivot.
Previous
Gets all defined editable KPIs defined in a given ActivePivot.
Next
⌘I