mondrian.test
Class DrillThroughTest

java.lang.Object
  junit.framework.Assert
      junit.framework.TestCase
          mondrian.test.FoodMartTestCase
              mondrian.test.DrillThroughTest

All Implemented Interfaces:

Test

public class DrillThroughTest
extends FoodMartTestCase

Test generation of SQL to access the fact table data underlying an MDX result set.

Since:

May 10, 2006

Version:

$Id: //open/mondrian-release/3.0/testsrc/main/mondrian/test/DrillThroughTest.java#6 $

Author:

jhyde

Nested Class Summary

Nested classes/interfaces inherited from class mondrian.test.FoodMartTestCase

FoodMartTestCase.QueryAndResult

Field Summary

Fields inherited from class mondrian.test.FoodMartTestCase

nl

Constructor Summary

DrillThroughTest()

DrillThroughTest(String name)

Method Summary

void	testBug1438285() This tests for bug 1438285, "nameColumn cannot be column in level definition".
void	testDrillThrough()
void	testDrillThrough2()
void	testDrillThrough3()
void	testDrillThroughBug1472311() Testcase for bug 1472311, "Drillthrough fails, if Aggregate in MDX-query".
void	testDrillThroughDupKeys() Tests that drill-through works if two dimension tables have primary key columns with the same name.
void	testDrillThroughExprs()
void	testDrillThroughMeasureExp()
void	testDrillThroughVirtualCube() Tests that cells in a virtual cube say they can be drilled through.
void	testTrivalCalcMemberDrillThrough()
void	testTruncateLevelName() Tests that long levels do not result in column aliases larger than the database can handle.

Methods inherited from class mondrian.test.FoodMartTestCase

allMember, assertAxisReturns, assertAxisThrows, assertBooleanExprReturns, assertExprReturns, assertExprThrows, assertQueriesReturnSimilarResults, assertQueryReturns, assertSize, assertThrows, cubeByName, execute, executeExpr, executeQuery, executeSingletonAxis, fold, genderMembersIncludingAll, getConnection, getDimensionWithName, getTestContext, getTestContext, getTestContext, isDefaultNullMemberRepresentation, isGroupingSetsSupported, member, productMembersPotScrubbersPotsAndPans, storeMembersCAAndOR, storeMembersUsaAndCanada, warehouseMembersCanadaMexicoUsa

Methods inherited from class junit.framework.TestCase

countTestCases, createResult, getName, run, run, runBare, runTest, setName, setUp, tearDown, toString

Methods inherited from class junit.framework.Assert

assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertFalse, assertFalse, assertNotNull, assertNotNull, assertNotSame, assertNotSame, assertNull, assertNull, assertSame, assertSame, assertTrue, assertTrue, fail, fail, failNotEquals, failNotSame, failSame

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

DrillThroughTest

public DrillThroughTest()

DrillThroughTest

public DrillThroughTest(String name)

Method Detail

testTrivalCalcMemberDrillThrough

public void testTrivalCalcMemberDrillThrough()
                                      throws Exception

Throws:

Exception

testDrillThrough

public void testDrillThrough()
                      throws Exception

Throws:

Exception

testDrillThrough2

public void testDrillThrough2()
                       throws Exception

Throws:

Exception

testDrillThrough3

public void testDrillThrough3()
                       throws Exception

Throws:

Exception

testDrillThroughBug1472311

public void testDrillThroughBug1472311()
                                throws Exception

Testcase for bug 1472311, "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.

Throws:

Exception

testDrillThroughMeasureExp

public void testDrillThroughMeasureExp()
                                throws Exception

Throws:

Exception

testDrillThroughDupKeys

public void testDrillThroughDupKeys()
                             throws Exception

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".

Throws:

Exception

testDrillThroughVirtualCube

public void testDrillThroughVirtualCube()
                                 throws Exception

Tests that cells in a virtual cube say they can be drilled through.

Throws:

Exception

testBug1438285

public void testBug1438285()
                    throws Exception

This tests for bug 1438285, "nameColumn cannot be column in level definition".

Throws:

Exception

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()