Examples of mondrian.test.TestContext.assertAxisReturns()

mondrian.test.TestContext.assertAxisReturns()
Executes a query with a given expression on an axis, and asserts that it returns the expected string.

        if (Bug.avoidSlowTestOnLucidDB(testContext.getDialect())) {
            return;
        }


        // leaves, restricted by level
        testContext.assertAxisReturns(
            "Descendants([Employees].[All Employees].[Sheri Nowmer].[Michael Spence], [Employees].[Employee Id], LEAVES)",
            "[Employees].[Sheri Nowmer].[Michael Spence].[Daniel Wolter].[Michael John Troyer].[Mary Sandidge].[John Brooks]\n"
            + "[Employees].[Sheri Nowmer].[Michael Spence].[Daniel Wolter].[Michael John Troyer].[Mary Sandidge].[Todd Logan]\n"
            + "[Employees].[Sheri Nowmer].[Michael Spence].[Daniel Wolter].[Michael John Troyer].[Mary Sandidge].[Joshua Several]\n"
            + "[Employees].[Sheri Nowmer].[Michael Spence].[Daniel Wolter].[Michael John Troyer].[Mary Sandidge].[James Thomas]\n"

View Full Code Here

            + "[Employees].[Sheri Nowmer].[Michael Spence].[Dianne Collins].[Lawrence Hurkett].[Greg Narberes]\n"
            + "[Employees].[Sheri Nowmer].[Michael Spence].[Dianne Collins].[Lawrence Hurkett].[Anna Townsend]\n"
            + "[Employees].[Sheri Nowmer].[Michael Spence].[Dianne Collins].[Lawrence Hurkett].[Carol Ann Rockne]");


        // leaves, restricted by depth
        testContext.assertAxisReturns(
            "Descendants([Employees], 1, LEAVES)", "");
        testContext.assertAxisReturns(
            "Descendants([Employees], 2, LEAVES)",
            "[Employees].[Sheri Nowmer].[Roberta Damstra].[Jennifer Cooper]\n"
            + "[Employees].[Sheri Nowmer].[Roberta Damstra].[Peggy Petty]\n"

View Full Code Here

            + "[Employees].[Sheri Nowmer].[Michael Spence].[Dianne Collins].[Lawrence Hurkett].[Carol Ann Rockne]");


        // leaves, restricted by depth
        testContext.assertAxisReturns(
            "Descendants([Employees], 1, LEAVES)", "");
        testContext.assertAxisReturns(
            "Descendants([Employees], 2, LEAVES)",
            "[Employees].[Sheri Nowmer].[Roberta Damstra].[Jennifer Cooper]\n"
            + "[Employees].[Sheri Nowmer].[Roberta Damstra].[Peggy Petty]\n"
            + "[Employees].[Sheri Nowmer].[Roberta Damstra].[Jessica Olguin]\n"
            + "[Employees].[Sheri Nowmer].[Roberta Damstra].[Phyllis Burchett]\n"

View Full Code Here

            + "[Employees].[Sheri Nowmer].[Darren Stanz].[Brian Binai]\n"
            + "[Employees].[Sheri Nowmer].[Darren Stanz].[Concepcion Lozada]\n"
            + "[Employees].[Sheri Nowmer].[Donna Arnold].[Howard Bechard]\n"
            + "[Employees].[Sheri Nowmer].[Donna Arnold].[Doris Carter]");


        testContext.assertAxisReturns(
            "Descendants([Employees], 3, LEAVES)",
            "[Employees].[Sheri Nowmer].[Roberta Damstra].[Jennifer Cooper]\n"
            + "[Employees].[Sheri Nowmer].[Roberta Damstra].[Peggy Petty]\n"
            + "[Employees].[Sheri Nowmer].[Roberta Damstra].[Jessica Olguin]\n"
            + "[Employees].[Sheri Nowmer].[Roberta Damstra].[Phyllis Burchett]\n"

View Full Code Here

            + "[Employees].[Sheri Nowmer].[Darren Stanz].[Concepcion Lozada]\n"
            + "[Employees].[Sheri Nowmer].[Donna Arnold].[Howard Bechard]\n"
            + "[Employees].[Sheri Nowmer].[Donna Arnold].[Doris Carter]");


        // note that depth is RELATIVE to the starting member
        testContext.assertAxisReturns(
            "Descendants([Employees].[Sheri Nowmer].[Roberta Damstra], 1, LEAVES)",
            "[Employees].[Sheri Nowmer].[Roberta Damstra].[Jennifer Cooper]\n"
            + "[Employees].[Sheri Nowmer].[Roberta Damstra].[Peggy Petty]\n"
            + "[Employees].[Sheri Nowmer].[Roberta Damstra].[Jessica Olguin]\n"
            + "[Employees].[Sheri Nowmer].[Roberta Damstra].[Phyllis Burchett]");

View Full Code Here

            + "[Employees].[Sheri Nowmer].[Roberta Damstra].[Peggy Petty]\n"
            + "[Employees].[Sheri Nowmer].[Roberta Damstra].[Jessica Olguin]\n"
            + "[Employees].[Sheri Nowmer].[Roberta Damstra].[Phyllis Burchett]");


        // Howard Bechard is a leaf member -- appears even at depth 0
        testContext.assertAxisReturns(
            "Descendants([Employees].[All Employees].[Sheri Nowmer].[Donna Arnold].[Howard Bechard], 0, LEAVES)",
            "[Employees].[Sheri Nowmer].[Donna Arnold].[Howard Bechard]");
        testContext.assertAxisReturns(
            "Descendants([Employees].[All Employees].[Sheri Nowmer].[Donna Arnold].[Howard Bechard], 1, LEAVES)",
            "[Employees].[Sheri Nowmer].[Donna Arnold].[Howard Bechard]");

View Full Code Here


        // Howard Bechard is a leaf member -- appears even at depth 0
        testContext.assertAxisReturns(
            "Descendants([Employees].[All Employees].[Sheri Nowmer].[Donna Arnold].[Howard Bechard], 0, LEAVES)",
            "[Employees].[Sheri Nowmer].[Donna Arnold].[Howard Bechard]");
        testContext.assertAxisReturns(
            "Descendants([Employees].[All Employees].[Sheri Nowmer].[Donna Arnold].[Howard Bechard], 1, LEAVES)",
            "[Employees].[Sheri Nowmer].[Donna Arnold].[Howard Bechard]");


        testContext.assertExprReturns(
            "Count(Descendants([Employees], 2, LEAVES))", "16");

View Full Code Here

            + "  <Measure name=\"Unit Sales\" column=\"unit_sales\" aggregator=\"sum\"\n"
            + "      formatString=\"Standard\"/>\n"
            + "</Cube>");


        // The [Time_Alphabetical] is ordered alphabetically by month
        context.assertAxisReturns(
            "Hierarchize([Time_Alphabetical].members)",
                "[Time_Alphabetical].[1997]\n"
                + "[Time_Alphabetical].[1997].[Q1]\n"
                + "[Time_Alphabetical].[1997].[Q1].[2]\n"
                + "[Time_Alphabetical].[1997].[Q1].[1]\n"

View Full Code Here

                + "[Time_Alphabetical].[1998].[Q4].[11]\n"
                + "[Time_Alphabetical].[1998].[Q4].[10]");


        // The [Month_Alphabetical] is a single-level hierarchy ordered
        // alphabetically by month.
        context.assertAxisReturns(
            "Hierarchize([Month_Alphabetical].members)",
                "[Month_Alphabetical].[4]\n"
                + "[Month_Alphabetical].[8]\n"
                + "[Month_Alphabetical].[12]\n"
                + "[Month_Alphabetical].[2]\n"

View Full Code Here

            "ClosingPeriod([Time].[Month])", "[Time].[1997].[Q4].[12]");


        assertAxisReturns("ClosingPeriod()", "[Time].[1997].[Q4]");


        TestContext testContext = getTestContext().withCube("[Sales Ragged]");
        testContext.assertAxisReturns(
            "ClosingPeriod([Store].[Store State], [Store].[All Stores].[Israel])",
            "");


        testContext.assertAxisThrows(
            "ClosingPeriod([Time].[Year], [Store].[All Stores].[Israel])",

View Full Code Here

0 1 2

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.