Package mondrian.test

Class CompatibilityTest


  • public class CompatibilityTest
    extends FoodMartTestCase
    Test for MDX syntax compatibility with Microsoft and SAS servers.

    There is no MDX spec document per se, so compatibility with de facto standards from the major vendors is important. Uses the FoodMart database.

    Since:
    March 30, 2005
    Author:
    sasebb
    See Also:
    Ssas2005CompatibilityTest
    • Constructor Detail

      • CompatibilityTest

        public CompatibilityTest​(java.lang.String name)
    • Method Detail

      • testCubeCase

        public void testCubeCase()
        Cube names are case insensitive.
      • testCubeBrackets

        public void testCubeBrackets()
        Brackets around cube names are optional.
      • testReservedWord

        public void testReservedWord()
        See how we are at diagnosing reserved words.
      • testDimensionCase

        public void testDimensionCase()
        Dimension names are case insensitive.
      • testDimensionBrackets

        public void testDimensionBrackets()
        Brackets around dimension names are optional.
      • testMemberCase

        public void testMemberCase()
        Member names are case insensitive.
      • testCalculatedMemberCase

        public void testCalculatedMemberCase()
        Calculated member names are case insensitive.
      • testSolveOrderCase

        public void testSolveOrderCase()
        Solve order is case insensitive.
      • testMemberBrackets

        public void testMemberBrackets()
        Brackets around member names are optional.
      • testHierarchyNames

        public void testHierarchyNames()
        Hierarchy names of the form [Dim].[Hier], [Dim.Hier], and Dim.Hier are accepted.
      • testCaseInsensitiveNullMember

        public void testCaseInsensitiveNullMember()
        Tests that a #null member on a Hiearchy Level of type String can still be looked up when case sensitive is off.
      • testNullNameColumn

        public void testNullNameColumn()
        Tests that data in Hierarchy.Level attribute "nameColumn" can be null. This will map to the #null memeber.
      • testNullCollation

        public void testNullCollation()
        Tests that NULL values sort last on all platforms. On some platforms, such as MySQL, NULLs naturally come before other values, so we have to generate a modified ORDER BY clause.
      • testPropertyCaseSensitivity

        public void testPropertyCaseSensitivity()
        Tests that property names are case sensitive iff the "mondrian.olap.case.sensitive" property is set.

        The test does not alter this property: for testing coverage, we assume that you run the test once with mondrian.olap.case.sensitive=true, and once with mondrian.olap.case.sensitive=false.

      • testWithDimensionPrefix

        public void testWithDimensionPrefix()
      • testWithNoDimensionPrefix

        public void testWithNoDimensionPrefix()