Document toolboxDocument toolbox

OLAP4j

Owned by Sarabjeet Kaur
Dec 05, 2023
1 min read

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

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(),

OLAP4j Use Cases supported in Kyvos



Copyright Kyvos, Inc. All rights reserved.