Examples of org.olap4j.mdx.SelectNode

org.olap4j.mdx.SelectNode
Parse tree model for an MDX SELECT statement. @author jhyde @version $Id: SelectNode.java 333 2010-07-30 00:43:55Z jhyde $ @since Jun 4, 2007

    }


    public SelectNode apply(SelectNode sn) {
        // do a deep copy of the existing query SelectNode before
        // modifying it:
        SelectNode newSelectNode = sn.deepCopy();


        for (AxisNode an : newSelectNode.getAxisList()) {
            if (an.getAxis() == axis) {
                // this is the axis we're drilling


                ParseTreeNode initialAxisExp = an.getExpression();

View Full Code Here

     * @throws OlapException If something goes sour, an OlapException will
     *     be thrown to the caller. It could be caused by many things, like
     *     a stale connection. Look at the root cause for more details.
     */
    public CellSet execute() throws OlapException {
        SelectNode mdx = getSelect();
        final Catalog catalog = cube.getSchema().getCatalog();
        try {
            this.connection.setCatalog(catalog.getName());
        } catch (SQLException e) {
            throw new OlapException("Error while executing query", e);

View Full Code Here

            final QueryAxis axis = query.getAxes().get(Axis.FILTER);
            if (!axis.dimensions.isEmpty()) {
                filterAxis = toOlap4j(axis);
            }
        }
        return new SelectNode(
            null,
            withList,
            toOlap4j(axisList),
            new CubeNode(
                null,

View Full Code Here

            query.getAxis(Axis.ROWS).addDimension(productDimension);
            query.getAxis(Axis.COLUMNS).addDimension(measuresDimension);


            query.validate();


            SelectNode mdx = query.getSelect();
            String mdxString = mdx.toString();
            TestContext.assertEqualsVerbose(
                "SELECT\n"
                + "{[Measures].[Store Sales]} ON COLUMNS,\n"
                + "{[Product].[Drink].Children} ON ROWS\n"
                + "FROM [Sales]",
                mdxString);


            // TEST ANCESTORS SELECTION


            productDimension.clearInclusions();
            productDimension.include(
                Selection.Operator.ANCESTORS, nameList("Product", "Drink"));


            query.validate();


            mdx = query.getSelect();
            mdxString = mdx.toString();
            TestContext.assertEqualsVerbose(
                "SELECT\n"
                + "{[Measures].[Store Sales]} ON COLUMNS,\n"
                + "{Ascendants([Product].[Drink])} ON ROWS\n"
                + "FROM [Sales]",
                mdxString);


            // TEST DESCENDANTS SELECTION


            productDimension.clearInclusions();
            productDimension.include(
                Selection.Operator.DESCENDANTS, nameList("Product", "Drink"));


            query.validate();


            mdx = query.getSelect();
            mdxString = mdx.toString();
            TestContext.assertEqualsVerbose(
                "SELECT\n"
                + "{[Measures].[Store Sales]} ON COLUMNS,\n"
                + "{Descendants([Product].[Drink])} ON ROWS\n"
                + "FROM [Sales]",
                mdxString);


            // TEST INCLUDE_CHILDREN SELECTION


            productDimension.clearInclusions();
            productDimension.include(
                Selection.Operator.INCLUDE_CHILDREN,
                nameList("Product", "Drink"));


            query.validate();


            mdx = query.getSelect();
            mdxString = mdx.toString();
            TestContext.assertEqualsVerbose(
                "SELECT\n"
                + "{[Measures].[Store Sales]} ON COLUMNS,\n"
                + "{{[Product].[Drink], [Product].[Drink].Children}} ON ROWS\n"
                + "FROM [Sales]",
                mdxString);


            // TEST SIBLINGS SELECTION


            productDimension.clearInclusions();
            productDimension.include(
                Selection.Operator.SIBLINGS, nameList("Product", "Drink"));


            query.validate();


            mdx = query.getSelect();
            mdxString = mdx.toString();
            TestContext.assertEqualsVerbose(
                "SELECT\n"
                + "{[Measures].[Store Sales]} ON COLUMNS,\n"
                + "{[Product].[Drink].Siblings} ON ROWS\n"
                + "FROM [Sales]",
                mdxString);


            // TEST LEVEL MEMBERS SELECTION


            NamedList<Level> productLevels =
             productDimension.getDimension().getDefaultHierarchy().getLevels();


            Level productDepartments = productLevels.get("Product Department");
            productDimension.include(productDepartments);
            query.validate();


            mdx = query.getSelect();
            mdxString = mdx.toString();
            TestContext.assertEqualsVerbose(
                    "SELECT\n"
                    + "{[Measures].[Store Sales]} ON COLUMNS,\n"
                    + "{[Product].[Drink].Siblings, [Product].[Product Department].Members} ON ROWS\n"
                    + "FROM [Sales]", mdxString);

View Full Code Here

            query.getAxis(Axis.ROWS).addDimension(timeDimension);
            query.getAxis(Axis.COLUMNS).addDimension(measuresDimension);


            query.validate();


            SelectNode mdx = query.getSelect();
            String mdxString = mdx.toString();
            TestContext.assertEqualsVerbose(
                "SELECT\n"
                + "{[Measures].[Store Sales]} ON COLUMNS,\n"
                + "CrossJoin([Product].[Drink].Children, "
                + "CrossJoin({[Store].[USA], "

View Full Code Here

                productDimension.getAxis().getLocation());
            assertEquals(
                Axis.COLUMNS,
                measuresDimension.getAxis().getLocation());


            SelectNode mdx = query.getSelect();
            String mdxString = mdx.toString();
            TestContext.assertEqualsVerbose(
                "SELECT\n"
                + "{[Measures].[Store Sales]} ON COLUMNS,\n"
                + "{[Product].[Drink].Children} ON ROWS\n"
                + "FROM [Sales]",
                mdxString);


            query.swapAxes();


            assertEquals(
                Axis.COLUMNS,
                productDimension.getAxis().getLocation());
            assertEquals(
                Axis.ROWS,
                measuresDimension.getAxis().getLocation());


            mdx = query.getSelect();
            mdxString = mdx.toString();
            TestContext.assertEqualsVerbose(
                "SELECT\n"
                + "{[Product].[Drink].Children} ON COLUMNS,\n"
                + "{[Measures].[Store Sales]} ON ROWS\n"
                + "FROM [Sales]",

View Full Code Here

                productDimension.getAxis().getLocation());
            assertEquals(
                Axis.COLUMNS,
                measuresDimension.getAxis().getLocation());


            SelectNode mdx = query.getSelect();
            String mdxString = mdx.toString();
            TestContext.assertEqualsVerbose(
                "SELECT\n"
                + "{[Measures].[Store Sales]} ON COLUMNS,\n"
                + "{{[Product].[Drink], [Product].[Drink].Children}} ON ROWS\n"
                + "FROM [Sales]\n"
                + "WHERE {[Time].[1997].[Q3].[7]}",
                mdxString);


            // Sort the products in ascending order.
            query.getDimension("Product").sort(SortOrder.DESC);


            SelectNode sortedMdx = query.getSelect();
            String sortedMdxString = sortedMdx.toString();
            TestContext.assertEqualsVerbose(
                "SELECT\n"
                + "{[Measures].[Store Sales]} ON COLUMNS,\n"
                + "{Order({{[Product].[Drink], [Product].[Drink].Children}}, [Product].CurrentMember.Name, DESC)} ON ROWS\n"
                + "FROM [Sales]\n"

View Full Code Here

                productDimension.getAxis().getLocation());
            assertEquals(
                Axis.COLUMNS,
                measuresDimension.getAxis().getLocation());


            SelectNode mdx = query.getSelect();
            String mdxString = mdx.toString();
            TestContext.assertEqualsVerbose(
                "SELECT\n"
                + "{[Measures].[Store Sales]} ON COLUMNS,\n"
                + "CrossJoin({[Time].[1997].[Q3].[7]}, [Product].[Drink].Children) ON ROWS\n"
                + "FROM [Sales]",
                mdxString);


            // Sort the products in ascending order.
            query.getDimension("Product").sort(SortOrder.DESC);


            SelectNode sortedMdx = query.getSelect();
            String sortedMdxString = sortedMdx.toString();
            TestContext.assertEqualsVerbose(
                "SELECT\n"
                + "{[Measures].[Store Sales]} ON COLUMNS,\n"
                + "CrossJoin({[Time].[1997].[Q3].[7]}, Order({[Product].[Drink].Children}, [Product].CurrentMember.Name, DESC)) ON ROWS\n"
                + "FROM [Sales]",
                sortedMdxString);


            CellSet results = query.execute();
            String s = TestContext.toString(results);
            TestContext.assertEqualsVerbose(
                "Axis #0:\n"
                + "{}\n"
                + "Axis #1:\n"
                + "{[Measures].[Store Sales]}\n"
                + "Axis #2:\n"
                + "{[Time].[1997].[Q3].[7], [Product].[Drink].[Dairy]}\n"
                + "{[Time].[1997].[Q3].[7], [Product].[Drink].[Beverages]}\n"
                + "{[Time].[1997].[Q3].[7], [Product].[Drink].[Alcoholic Beverages]}\n"
                + "Row #0: 629.69\n"
                + "Row #1: 2,477.02\n"
                + "Row #2: 1,302.87\n",
                s);


            // Just to be sure we execute the sort on a NON EMPTY axis again
            query.getAxis(Axis.ROWS).setNonEmpty(true);
            productDimension.clearInclusions();
            productDimension.include(
                Selection.Operator.CHILDREN, nameList("Product", "Food"));


            SelectNode sortedMdxNonEmpty = query.getSelect();
            String sortedMdxNonEmptyString = sortedMdxNonEmpty.toString();
            TestContext.assertEqualsVerbose(
                "SELECT\n"
                + "{[Measures].[Store Sales]} ON COLUMNS,\n"
                + "NON EMPTY CrossJoin({[Time].[1997].[Q3].[7]}, Order({[Product].[Food].Children}, [Product].CurrentMember.Name, DESC)) ON ROWS\n"
                + "FROM [Sales]",

View Full Code Here

            productDimension.getAxis().getLocation());
        assertEquals(
            Axis.COLUMNS,
            measuresDimension.getAxis().getLocation());


        SelectNode mdx = query.getSelect();
        String mdxString = mdx.toString();
        TestContext.assertEqualsVerbose(
            "SELECT\n"
            + "{[Measures].[Store Sales]} ON COLUMNS,\n"
            + "Hierarchize(Union(CrossJoin({[Product].[All Products], [Product].[All Products].Children}, CrossJoin({[Time].[1997]}, {[Store].[All Stores]})), Union(CrossJoin({[Product].[Drink]}, CrossJoin({[Time].[1997].[Q3]}, [Store].[All Stores].Children)), CrossJoin({[Product].[Drink]}, CrossJoin([Time].[1997].Children, {[Store].[All Stores]}))))) ON ROWS\n"
            + "FROM [Sales]",
            mdxString);


        // Sort the rows in ascending order.
        query.getAxis(Axis.ROWS).sort(
            SortOrder.ASC,
            nameList("Measures", "Store Sales"));


        SelectNode sortedMdx = query.getSelect();
        String sortedMdxString = sortedMdx.toString();
        TestContext.assertEqualsVerbose(
            "SELECT\n"
            + "{[Measures].[Store Sales]} ON COLUMNS,\n"
            + "Order(Hierarchize(Union(CrossJoin({[Product].[All Products], [Product].[All Products].Children}, CrossJoin({[Time].[1997]}, {[Store].[All Stores]})), Union(CrossJoin({[Product].[Drink]}, CrossJoin({[Time].[1997].[Q3]}, [Store].[All Stores].Children)), CrossJoin({[Product].[Drink]}, CrossJoin([Time].[1997].Children, {[Store].[All Stores]}))))), [Measures].[Store Sales], ASC) ON ROWS\n"
            + "FROM [Sales]",

View Full Code Here


        if (!Bug.BugOlap4j3106220Fixed) {
            return;
        }


        SelectNode mdx = query.getSelect();
        String mdxString = mdx.toString();


        TestContext.assertEqualsVerbose(
            "SELECT\n"
            + "{[Measures].[Store Sales]} ON COLUMNS,\n"
            + "Hierarchize(Union(CrossJoin({[Product].[All Products]}, [Time].[1997].Children), CrossJoin([Product].[All Products].Children, [Time].[1997].Children))) ON ROWS\n"

View Full Code Here

0 1 2

TOP

Related Classes of org.olap4j.mdx.SelectNode

mondrian.test.Olap4jTest

org.olap4j.OlapTest

org.olap4j.query.Olap4jNodeConverter

org.olap4j.query.Query

org.olap4j.transform.AxisTransform

org.olap4j.transform.TransformTest

org.saiku.olap.query.MdxQuery

org.saiku.olap.query.OlapQuery

org.saiku.service.olap.ThinQueryService

org.saiku.web.rest.resources.BasicTagRepositoryResource

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.