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(String name)Creates a CompoundSlicerTest with a given name.
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description void_testMondrian1226Variation()voidtestBugMondrian899()voidtestBugMondrian900()voidtestCompoundSlicer()Test case for a basic query with more than one member of the same hierarchy in the WHERE clause.voidtestCompoundSlicerAndNamedSet()voidtestCompoundSlicerExcept()Tests compound slicer with EXCEPT.voidtestCompoundSlicerOverTuples()Tests a query with a compond slicer over tuples.voidtestCompoundSlicerWithCellFormatter()voidtestCompoundSlicerWithDistinctCount()Compound slicer with distinct-count measure.voidtestDistinctCountMeasureInSlicer()voidtestDistinctCountWithAggregateMembersAndCompSlicer()voidtestEmptySetSlicerReturnsNull()Tests that if the slicer contains zero members, all cells are null.voidtestEmptySetSlicerViaExpressionReturnsNull()Tests that if the slicer is calculated using an expression and contains zero members, all cells are null.voidtestMondrian1226()voidtestRollupAvg()Tests compound slicer, and other rollups, with AVG function.voidtestSimulatedCompoundSlicer()Query that simulates a compound slicer by creating a calculated member that aggregates over a set and places it in the WHERE clause.voidtestSlicerContainsLiteralNull()Slicer that is literal null.voidtestSlicerContainsNullMember()Slicer that is a member expression that evaluates to null.voidtestSlicerContainsPartiallyNullMember()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.voidtestSlicerWithCalcMembers()voidtestTopCount()voidtestTopCountAllSlicers()voidtestTopCountWithAggregatedMember2()Test case for the support of native top count with aggregated measures feeding the range directly to aggregate.voidtestTopCountWithAggregatedMember5()Test case for the support of native top count with aggregated measures using yet another different format, slightly different resultsvoidtestTopCountWithAggregatedMemberCacheKey()Test case for the support of native top count with aggregated measures using the most complex format I can think of, slightly different results.voidtestTopCountWithAggregatedMemberCMRange()Test case for the support of native top count with aggregated measures.voidtestTopCountWithAggregatedMemberEnumCMSet()Test case for the support of native top count with aggregated measures using enumerated members in a calculated member.voidtestTopCountWithAggregatedMemberEnumSet()Test case for the support of native top count with aggregated measures using enumerated members.voidtestVirtualCubeWithCountDistinctPartiallySatisfiable()voidtestVirtualCubeWithCountDistinctSatisfiable()voidtestVirtualCubeWithCountDistinctUnsatisfiable()-
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
-
-
-
-
Constructor Detail
-
CompoundSlicerTest
public CompoundSlicerTest()
Creates a CompoundSlicerTest.
-
CompoundSlicerTest
public CompoundSlicerTest(String name)
Creates a CompoundSlicerTest with a given name.- Parameters:
name- Test name
-
-
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 Exception- Throws:
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()
-
-