AggregationOnDistinctCountMeasuresTest (Mondrian OLAP Engine, version 3.11.0.0-353)

java.lang.Object
- junit.framework.Assert
- - junit.framework.TestCase
  - - mondrian.test.FoodMartTestCase
    - - mondrian.rolap.BatchTestCase
      - mondrian.rolap.agg.AggregationOnDistinctCountMeasuresTest

All Implemented Interfaces:

junit.framework.Test
```
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 and Description

AggregationOnDistinctCountMeasuresTest()

Constructors
Constructor and Description
`AggregationOnDistinctCountMeasuresTest()`

Method Summary

Methods
Modifier and Type	Method and Description
`TestContext`	`getTestContext()` Returns the test context.
`protected void`	`setUp()`
`void`	`testAggregateMaxConstraints()` Test case for MONDRIAN-1122, "Aggregation is not supported over a list with more than 1000 predicates".
`void`	`testAggregatesAtTheSameLevelForNormalAndDistinctCountMeasure()`
`void`	`testAggregationListOptimizationForChildren()`
`void`	`testAggregationOfMembersAndDefaultMemberWithoutGroupingSets()`
`void`	`testAggregationOnCJofMembersGeneratesOptimalQuery()`
`void`	`testAggregationOverLargeListGeneratesError()`
`void`	`testCanNotBatchForDifferentCompoundPredicate()`
`void`	`testCrossJoinMembersWithASingleMember()`
`void`	`testCrossJoinMembersWithSetOfMembers()`
`void`	`testCrossJoinOfAllMembers()`
`void`	`testCrossJoinOfJoiningAndNonJoiningDimension()`
`void`	`testCrossJoinOfJoiningAndNonJoiningDimensionWithAllMember()`
`void`	`testCrossJoinParticularMembersFromTwoDimensions()`
`void`	`testDistinctCountAggMeasure()` Test case for MONDRIAN-1370 Wrong results for aggregate with distinct count measure.
`void`	`testDistinctCountForAggregatesAtTheSameLevel()`
`void`	`testDistinctCountInNonGroupingSetsQuery()` Test distinct count agg happens in non gs query for subset of members with mixed measures.
`void`	`testDistinctCountOnMembersWithNonJoiningDimensionNotAtAllLevel()`
`void`	`testDistinctCountOnSetOfMembers()`
`void`	`testDistinctCountOnSetOfMembersFromOneDimension()`
`void`	`testDistinctCountOnTuplesWithSomeNonJoiningDimensions()`
`void`	`testDistinctCountWithAMeasureAsPartOfTuple()`
`void`	`testMemberCountIsNotSameForAllMembersInTuple()`
`void`	`testMemberCountIsSameForAllMembersInTuple()`
`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.
`void`	`testMultiLevelMembersMixedNullNonNullParent()`
`void`	`testMultiLevelMembersNullParents()`
`void`	`testMultiLevelsMixedNullNonNullChild()`
`void`	`testNonJoiningDimensionWithAllMember()`
`void`	`testOptimizeChildren()`
`void`	`testOptimizeChildrenForTuplesWithLength1()`
`void`	`testOptimizeChildrenForTuplesWithLength3()`
`void`	`testOptimizeChildrenWhenTuplesAreFormedWithDifferentLevels()`
`void`	`testOptimizeListWhenTuplesAreFormedWithDifferentLevels()`
`void`	`testOptimizeListWithTuplesOfLength3()`
`void`	`testShouldNotRemoveDuplicateTuples()`
`void`	`testTupleOptimizationBug1225()` This is a test for MONDRIAN-1225
`void`	`testTupleWithAllLevelMembersOnly()`
`void`	`testWhetherCJOfChildren()`

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 junit.framework.TestCase
countTestCases, createResult, getName, run, run, runBare, runTest, setName, 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

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

- Constructor Detail
  - AggregationOnDistinctCountMeasuresTest
```
public AggregationOnDistinctCountMeasuresTest()
```
- Method Detail
  - setUp
```
protected void setUp()
              throws Exception
```
    Overrides:
    
    setUp in class junit.framework.TestCase
    
    Throws:
    
    Exception
  - 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 class FoodMartTestCase
  - 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()
```
    Test case for MONDRIAN-1122, "Aggregation is not supported over a list with more than 1000 predicates".
    
    See Also:
    testAggregationOverLargeListGeneratesError()
  - 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-1225
    The 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.

Class AggregationOnDistinctCountMeasuresTest

Nested Class Summary

Nested classes/interfaces inherited from class mondrian.rolap.BatchTestCase

Field Summary

Fields inherited from class mondrian.rolap.BatchTestCase

Fields inherited from class mondrian.test.FoodMartTestCase

Constructor Summary

Method Summary

Methods inherited from class mondrian.rolap.BatchTestCase

Methods inherited from class mondrian.test.FoodMartTestCase

Methods inherited from class junit.framework.TestCase

Methods inherited from class junit.framework.Assert

Methods inherited from class java.lang.Object

Constructor Detail

AggregationOnDistinctCountMeasuresTest

Method Detail

setUp

getTestContext

testTupleWithAllLevelMembersOnly

testCrossJoinOfAllMembers

testCrossJoinMembersWithASingleMember

testCrossJoinMembersWithSetOfMembers

testCrossJoinParticularMembersFromTwoDimensions

testDistinctCountOnSetOfMembersFromOneDimension

testDistinctCountWithAMeasureAsPartOfTuple

testDistinctCountOnSetOfMembers

testDistinctCountOnTuplesWithSomeNonJoiningDimensions

testAggregationListOptimizationForChildren

testDistinctCountOnMembersWithNonJoiningDimensionNotAtAllLevel

testNonJoiningDimensionWithAllMember

testCrossJoinOfJoiningAndNonJoiningDimensionWithAllMember

testCrossJoinOfJoiningAndNonJoiningDimension

testAggregationOverLargeListGeneratesError

testAggregateMaxConstraints

testMultiLevelMembersNullParents

testMultiLevelMembersMixedNullNonNullParent

testMultiLevelsMixedNullNonNullChild

testAggregationOnCJofMembersGeneratesOptimalQuery

testCanNotBatchForDifferentCompoundPredicate

testDistinctCountInNonGroupingSetsQuery

testAggregationOfMembersAndDefaultMemberWithoutGroupingSets

testOptimizeChildren

testOptimizeListWhenTuplesAreFormedWithDifferentLevels

testOptimizeListWithTuplesOfLength3

testOptimizeChildrenForTuplesWithLength1

testOptimizeChildrenForTuplesWithLength3

testOptimizeChildrenWhenTuplesAreFormedWithDifferentLevels

testWhetherCJOfChildren

testShouldNotRemoveDuplicateTuples

testMemberCountIsSameForAllMembersInTuple

testMemberCountIsNotSameForAllMembersInTuple

testAggregatesAtTheSameLevelForNormalAndDistinctCountMeasure

testDistinctCountForAggregatesAtTheSameLevel

testMondrian906

testTupleOptimizationBug1225

testDistinctCountAggMeasure