Examples of org.olap4j.CellSet

org.olap4j.CellSet

Result of executing an OLAP Statement.

A CellSet consists of a set of (typically two) axes, each populated with a sequence of members, and a collection of cells at the intersection of these axes.

Cell ordinals and coordinates

There are two ways to identify a particular cell: ordinal and coordinates. Suppose that there are p axes, and each axis k (k between 0 and p - 1) has U_k positions. There are U = U₀ * ... * U_{p - 1} cells in total. Then:

A cell's ordinal is an integer between 0 and U - 1.
A cell's coordinates are a list of p integers, indicating the cell's position on each axis. Each integer is between 0 and U_p-1.

The ordinal number of a cell whose tuple ordinals are (S₀, S₁, ... S_p-1) is

Σ_i=0^p-1 S_i . E_i where E₀ = 1 and E_i = Π_i=0^p-1 U_k

@author jhyde @version $Id: CellSet.java 368 2010-11-16 21:37:12Z jhyde $ @since Aug 22, 2006

            + "from [Sales]\n"
            + "where [Time].[1997].[Q3].[9]";


        final OlapStatement statement1 =
            getTestContext().getOlap4jConnection().createStatement();
        CellSet cellSet = statement1.executeOlapQuery(queryString);
        StringWriter stringWriter = new StringWriter();
        new RectangularCellSetFormatter(true).format(
            cellSet,
            new PrintWriter(stringWriter));
        statement1.close();

Examples of org.olap4j.CellSet

Related Classes of org.olap4j.CellSet