Examples of org.olap4j.layout.RectangularCellSetFormatter

org.olap4j.layout.RectangularCellSetFormatter

Formatter that can convert a {@link CellSet} into a two-dimensional textlayout.

With non-compact layout:

 | 1997                                                | | Q1                       | Q2                       | |                          | 4                        | | Unit Sales | Store Sales | Unit Sales | Store Sales | ----+----+---------+------------+-------------+------------+-------------+ USA | CA | Modesto |         12 |        34.5 |         13 |       35.60 | | WA | Seattle |         12 |        34.5 |         13 |       35.60 | | CA | Fresno  |         12 |        34.5 |         13 |       35.60 |

With compact layout:

 1997 Q1                     Q2 4 Unit Sales Store Sales Unit Sales Store Sales === == ======= ========== =========== ========== =========== USA CA Modesto         12        34.5         13       35.60 WA Seattle         12        34.5         13       35.60 CA Fresno          12        34.5         13       35.60

This class is experimental. It is not part of the olap4j specification and is subject to change without notice.

@author jhyde @version $Id: RectangularCellSetFormatter.java 367 2010-11-16 18:54:39Z jhyde $ @since Apr 15, 2009

            statement.executeOlapQuery(
                "SELECT {[store].[USA]} ON COLUMNS , {[Account].[1000]} ON ROWS\n"
                + "FROM [Budget]");


        // We use the utility formatter.
        RectangularCellSetFormatter formatter =
            new RectangularCellSetFormatter(false);


        // Print out.
        PrintWriter writer = new PrintWriter(System.out);
        formatter.format(cellSet, writer);
        writer.flush();


        statement.close();
        connection.close();
    }

View Full Code Here

        }


        // Now, nicely formatted.
        System.out.println();
        final PrintWriter pw = new PrintWriter(System.out);
        new RectangularCellSetFormatter(false).format(cellSet, pw);
        pw.flush();


        // Close the statement and connection.
        statement.close();
        connection.close();

View Full Code Here

        case TRADITIONAL:
            new TraditionalCellSetFormatter().format(cellSet, pw);
            break;
        case COMPACT_RECTANGULAR:
        case RECTANGULAR:
            new RectangularCellSetFormatter(
                format == Format.COMPACT_RECTANGULAR)
                .format(cellSet, pw);
            break;
        }
        pw.flush();

View Full Code Here

                queryString,
                new Util.Functor1<String, CellSet>() {
                    public String apply(CellSet param) {
                        StringWriter stringWriter = new StringWriter();
                        PrintWriter printWriter = new PrintWriter(stringWriter);
                        new RectangularCellSetFormatter(false)
                            .format(param, printWriter);
                        printWriter.flush();
                        return stringWriter.toString();
                    }
                });

View Full Code Here


        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();
        println(stringWriter);

View Full Code Here

                    strings[1] = String.valueOf(timing);
                }
            }
        );
        final CellSet cellSet = statement.executeOlapQuery(mdx);
        new RectangularCellSetFormatter(true).format(
            cellSet, new PrintWriter(new StringWriter()));
        cellSet.close();
        final String actual =
            strings[0].replaceAll(
                "callMillis=[0-9]+",

View Full Code Here

TOP

Related Classes of org.olap4j.layout.RectangularCellSetFormatter

mondrian.test.BasicQueryTest

mondrian.test.MonitorTest

mondrian.tui.CmdRunner

org.olap4j.CellSetFormatterTest

org.olap4j.impl.CoordinateIterator

org.olap4j.metadata.Member

org.olap4j.sample.PaloConnection

org.olap4j.sample.SimpleQuerySample

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.