Package mondrian.test
Class CompoundSlicerTest
- java.lang.Object
-
- TestCase
-
- mondrian.test.FoodMartTestCase
-
- mondrian.test.CompoundSlicerTest
-
public class CompoundSlicerTest extends FoodMartTestCase
Tests the expressions used for calculated members. Please keep in sync with the actual code used by the wizard.- Since:
- 15 May, 2009
- 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
propSaver
-
-
Constructor Summary
Constructors Constructor Description CompoundSlicerTest()
Creates a CompoundSlicerTest.CompoundSlicerTest(java.lang.String name)
Creates a CompoundSlicerTest with a given name.
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description void
_testMondrian1226Variation()
void
testBugMondrian899()
void
testBugMondrian900()
void
testCompoundSlicer()
Test case for a basic query with more than one member of the same hierarchy in the WHERE clause.void
testCompoundSlicerAndNamedSet()
void
testCompoundSlicerExcept()
Tests compound slicer with EXCEPT.void
testCompoundSlicerOverTuples()
Tests a query with a compond slicer over tuples.void
testCompoundSlicerWithCellFormatter()
void
testCompoundSlicerWithDistinctCount()
Compound slicer with distinct-count measure.void
testDistinctCountMeasureInSlicer()
void
testDistinctCountWithAggregateMembersAndCompSlicer()
void
testEmptySetSlicerReturnsNull()
Tests that if the slicer contains zero members, all cells are null.void
testEmptySetSlicerViaExpressionReturnsNull()
Tests that if the slicer is calculated using an expression and contains zero members, all cells are null.void
testMondrian1226()
void
testRollupAvg()
Tests compound slicer, and other rollups, with AVG function.void
testSimulatedCompoundSlicer()
Query that simulates a compound slicer by creating a calculated member that aggregates over a set and places it in the WHERE clause.void
testSlicerContainsLiteralNull()
Slicer that is literal null.void
testSlicerContainsNullMember()
Slicer that is a member expression that evaluates to null.void
testSlicerContainsPartiallyNullMember()
Slicer that is a tuple and one of the members evaluates to null; that makes it a null tuple, and it is eliminated from the list.void
testSlicerWithCalcMembers()
void
testTopCount()
void
testTopCountAllSlicers()
void
testTopCountWithAggregatedMember2()
Test case for the support of native top count with aggregated measures feeding the range directly to aggregate.void
testTopCountWithAggregatedMember5()
Test case for the support of native top count with aggregated measures using yet another different format, slightly different resultsvoid
testTopCountWithAggregatedMemberCacheKey()
Test case for the support of native top count with aggregated measures using the most complex format I can think of, slightly different results.void
testTopCountWithAggregatedMemberCMRange()
Test case for the support of native top count with aggregated measures.void
testTopCountWithAggregatedMemberEnumCMSet()
Test case for the support of native top count with aggregated measures using enumerated members in a calculated member.void
testTopCountWithAggregatedMemberEnumSet()
Test case for the support of native top count with aggregated measures using enumerated members.void
testVirtualCubeWithCountDistinctPartiallySatisfiable()
void
testVirtualCubeWithCountDistinctSatisfiable()
void
testVirtualCubeWithCountDistinctUnsatisfiable()
-
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, getTestContext, isDefaultNullMemberRepresentation, isGroupingSetsSupported, member, productMembersPotScrubbersPotsAndPans, storeMembersCAAndOR, storeMembersUsaAndCanada, tearDown, verifySameNativeAndNot, warehouseMembersCanadaMexicoUsa
-
-
-
-
Method Detail
-
testSimulatedCompoundSlicer
public void testSimulatedCompoundSlicer()
Query that simulates a compound slicer by creating a calculated member that aggregates over a set and places it in the WHERE clause.
-
testCompoundSlicerExcept
public void testCompoundSlicerExcept()
Tests compound slicer with EXCEPT.Test case for Bug MONDRIAN-637, "Using Except in the slicer makes no sense".
-
testCompoundSlicerWithCellFormatter
public void testCompoundSlicerWithCellFormatter()
-
testMondrian1226
public void testMondrian1226()
-
_testMondrian1226Variation
public void _testMondrian1226Variation()
-
testCompoundSlicerOverTuples
public void testCompoundSlicerOverTuples()
Tests a query with a compond slicer over tuples. (Multiple rows, each of which has multiple members.)
-
testEmptySetSlicerReturnsNull
public void testEmptySetSlicerReturnsNull()
Tests that if the slicer contains zero members, all cells are null.
-
testEmptySetSlicerViaExpressionReturnsNull
public void testEmptySetSlicerViaExpressionReturnsNull()
Tests that if the slicer is calculated using an expression and contains zero members, all cells are null.
-
testCompoundSlicer
public void testCompoundSlicer()
Test case for a basic query with more than one member of the same hierarchy in the WHERE clause.
-
testSlicerContainsNullMember
public void testSlicerContainsNullMember()
Slicer that is a member expression that evaluates to null. SSAS 2005 allows this, and returns null cells.
-
testSlicerContainsLiteralNull
public void testSlicerContainsLiteralNull()
Slicer that is literal null. SSAS 2005 allows this, and returns null cells; Mondrian currently gives an error.
-
testSlicerContainsPartiallyNullMember
public void testSlicerContainsPartiallyNullMember()
Slicer that is a tuple and one of the members evaluates to null; that makes it a null tuple, and it is eliminated from the list. SSAS 2005 allows this, and returns null cells.
-
testCompoundSlicerWithDistinctCount
public void testCompoundSlicerWithDistinctCount()
Compound slicer with distinct-count measure.
-
testRollupAvg
public void testRollupAvg()
Tests compound slicer, and other rollups, with AVG function.Test case for Bug MONDRIAN-675, "Allow rollup of measures based on AVG aggregate function".
-
testBugMondrian899
public void testBugMondrian899()
-
testTopCount
public void testTopCount()
-
testTopCountAllSlicers
public void testTopCountAllSlicers()
-
testTopCountWithAggregatedMemberCMRange
public void testTopCountWithAggregatedMemberCMRange()
Test case for the support of native top count with aggregated measures. This version puts the range in a calculated member.
-
testTopCountWithAggregatedMember2
public void testTopCountWithAggregatedMember2()
Test case for the support of native top count with aggregated measures feeding the range directly to aggregate.
-
testTopCountWithAggregatedMemberEnumCMSet
public void testTopCountWithAggregatedMemberEnumCMSet()
Test case for the support of native top count with aggregated measures using enumerated members in a calculated member.
-
testTopCountWithAggregatedMemberEnumSet
public void testTopCountWithAggregatedMemberEnumSet()
Test case for the support of native top count with aggregated measures using enumerated members.
-
testTopCountWithAggregatedMember5
public void testTopCountWithAggregatedMember5()
Test case for the support of native top count with aggregated measures using yet another different format, slightly different results
-
testTopCountWithAggregatedMemberCacheKey
public void testTopCountWithAggregatedMemberCacheKey()
Test case for the support of native top count with aggregated measures using the most complex format I can think of, slightly different results. We'll execute 2 queries to make sure Time.x is not member of the cache key.
-
testBugMondrian900
public void testBugMondrian900()
-
testSlicerWithCalcMembers
public void testSlicerWithCalcMembers() throws java.lang.Exception
- Throws:
java.lang.Exception
-
testCompoundSlicerAndNamedSet
public void testCompoundSlicerAndNamedSet()
-
testDistinctCountMeasureInSlicer
public void testDistinctCountMeasureInSlicer()
-
testDistinctCountWithAggregateMembersAndCompSlicer
public void testDistinctCountWithAggregateMembersAndCompSlicer()
-
testVirtualCubeWithCountDistinctUnsatisfiable
public void testVirtualCubeWithCountDistinctUnsatisfiable()
-
testVirtualCubeWithCountDistinctSatisfiable
public void testVirtualCubeWithCountDistinctSatisfiable()
-
testVirtualCubeWithCountDistinctPartiallySatisfiable
public void testVirtualCubeWithCountDistinctPartiallySatisfiable()
-
-