public class Ssas2005CompatibilityTest extends FoodMartTestCase
This suite contains a MDX collection of queries that were run on SSAS. The queries cover a variety of issues, including multiple hierarchies in a dimension, attribute hierarchies, and name resolution. Expect to find tests for these areas in dedicated tests also.
There are tests for features which are unimplemented or where mondrian's behavior differs from SSAS2005. These tests will appear in this file disabled or with (clearly marked) incorrect results.
| Modifier and Type | Class and Description |
|---|---|
static class |
Ssas2005CompatibilityTest.NewBehaviorTest
Subclass of
Ssas2005CompatibilityTest that runs
with MondrianProperties.SsasCompatibleNaming=true. |
static class |
Ssas2005CompatibilityTest.OldBehaviorTest
Subclass of
Ssas2005CompatibilityTest that runs
with MondrianProperties.SsasCompatibleNaming=false. |
FoodMartTestCase.QueryAndResult| Modifier and Type | Field and Description |
|---|---|
static boolean |
ATTR_HIER_IMPL
Whether attribute hierarchies are implemented.
|
static boolean |
AXIS_IMPL
Whether the AXIS function has been are implemented.
|
propSaver| Constructor and Description |
|---|
Ssas2005CompatibilityTest(String name)
Creates a Ssas2005CompatibilityTest.
|
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, warehouseMembersCanadaMexicoUsacountTestCases, createResult, getName, run, run, runBare, runTest, setName, setUp, toStringassertEquals, 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, failpublic static final boolean ATTR_HIER_IMPL
public static final boolean AXIS_IMPL
public Ssas2005CompatibilityTest(String name)
name - Testcase namepublic TestContext getTestContext()
FoodMartTestCasegetTestContext in class FoodMartTestCasepublic void testUniqueName()
public void testDimensionDotHierarchyAmbiguous()
public void testHierarchyLevelsFunction()
public void testDimensionDotHierarchyDotLevelDotMembers()
public void testDimensionDotHierarchyDotLevel()
public void testNamingDimensionDotLevel()
public void testNamingDimensionDotLevel2()
public void testNamingDimensionDotLevelNotUnique()
public void testDimensionMembersOnSingleHierarchyDimension()
public void testMultipleHierarchyRequiresQualification()
public void testCalcMemberAmbiguousHierarchy()
BasicQueryTest.testHalfYears().public void testUnqualifiedHierarchy()
public void testYtd()
public void testAxesOutOfOrder()
public void testDimensionMembersRequiresHierarchyQualification()
public void testDimensionMemberRequiresHierarchyQualification()
public void testImplicitCurrentMemberRequiresHierarchyQualification()
public void testUnqualifiedHierarchyCurrentMember()
public void testCannotDistinguishMdxFromSql()
public void testNamingDimensionAttr()
public void testNamingDimensionAttrVsLevel()
public void testAttrHierarchyMemberParent()
public void testAttrHierarchyMemberChildren()
public void testAttrHierarchyAllMemberChildren()
public void testAttrHierarchyMemberLevel()
public void testAttrHierarchyUniqueName()
public void testMemberAddressedByLevelAndKey()
public void testMemberAddressedByCompoundKey()
public void testMemberAddressedByPartialCompoundKey()
public void testMemberAddressedByNonUniqueName()
public void testMemberAddressedByLevelAndCompoundKey()
public void testMemberAddressedByLevelAndName()
public void testFoo31()
public void testFoo32()
public void testNamingAttrVsLevel()
public void testUnqualifiedLevel()
public void testDimensionAsScalarExpression()
public void testDimensionWithMultipleHierarchiesDotParent()
public void testDimensionDotHierarchyInBrackets()
public void testDimensionDotHierarchySameNameInBrackets()
public void testDimensionDotLevelDotHierarchyInBrackets()
public void testDimensionDotInvalidHierarchyInBrackets()
public void testDimensionDotDimensionInBrackets()
public void testDimensionDotHierarchyDotNonExistentLevel()
public void testDimensionDotHierarchyDotLevelMembers()
public void testDupHierarchyOnAxes()
public void testDimensionOnAxis()
public void testDimensionDotHierarchyOnAxis()
public void testHierarchiesFromSameDimensionOnAxes()
public void testDifferentHierarchiesFromSameDimensionOnAxes()
public void testDifferentHierarchiesFromSameDimensionInCrossjoin()
public void testHierarchyUsedTwiceInCrossjoin()
public void testAttributeHierarchyUsedTwiceInCrossjoin()
public void testFoo50()
public void testQuoteInStringInQuotedFormula()
public void testQuoteInStringInUnquotedFormula()
public void testMemberIdentifiedByDimensionAndKey()
public void testDimensionHierarchyKey()
public void testCompoundKey()
public void testCompoundKeySyntaxError()
public void testCompoundKeyStringBad()
public void testCompoundKeyString()
public void testNameAfterKey()
[San Francisco].[Store 14]
occur after a key segment &&CA.
Needs to work regardless of the value of
MondrianProperties.SsasCompatibleNaming. Mondrian-3 had this
functionality.
public void testNameAfterCompositeKey()
[Store 14] occurs after a
composite key segment &[San Francisco]&CA.public void testCompoundKeyAll()
public void testCompoundKeyParent()
public void testCompoundKeyNull()
public void testFoo56()
public void testKeyNonExistent()
public void testAxesLabelsOutOfSequence()
public void testAxisLabelsNotContiguousFails()
public void testLotsOfAxes()
public void testOnAxesFails()
public void testOnExpression()
public void testOnFractionFails()
public void testAxisFunction()
public void testAxisAppliedToExpr()
public void testAxisFunctionReferencesPreviousAxis()
public void testAxisFunctionReferencesSameAxisFails()
public void testAxisFunctionReferencesSameAxisZeroFails()
public void testAxisFunctionReferencesLaterAxis()
public void testAxisFunctionReferencesSameAxisInlineFails()
public void testCrossjoinMember()
public void testCanHaveMemberWithSameNameAsLevel()
throws SQLException
SQLException - If the test fails.public void testMemberNameSortCaseSensitivity()
public void testRootMembers()