Querying ActivePivot : Overview
The data can be queried in the ActivePivot cube, but also in the datastore. There exists both programmatic querying capabilities for usage in the same JVM that runs ActivePivot, or remote querying via the REST APIs or Websocket API. Compatibility with external UIs, such as Excel, is provided using the XMLA Servlet.