Examples of mondrian.test.TestContext$HighCardDynamicSchemaProcessor

mondrian.test.TestContext
Schema processor that flags dimensions as high-cardinality if they appear in the list of values in the {@link MondrianProperties#TestHighCardinalityDimensionList} property.It's a convenient way to run the whole suite against high-cardinality dimensions without modifying FoodMart.xml.

            + "where {[Measures].[Unit Sales]}";
        // Provoke an error in the key resolution to prove it uses it.
        final String colName =
            TestContext.instance().getDialect()
                .quoteIdentifier("promotion_name");
        TestContext testContext = TestContext.instance().createSubstitutingCube(
            "Sales",
            "<Dimension name=\"Promotions\" foreignKey=\"promotion_id\">\n"
            + "  <Hierarchy hasAll=\"true\" allMemberName=\"All Promotions\" primaryKey=\"promotion_id\" defaultMember=\"[All Promotions]\">\n"
            + "    <Table name=\"promotion\"/>\n"
            + "    <Level name=\"Promotion Name\" column=\"promotion_name\" uniqueMembers=\"true\">\n"
            + "      <KeyExpression><SQL>ERROR_TEST_FUNCTION_NAME("
            + colName + ")</SQL></KeyExpression>\n"
            + "    </Level>\n"
            + "  </Hierarchy>\n"
            + "</Dimension>");
        testContext.assertQueryThrows(
            mdxQuery,
            "ERROR_TEST_FUNCTION_NAME");
        // Run for real this time
        testContext = TestContext.instance().createSubstitutingCube(
            "Sales",
            "<Dimension name=\"Promotions\" foreignKey=\"promotion_id\">\n"
            + "  <Hierarchy hasAll=\"true\" allMemberName=\"All Promotions\" primaryKey=\"promotion_id\" defaultMember=\"[All Promotions]\">\n"
            + "    <Table name=\"promotion\"/>\n"
            + "    <Level name=\"Promotion Name\" column=\"promotion_name\" uniqueMembers=\"true\">\n"
            + "      <KeyExpression><SQL>RTRIM("
            + colName + ")</SQL></KeyExpression>\n"
            + "    </Level>\n"
            + "  </Hierarchy>\n"
            + "</Dimension>");
        testContext.assertQueryReturns(
            "select non empty{[Promotions].[All Promotions].Children} ON rows, "
            + "non empty {[Store].[All Stores]} ON columns "
            + "from [Sales] "
            + "where {[Measures].[Unit Sales]}",
            "Axis #0:\n"

View Full Code Here

        SqlPattern[] sqlPatterns = {
            new SqlPattern(Dialect.DatabaseProduct.MYSQL, sqlpat, sqlpat)
        };


        // Use dimension with level-dependent property
        TestContext tc = TestContext.instance().create(
            storeDimensionLevelDependent,
            cubeA,
            null,
            null,
            null,

View Full Code Here

                sqlWithAllGroupBy,
                sqlWithAllGroupBy)
        };


        // Use dimension with level-independent property
        TestContext tc = TestContext.instance().create(
            storeDimensionLevelIndependent,
            cubeA,
            null,
            null,
            null,

View Full Code Here

                sqlWithNoGroupBy,
                sqlWithNoGroupBy)
        };


        // Use dimension with unique level & level-dependent properties
        TestContext tc = TestContext.instance().create(
            storeDimensionUniqueLevelDependentProp,
            cubeA,
            null,
            null,
            null,

View Full Code Here

                sqlWithAllGroupBy,
                sqlWithAllGroupBy)
        };


        // Use dimension with unique level but level-indpendent property
        TestContext tc = TestContext.instance().create(
            storeDimensionUniqueLevelIndependentProp,
            cubeA,
            null,
            null,
            null,

View Full Code Here

        }


        final String mdx =
            "select {[Measures].[Unit Sales]} on columns, {[dimension.tenant].[tenant].Members} on rows from [foo]";


        final TestContext context = getTestContext();


        // We expect the correct cell value + 1 if the agg table is used.
        context.assertQueryReturns(
            mdx,
            "Axis #0:\n"
            + "{}\n"
            + "Axis #1:\n"
            + "{[Measures].[Unit Sales]}\n"

View Full Code Here

    /**
     * Test case for bug <a href="http://jira.pentaho.com/browse/MONDRIAN-163">
     * MONDRIAN-163, "VirtualCube SegmentArrayQuerySpec.addMeasure assert"</a>.
     */
    public void testNoTimeDimension() {
        TestContext testContext = TestContext.instance().create(
            null,
            null,
            "<VirtualCube name=\"Sales vs Warehouse\">\n"
            + "<VirtualCubeDimension name=\"Product\"/>\n"
            + "<VirtualCubeMeasure cubeName=\"Warehouse\" name=\"[Measures].[Warehouse Sales]\"/>\n"

View Full Code Here

            null);
        checkXxx(testContext);
    }


    public void testCalculatedMeasureAsDefaultMeasureInVC() {
        TestContext testContext = TestContext.instance().create(
            null,
            null,
            "<VirtualCube name=\"Sales vs Warehouse\" defaultMeasure=\"Profit\">\n"
            + "<VirtualCubeDimension name=\"Product\"/>\n"
            + "<VirtualCubeMeasure cubeName=\"Warehouse\" "

View Full Code Here

        }


        final String mdx =
            "select {[Measures].[Unit Sales]} on columns, {[dimension.distributor].[line class].Members} on rows from [foo]";


        final TestContext context = getTestContext();


        // We expect the correct cell value + 1 if the agg table is used.
        context.assertQueryReturns(
            mdx,
            "Axis #0:\n"
            + "{}\n"
            + "Axis #1:\n"
            + "{[Measures].[Unit Sales]}\n"
            + "Axis #2:\n"
            + "{[dimension.distributor].[distributor one].[line class one]}\n"
            + "{[dimension.distributor].[distributor two].[line class two]}\n"
            + "Row #0: 31\n"
            + "Row #1: 121\n");


        final String mdx2 =
            "select {[Measures].[Unit Sales]} on columns, {[dimension.network].[line class].Members} on rows from [foo]";
        // We expect the correct cell value + 1 if the agg table is used.
        context.assertQueryReturns(
            mdx2,
            "Axis #0:\n"
            + "{}\n"
            + "Axis #1:\n"
            + "{[Measures].[Unit Sales]}\n"

View Full Code Here

            "select from [Sales vs Warehouse] where measures.profit";
        assertQueriesReturnSimilarResults(query1, query2, testContext);
    }


    public void testDefaultMeasureInVCForIncorrectMeasureName() {
        TestContext testContext = TestContext.instance().create(
            null,
            null,
            "<VirtualCube name=\"Sales vs Warehouse\" defaultMeasure=\"Profit Error\">\n"
            + "<VirtualCubeDimension name=\"Product\"/>\n"
            + "<VirtualCubeMeasure cubeName=\"Warehouse\" "

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of mondrian.test.TestContext$HighCardDynamicSchemaProcessor

mondrian.olap.Axis

mondrian.olap.Cell

mondrian.olap.Connection

mondrian.olap.fun.FunctionTest

mondrian.olap.fun.NativizeSetFunDefTest

mondrian.olap.ParserTest

mondrian.olap.Position

mondrian.olap.QueryTest

mondrian.olap4j.MondrianInprocProxy

mondrian.rolap.agg.AggregationOnDistinctCountMeasuresTest

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.