Document toolboxDocument toolbox

OLAP4j

Owned by Sarabjeet Kaur
Oct 09, 2024
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 semantic models.  

OLAP4j API  

Kyvos provides the capability to connect using the OLAP4j APIs to browse semantic model 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: Olap4j Jar is located at <Kyvos_Installation_Path>\olapengine\lib

  • Following dependent Jars for Olap4j are located at <Kyvos_Installation_Path>\jakarta\webapps\kyvos\WEB-INF\lib

    • xercesImpl-2.9.1.jar 

    • xml-apis-1.4.01.jar

These jar files are included in the Kyvos installation.

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.