Page Comparison

Applies to:Image RemovedKyvos Enterprise Image RemovedKyvos Cloud (Managed Services on AWS) Image RemovedKyvos Azure Marketplace

Image RemovedKyvos AWS Marketplace Image RemovedKyvos Single Node Installation (Kyvos SNI) Image RemovedKyvos Free (Limited offering for AWS)

OLAP4j integration architecture 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. Image Removed

...

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.

These jar files are included in the Kyvos installation. You can find the files at <Kyvos_Web_App_path>\WEB-INF\lib location.

You can view the Java reference document for OLAP4j APIs at http://www.olap4j.org/api/index.html

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

Child pages (Children Display)