Package mondrian.test

Class DrillThroughTest

  • public class DrillThroughTest
extends FoodMartTestCase
    Test generation of SQL to access the fact table data underlying an MDX result set.
    Since:
    May 10, 2006
    Author:
    jhyde

    • Constructor Detail

      • DrillThroughTest

        public DrillThroughTest()

      • DrillThroughTest

        public DrillThroughTest​(String name)

    • Method Detail

      • testTrivialCalcMemberDrillThrough

        public void testTrivialCalcMemberDrillThrough()

      • testTrivialCalcMemberNotMeasure

        public void testTrivialCalcMemberNotMeasure()

      • testDrillthroughCompoundSlicer

        public void testDrillthroughCompoundSlicer()

      • testDrillThrough

        public void testDrillThrough()

      • testDrillThrough2

        public void testDrillThrough2()

      • testDrillThrough3

        public void testDrillThrough3()

      • testDrillThroughBugMondrian180

        public void testDrillThroughBugMondrian180()
        Test case for bug MONDRIAN-180, "Drillthrough fails, if Aggregate in MDX-query". The problem actually occurs with any calculated member, not just Aggregate. The bug was causing a syntactically invalid constraint to be added to the WHERE clause; after the fix, we do not constrain on the member at all.

      • testDrillThroughMeasureExp

        public void testDrillThroughMeasureExp()
        Tests that proper SQL is being generated for a Measure specified as an expression.

      • testDrillThroughDupKeys

        public void testDrillThroughDupKeys()
        Tests that drill-through works if two dimension tables have primary key columns with the same name. Related to bug 1592556, "XMLA Drill through bug".

      • testDrillThroughVirtualCube

        public void testDrillThroughVirtualCube()
        Tests that cells in a virtual cube say they can be drilled through.

      • testBug1438285

        public void testBug1438285()
        This tests for bug 1438285, "nameColumn cannot be column in level definition".

      • testTruncateLevelName

        public void testTruncateLevelName()
                           throws Exception
        Tests that long levels do not result in column aliases larger than the database can handle. For example, Access allows maximum of 64; Oracle allows 30.

        Testcase for bug 1893959, "Generated drill-through columns too long for DBMS".

        Throws:
        Exception - on error

      • testDrillThroughExprs

        public void testDrillThroughExprs()

      • testDrillthroughNegativeMaxRowsFails

        public void testDrillthroughNegativeMaxRowsFails()
                                          throws SQLException
        Throws:
        SQLException

      • testDrillThroughCalculatedMemberMeasure

        public void testDrillThroughCalculatedMemberMeasure()

      • testDrillThroughNotDrillableFails

        public void testDrillThroughNotDrillableFails()

      • testDrillThroughMultiPositionCompoundSlicer

        public void testDrillThroughMultiPositionCompoundSlicer()
        Test case for MONDRIAN-791.

      • testDrillthroughDisable

        public void testDrillthroughDisable()

      • testColumnAliasQuotedInOrderBy

        public void testColumnAliasQuotedInOrderBy()
                                    throws Exception
        Tests that dialects that require alias in order by are correctly quoted MONDRIAN-1983.
        Throws:
        Exception

      • testDrillthroughVirtualCubeWithReturnClause

        public void testDrillthroughVirtualCubeWithReturnClause()
                                                 throws SQLException
        Throws:
        SQLException