Applies to: 
Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace
Kyvos Azure Marketplace Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)
OLAP4j integration architecture
The following figure illustrates OLAP4j integration architecture.
The architecture consists of the following components.
Host Application: The Java-enabled application into which Kyvos data is queried using OLAP4j APIs.
OLAP4j Driver for XMLA Component: Jar files to be included in the classpath of the host application.
Kyvos Cluster: One or more computers on which the Kyvos software is running. Generally, this cluster is deployed on Hadoop cluster computers. One of these computers deploys the Kyvos BI Server, which acts as a communication point for the client APIs. You may need the IP address or name of that computers to configure the APIs.
APIs: The APIs provided by OLAP4j for querying data and metadata from cubes.
OLAP4j API
Kyvos provides the capability to connect using the OLAP4j APIs to browse cube data. You must specify an MDX query.
To use the OLAP4j APIs with Kyvos, include the following jar files in the classpath of the host application.
olap4j-1.1.jar
xercesImpl-2.9.1.jar
These jar files are included in the Kyvos installation. You can find the files at <Kyvos_Web_App_path>\WEB-INF\lib location.
Java reference document
You can view the Java reference document for OLAP4j APIs at http://www.olap4j.org/api/index.html
Kyvos supported OLAP4j methods
Class | Methods |
|---|---|
org.olap4j.Cell; | getValue(),getDoubleValue(),getFormattedValue(),getPropertyValue() |
org.olap4j.CellSet; | getAxes(),getCell(), |
org.olap4j.CellSetAxis; | getPositions(),getAxisMetaData() |
org.olap4j.impl.CoordinateIterator; | hasNext(), next(),iterate() |
org.olap4j.impl.Olap4jUtil; | parseFormattedCellValue(),equal(), |
org.olap4j.metadata.Cube; | getDimensions(), |
org.olap4j.metadata.Dimension; | getName(),getDimensionType(),getHierarchies(),getUniqueName() |
org.olap4j.metadata.Hierarchy; | getUniqueName(),getLevels(),getCaption(),getName() |
org.olap4j.metadata.Level; | getMembers(),getCaption(),getHierarchy(),getUniqueName(), |
org.olap4j.metadata.Member; | getName(),getUniqueName(),getDepth(),.getLevel(),getDimension(),.getHierarchy(),getParentMember(),getCaption(), |
org.olap4j.OlapConnection; | getOlapSchema().getCubes(),isClosed(),createStatement(), |
org.olap4j.OlapStatement; | executeOlapQuery() |
org.olap4j.Position; | getMembers(), |