Package mondrian.rolap.agg
Class AggregationOnDistinctCountMeasuresTest
- java.lang.Object
-
- TestCase
-
- mondrian.test.FoodMartTestCase
-
- mondrian.rolap.BatchTestCase
-
- mondrian.rolap.agg.AggregationOnDistinctCountMeasuresTest
-
public class AggregationOnDistinctCountMeasuresTest extends BatchTestCase
AggregationOnDistinctCountMeasureTest
tests the Distinct Count functionality with tuples and members.- Since:
- 19 December, 2007
- Author:
- ajogleka
-
-
Nested Class Summary
-
Nested classes/interfaces inherited from class mondrian.rolap.BatchTestCase
BatchTestCase.TestCase
-
-
Field Summary
-
Fields inherited from class mondrian.rolap.BatchTestCase
cubeNameSales, fieldGender, fieldProductDepartment, fieldProductFamily, fieldValueProductDepartment, fieldValuesGender, fieldValuesProductFamily, fieldValuesYear, fieldYear, measureUnitSales, tableCustomer, tableProductClass, tableTime
-
Fields inherited from class mondrian.test.FoodMartTestCase
propSaver
-
-
Constructor Summary
Constructors Constructor Description AggregationOnDistinctCountMeasuresTest()
-
Method Summary
-
Methods inherited from class mondrian.rolap.BatchTestCase
assertNative, assertNoQuerySql, assertNotNative, assertQuerySql, assertQuerySql, assertQuerySql, assertQuerySqlOrNot, assertRequestSql, assertRequestSql, checkNative, checkNative, checkNative, checkNotNative, checkNotNative, checkNotNative, createBatch, createBatch, createRequest, createRequest, createRequest, createRequest, dialectize, executeQuery, getCube, getFoodMartConnection, getGroupingSet, getMeasure, mysqlPattern, sqlPattern
-
Methods inherited from class mondrian.test.FoodMartTestCase
allMember, assertAxisReturns, assertAxisThrows, assertBooleanExprReturns, assertExprReturns, assertExprThrows, assertQueriesReturnSimilarResults, assertQueryReturns, assertQueryThrows, assertSize, cubeByName, execute, executeExpr, executeQuery, executeSingletonAxis, genderMembersIncludingAll, getConnection, getDimensionWithName, isDefaultNullMemberRepresentation, isGroupingSetsSupported, member, productMembersPotScrubbersPotsAndPans, storeMembersCAAndOR, storeMembersUsaAndCanada, tearDown, verifySameNativeAndNot, warehouseMembersCanadaMexicoUsa
-
-
-
-
Method Detail
-
getTestContext
public TestContext getTestContext()
Description copied from class:FoodMartTestCase
Returns the test context. Override this method if you wish to use a different source for your FoodMart connection.- Overrides:
getTestContext
in classFoodMartTestCase
-
testTupleWithAllLevelMembersOnly
public void testTupleWithAllLevelMembersOnly()
-
testCrossJoinOfAllMembers
public void testCrossJoinOfAllMembers()
-
testCrossJoinMembersWithASingleMember
public void testCrossJoinMembersWithASingleMember()
-
testCrossJoinMembersWithSetOfMembers
public void testCrossJoinMembersWithSetOfMembers()
-
testCrossJoinParticularMembersFromTwoDimensions
public void testCrossJoinParticularMembersFromTwoDimensions()
-
testDistinctCountOnSetOfMembersFromOneDimension
public void testDistinctCountOnSetOfMembersFromOneDimension()
-
testDistinctCountWithAMeasureAsPartOfTuple
public void testDistinctCountWithAMeasureAsPartOfTuple()
-
testDistinctCountOnSetOfMembers
public void testDistinctCountOnSetOfMembers()
-
testDistinctCountOnTuplesWithSomeNonJoiningDimensions
public void testDistinctCountOnTuplesWithSomeNonJoiningDimensions()
-
testAggregationListOptimizationForChildren
public void testAggregationListOptimizationForChildren()
-
testDistinctCountOnMembersWithNonJoiningDimensionNotAtAllLevel
public void testDistinctCountOnMembersWithNonJoiningDimensionNotAtAllLevel()
-
testNonJoiningDimensionWithAllMember
public void testNonJoiningDimensionWithAllMember()
-
testCrossJoinOfJoiningAndNonJoiningDimensionWithAllMember
public void testCrossJoinOfJoiningAndNonJoiningDimensionWithAllMember()
-
testCrossJoinOfJoiningAndNonJoiningDimension
public void testCrossJoinOfJoiningAndNonJoiningDimension()
-
testAggregationOverLargeListGeneratesError
public void testAggregationOverLargeListGeneratesError()
-
testAggregateMaxConstraints
public void testAggregateMaxConstraints()
-
testMultiLevelMembersNullParents
public void testMultiLevelMembersNullParents()
-
testMultiLevelMembersMixedNullNonNullParent
public void testMultiLevelMembersMixedNullNonNullParent()
-
testMultiLevelsMixedNullNonNullChild
public void testMultiLevelsMixedNullNonNullChild()
-
testAggregationOnCJofMembersGeneratesOptimalQuery
public void testAggregationOnCJofMembersGeneratesOptimalQuery()
-
testCanNotBatchForDifferentCompoundPredicate
public void testCanNotBatchForDifferentCompoundPredicate()
-
testDistinctCountInNonGroupingSetsQuery
public void testDistinctCountInNonGroupingSetsQuery()
Test distinct count agg happens in non gs query for subset of members with mixed measures.
-
testAggregationOfMembersAndDefaultMemberWithoutGroupingSets
public void testAggregationOfMembersAndDefaultMemberWithoutGroupingSets()
-
testOptimizeChildren
public void testOptimizeChildren()
-
testOptimizeListWhenTuplesAreFormedWithDifferentLevels
public void testOptimizeListWhenTuplesAreFormedWithDifferentLevels()
-
testOptimizeListWithTuplesOfLength3
public void testOptimizeListWithTuplesOfLength3()
-
testOptimizeChildrenForTuplesWithLength1
public void testOptimizeChildrenForTuplesWithLength1()
-
testOptimizeChildrenForTuplesWithLength3
public void testOptimizeChildrenForTuplesWithLength3()
-
testOptimizeChildrenWhenTuplesAreFormedWithDifferentLevels
public void testOptimizeChildrenWhenTuplesAreFormedWithDifferentLevels()
-
testWhetherCJOfChildren
public void testWhetherCJOfChildren()
-
testShouldNotRemoveDuplicateTuples
public void testShouldNotRemoveDuplicateTuples()
-
testMemberCountIsSameForAllMembersInTuple
public void testMemberCountIsSameForAllMembersInTuple()
-
testMemberCountIsNotSameForAllMembersInTuple
public void testMemberCountIsNotSameForAllMembersInTuple()
-
testAggregatesAtTheSameLevelForNormalAndDistinctCountMeasure
public void testAggregatesAtTheSameLevelForNormalAndDistinctCountMeasure()
-
testDistinctCountForAggregatesAtTheSameLevel
public void testDistinctCountForAggregatesAtTheSameLevel()
-
testMondrian906
public void testMondrian906()
This test makes sure that the AggregateFunDef will not optimize a tuples list when the rollup policy is set to something else than FULL, as it results in wrong data for a distinct count operation when using roles to narrow down the members access.
-
testTupleOptimizationBug1225
public void testTupleOptimizationBug1225()
This is a test for MONDRIAN-1225The optimization routine for tuple lists was implementing a single side of an IF conditional, which resulted in an NPE.
-
testDistinctCountAggMeasure
public void testDistinctCountAggMeasure()
Test case for MONDRIAN-1370
Wrong results for aggregate with distinct count measure.
-
-