List of parseSelect() Examples

Examples of parseSelect()

org.olap4j.mdx.parser.MdxParser.parseSelect()
Parses an MDX Select statement and returns the {@link SelectNode} at theroot of the parse tree.
In order to be parsed successfully, the expression must be syntactically correct but does not need to be valid. (Syntactic correctness and validity are described further in the description of {@link #parseExpression(String)}.) @param mdx MDX query string @return Parse tree
org.olap4j.mdx.parser.impl.DefaultMdxParserImpl.parseSelect()

Examples of org.olap4j.mdx.parser.MdxParser.parseSelect()

        String s,
        String expectedName)
    {
        MdxParser p = createParser();
        String q = "select [member] on " + s + " from [cube]";
        SelectNode selectNode = p.parseSelect(q);
        List<AxisNode> axes = selectNode.getAxisList();


        assertEquals("Number of axes must be 1", 1, axes.size());
        assertEquals(
            "Axis index name must be correct",

View Full Code Here

Examples of org.olap4j.mdx.parser.MdxParser.parseSelect()

        try {
            OlapConnection olapConnection = getOlapConnection();
            MdxParser mdxParser =
                olapConnection.getParserFactory()
                    .createMdxParser(olapConnection);
            final SelectNode query = mdxParser.parseSelect(queryString);
            String unparsedQueryString = TestContext.toString(query);
            TestContext.assertEqualsVerbose(expected, unparsedQueryString);
        } catch (SQLException e) {
            throw new RuntimeException("error during parse");
        }

View Full Code Here

Examples of org.olap4j.mdx.parser.MdxParser.parseSelect()

    public void testMultipleAxes() throws Exception {
        MdxParser p = createParser();
        String query = "select {[axis0mbr]} on axis(0), "
                + "{[axis1mbr]} on axis(1) from cube";


        SelectNode select = p.parseSelect(query);
        assertNotNull(select);


        List<AxisNode> axes = select.getAxisList();


        assertEquals("Number of axes", 2, axes.size());

View Full Code Here

Examples of org.olap4j.mdx.parser.MdxParser.parseSelect()

        // now a similar query with axes reversed


        query = "select {[axis1mbr]} on aXiS(1), "
                + "{[axis0mbr]} on AxIs(0) from cube";


        select = p.parseSelect(query);
        axes = select.getAxisList();


        assertEquals("Number of axes", 2, axes.size());
        assertEquals(
            "Axis index name must be correct",

View Full Code Here

Examples of org.olap4j.mdx.parser.MdxParser.parseSelect()

        final String mdx = "[Foo].&Key1&Key2.&[Key3]&Key4&[5]";
        assertParseExpr(mdx, mdx);


        MdxParser p = createParser();
        final String mdxQuery = wrapExpr(mdx);
        final SelectNode selectNode = p.parseSelect(mdxQuery);
        assertEquals(1, selectNode.getWithList().size());
        WithMemberNode withMember =
            (WithMemberNode) selectNode.getWithList().get(0);
        final ParseTreeNode expr = withMember.getExpression();
        IdentifierNode id = (IdentifierNode) expr;

View Full Code Here

Examples of org.olap4j.mdx.parser.MdxParser.parseSelect()

    public void _testCloneQuery() throws SQLException {
        OlapConnection olapConnection = getOlapConnection();
        MdxParser mdxParser =
            olapConnection.getParserFactory()
                .createMdxParser(olapConnection);
        final SelectNode query = mdxParser.parseSelect(
            "select {[Measures].Members} on columns,\n"
            + " {[Store].Members} on rows\n"
            + "from [Sales]\n"
            + "where ([Gender].[M])");

View Full Code Here

Examples of org.olap4j.mdx.parser.MdxParser.parseSelect()

     * @param mdx MDX query
     * @param expected Expected result of unparsing
     */
    private void assertParseQuery(String mdx, final String expected) {
        MdxParser p = createParser();
        final SelectNode selectNode = p.parseSelect(mdx);
        final String actual = TestContext.toString(selectNode);
        TestContext.assertEqualsVerbose(expected, actual);
    }


    /**

View Full Code Here

Examples of org.olap4j.mdx.parser.MdxParser.parseSelect()

     * @param expected Expected result of unparsing
     */
    private void assertParseExpr(String expr, final String expected) {
        MdxParser p = createParser();
        final String mdx = wrapExpr(expr);
        final SelectNode selectNode = p.parseSelect(mdx);
        assertEquals(1, selectNode.getWithList().size());
        WithMemberNode withMember =
            (WithMemberNode) selectNode.getWithList().get(0);
        final String actual = TestContext.toString(withMember.getExpression());
        TestContext.assertEqualsVerbose(expected, actual);

View Full Code Here

Examples of org.olap4j.mdx.parser.MdxParser.parseSelect()

            + "SELECT\n"
            + "{[Measures].[Sales]} ON COLUMNS\n"
            + "FROM [cube]\n"
            + "WHERE ([CustomerDim].[CustomerName].[XL_QZX])";
        final MdxParser parser = new DefaultMdxParserImpl();
        SelectNode rootNode = parser.parseSelect(query);
        TestContext.assertEqualsVerbose(
            "WITH\n"
            + "MEMBER [CustomerDim].[CustomerName].[XL_QZX] AS\n"
            + "    Aggregate({[CustomerDim].[CustomerName].&[ABC INT'L], [CustomerDim].[CustomerName].&[XYZ]})\n"
            + "SELECT\n"

View Full Code Here

Examples of org.olap4j.mdx.parser.MdxParser.parseSelect()


        // Now named set
        query =
            "WITH SET Foo as Filter(Bar.Members, Instr(Name, \"'\") > 0)\n"
            + "SELECT FROM [Cube]";
        rootNode = parser.parseSelect(query);
        TestContext.assertEqualsVerbose(
            "WITH\n"
            + "SET Foo AS\n"
            + "    Filter(Bar.Members, (Instr(Name, \"'\") > 0))\n"
            + "SELECT\n"

View Full Code Here

0 1

TOP

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.