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