CompoundSlicerTest (Mondrian OLAP Engine, version 3.13.0.0-25)

java.lang.Object
- junit.framework.Assert
- - junit.framework.TestCase
  - - mondrian.test.PropertyRestoringTestCase
    - - mondrian.test.FoodMartTestCase
      - mondrian.test.CompoundSlicerTest

All Implemented Interfaces:

junit.framework.Test
```
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.PropertyRestoringTestCase
  propSaver

Constructor Summary

Constructors
Constructor and Description

CompoundSlicerTest()
Creates a CompoundSlicerTest.

CompoundSlicerTest(String name)
Creates a CompoundSlicerTest with a given name.

Constructors
Constructor and 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 and Description
`void`	`_testMondrian1226Variation()`
`void`	`testBugMondrian899()` Test case for Bug MONDRIAN-899, "Order() function does not work properly together with WHERE clause".
`void`	`testBugMondrian900()` Test case for Bug MONDRIAN-900, "Filter() function works incorrectly together with WHERE clause".
`void`	`testCompoundAggCalcMemberInSlicer1()`
`void`	`testCompoundAggCalcMemberInSlicer2()`
`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`	`testCompoundSlicerWithComplexAggregation()`
`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 results
`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.
`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.PropertyRestoringTestCase
tearDown

Methods inherited from class junit.framework.TestCase
countTestCases, createResult, getName, run, run, runBare, runTest, setName, setUp, 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
  - 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()
```
    Test case for Bug MONDRIAN-899, "Order() function does not work properly together with WHERE clause".
  - 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()
```
    Test case for Bug MONDRIAN-900, "Filter() function works incorrectly together with WHERE clause".
  - 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()
```
  - testCompoundSlicerWithComplexAggregation
```
public void testCompoundSlicerWithComplexAggregation()
```
  - testCompoundAggCalcMemberInSlicer1
```
public void testCompoundAggCalcMemberInSlicer1()
```
  - testCompoundAggCalcMemberInSlicer2
```
public void testCompoundAggCalcMemberInSlicer2()
```

Class CompoundSlicerTest

Nested Class Summary

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

Field Summary

Fields inherited from class mondrian.test.PropertyRestoringTestCase

Constructor Summary

Method Summary

Methods inherited from class mondrian.test.FoodMartTestCase

Methods inherited from class mondrian.test.PropertyRestoringTestCase

Methods inherited from class junit.framework.TestCase

Methods inherited from class junit.framework.Assert

Methods inherited from class java.lang.Object

Constructor Detail

CompoundSlicerTest

CompoundSlicerTest

Method Detail

testSimulatedCompoundSlicer

testCompoundSlicerExcept

testCompoundSlicerWithCellFormatter

testMondrian1226

_testMondrian1226Variation

testCompoundSlicerOverTuples

testEmptySetSlicerReturnsNull

testEmptySetSlicerViaExpressionReturnsNull

testCompoundSlicer

testSlicerContainsNullMember

testSlicerContainsLiteralNull

testSlicerContainsPartiallyNullMember

testCompoundSlicerWithDistinctCount

testRollupAvg

testBugMondrian899

testTopCount

testTopCountAllSlicers

testTopCountWithAggregatedMemberCMRange

testTopCountWithAggregatedMember2

testTopCountWithAggregatedMemberEnumCMSet

testTopCountWithAggregatedMemberEnumSet

testTopCountWithAggregatedMember5

testTopCountWithAggregatedMemberCacheKey

testBugMondrian900

testSlicerWithCalcMembers

testCompoundSlicerAndNamedSet

testDistinctCountMeasureInSlicer

testDistinctCountWithAggregateMembersAndCompSlicer

testVirtualCubeWithCountDistinctUnsatisfiable

testVirtualCubeWithCountDistinctSatisfiable

testVirtualCubeWithCountDistinctPartiallySatisfiable

testCompoundSlicerWithComplexAggregation

testCompoundAggCalcMemberInSlicer1

testCompoundAggCalcMemberInSlicer2