Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

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

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


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

OLAP4j Use Cases supported in Kyvos


  • No labels