[Mondrian] Build failed in Jenkins: mondrian #1210

buildguy at pentaho.com buildguy at pentaho.com
Fri Oct 21 10:31:54 EDT 2011


See <http://ci.pentaho.com/job/mondrian/1210/changes>

Changes:

[Will Gorman] MONDRIAN: Updating version back to SNAPSHOT now that we've released Mondrian 3.3.0.14703

[Luc Boudreau] MONDRIAN: Adds SegmentCacheTest.testDisableCache() to make sure we can disable the segment cache at runtime using MondrianProperties. Also makes the test BasicQueryTest.testConcurrentStatementRun() more deterministic and "gracefully cleaned".

[Luc Boudreau] MONDRIAN: Fixes an issue with the test suite and the SegmentCache property. Setting it to null at runtime wouldn't disable the cache if one was previously configured.

[pentaho_buildguy] MONDRIAN: Updating version for rebuild

[Luc Boudreau] MONDRIAN: [MONDRIAN-1018] Makes use of the schema's checksum for SegmentHeader, if available.

[pentaho_buildguy] MONDRIAN: Updating version for Mondrian 3.3.0.14701 rebuild

[Luc Boudreau] MONDRIAN: Prevents a useless tear-down call within the SegmentCacheWorker.

[pentaho_buildguy] MONDRIAN: Updating rev for 3.3.0.14699 release build

[Luc Boudreau] MONDRIAN: [MONDRIAN-1014] Fixes an issue where executing a statement twice concurrently wouldn't work because the RolapConnection class wasn't cleaning up properly if the same statement was executed concurrently. Also wraps the call to statement.cancel() in a try/catch block when handling errors in RolapConnection.execute() so that we throw back the correct exception instead of the one caused when cleaning up. If a statement concurrency problem is detected in the normal execution path, calling statement.end() will fail every time and prevent the user from seeing the correct cause of the exception. Also adds a test case to prevent any further problems associated to the concurrent execution of statements.

[Luc Boudreau] MONDRIAN: Removes a call to executor.shutdownNow() when a thread is interrupted. There is no need to force an early shutdown at that point.

[Luc Boudreau] MONDRIAN: Removes the hook to the Runtime instance for statement cleanup. This code is useless, since all threads are marked as daemons and thus get cleaned up properly. We originally added that hook suspecting a JVM hang at shutdown was caused by the RolapResultShepherd, but it turns out it was caused by something else.

[Luc Boudreau] MONDRIAN: [MONDRIAN-1010] The RolapCubeHierarchy was creating a cached member reader even through the EnableRolapCubeMemberCache property was set to false. This would lead to inconsistent cache state. The parent-children caches would get updated by the cache control API, but the ROLAP layer wouldn't for level members. I've also extended the test suite to detect that in the future.

[Luc Boudreau] MONDRIAN: [PSW-120] Adds support in PSW for the Hive, Greenplum and Vectorwise dialects.

[Luc Boudreau] MONDRIAN: [PSW-119] Boolean typed attributes must be initialized at creation, even though the schema wasn't defining a value (was using default) or else a checkbox won't appear on Linux.

[Luc Boudreau] MONDRIAN: Adds the visible property to Dimension tree elements.

[pentaho_buildguy] MONDRIAN: 3.3.0.14682 release

[pentaho_buildguy] MONDRIAN: Changing dependencies for 3.3.0.14680 release

[pentaho_buildguy] MONDRIAN: Mondrian 3.3.0.14680 release

[Julian Hyde] MONDRIAN: Code formatting.

[Luc Boudreau] MONDRIAN: Fixes a version number omitted update.

[Luc Boudreau] MONDRIAN: Modifies the RELEASE.txt file prior to the 3.3.0 release.

------------------------------------------
[...truncated 1801 lines...]
   [resgen] <http://ci.pentaho.com/job/mondrian/ws/classes/mondrian/resource/MondrianResource.properties> is up to date
   [resgen] <http://ci.pentaho.com/job/mondrian/ws/src/main/mondrian/resource/MondrianResource_en_US.java> is up to date
   [resgen] <http://ci.pentaho.com/job/mondrian/ws/classes/mondrian/resource/MondrianResource_en_US.properties> is up to date
   [resgen] <http://ci.pentaho.com/job/mondrian/ws/src/main/mondrian/resource/MondrianResource_de_DE.java> is up to date
   [resgen] <http://ci.pentaho.com/job/mondrian/ws/classes/mondrian/resource/MondrianResource_de_DE.properties> is up to date
   [resgen] <http://ci.pentaho.com/job/mondrian/ws/src/main/mondrian/resource/MondrianResource_de.java> is up to date
   [resgen] <http://ci.pentaho.com/job/mondrian/ws/classes/mondrian/resource/MondrianResource_de.properties> is up to date
   [resgen] <http://ci.pentaho.com/job/mondrian/ws/src/main/mondrian/resource/MondrianResource_es_ES.java> is up to date
   [resgen] <http://ci.pentaho.com/job/mondrian/ws/classes/mondrian/resource/MondrianResource_es_ES.properties> is up to date

generate.properties:
     [java] Generating src/main/mondrian/olap/MondrianProperties.java
     [java] Generating doc/properties.html
     [java] Generating mondrian.properties.template

def:

compile.java:
    [javac] Compiling 9 source files to <http://ci.pentaho.com/job/mondrian/ws/classes>
    [javac] Note: <http://ci.pentaho.com/job/mondrian/ws/src/main/mondrian/parser/MdxParserImplTokenManager.java> uses or overrides a deprecated API.
    [javac] Note: Recompile with -Xlint:deprecation for details.
     [copy] Copying 1 file to <http://ci.pentaho.com/job/mondrian/ws/classes>

compile:

info:
     [echo] ==============================================================
     [echo] | Mondrian configuration info                                |
     [echo] ==============================================================
     [echo] project.location             = <http://ci.pentaho.com/job/mondrian/ws/>
     [echo] jdk.home                     = /opt/java5
     [echo] log4j.configuration          = log4j.properties
     [echo] mondrian.foodmart.catalogURL = <http://ci.pentaho.com/job/mondrian/ws/demo/FoodMart.xml>
     [echo] mondrian.foodmart.jdbcURL    = jdbc:mysql://localhost/foodmart
     [echo] mondrian.jdbcDrivers         = com.mysql.jdbc.Driver
     [echo] driver.classpath (additions) = /usr/share/java/mysql-connector-java.jar
     [echo] ==============================================================

compile.tests:
     [echo] Test Classpath: <http://ci.pentaho.com/job/mondrian/ws/lib/asm-commons.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/asm-tree.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/asm-util.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/asm.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/backport-util-concurrent.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/commons-collections.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/commons-dbcp.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/commons-io.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/commons-lang.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/commons-logging.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/commons-math.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/commons-pool.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/commons-vfs.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/derby.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/dom4j.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/eigenbase-properties.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/eigenbase-resgen.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/eigenbase-xom.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/hsqldb.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/javacc.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/javacup.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/jlfgr.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/jsp-api.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/junit.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/log4j.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/mondrian-jdk14.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/mondrian.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/olap4j-jdk14.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/olap4j-source.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/olap4j-tck.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/olap4j-xmla.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/olap4j.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/retroweaver-rt.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/retroweaver.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/servlet-api.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/workbench.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/xalan.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/xercesImpl.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/xml-apis.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/lib/xmlunit.jar>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/classes>
     [echo]  <http://ci.pentaho.com/job/mondrian/ws/testclasses>

set.connectString:

junit-main:
    [mkdir] Created dir: <http://ci.pentaho.com/job/mondrian/ws/junit-results>
    [junit] Running mondrian.test.Main
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=, DIMENSION_UNIQUE_NAME=[Store], HIERARCHY_NAME=Store, HIERARCHY_UNIQUE_NAME=[Store], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=63, DEFAULT_MEMBER=[Store].[All Stores], ALL_MEMBER=[Store].[All Stores], DESCRIPTION= Cube - Store Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=1, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=, DIMENSION_UNIQUE_NAME=[Store Size in SQFT], HIERARCHY_NAME=Store Size in SQFT, HIERARCHY_UNIQUE_NAME=[Store Size in SQFT], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store Size in SQFT, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=22, DEFAULT_MEMBER=[Store Size in SQFT].[All Store Size in SQFTs], ALL_MEMBER=[Store Size in SQFT].[All Store Size in SQFTs], DESCRIPTION= Cube - Store Size in SQFT Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=2, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=, DIMENSION_UNIQUE_NAME=[Store Type], HIERARCHY_NAME=Store Type, HIERARCHY_UNIQUE_NAME=[Store Type], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store Type, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=7, DEFAULT_MEMBER=[Store Type].[All Store Types], ALL_MEMBER=[Store Type].[All Store Types], DESCRIPTION= Cube - Store Type Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=3, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=, DIMENSION_UNIQUE_NAME=[Time], HIERARCHY_NAME=Time, HIERARCHY_UNIQUE_NAME=[Time], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Time, DIMENSION_TYPE=1, HIERARCHY_CARDINALITY=34, DEFAULT_MEMBER=[Time].[1997], ALL_MEMBER=null, DESCRIPTION= Cube - Time Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=4, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=, DIMENSION_UNIQUE_NAME=[Time], HIERARCHY_NAME=Time.Weekly, HIERARCHY_UNIQUE_NAME=[Time.Weekly], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Weekly, DIMENSION_TYPE=1, HIERARCHY_CARDINALITY=837, DEFAULT_MEMBER=[Time.Weekly].[All Time.Weeklys], ALL_MEMBER=[Time.Weekly].[All Time.Weeklys], DESCRIPTION= Cube - Time.Weekly Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=5, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=, DIMENSION_UNIQUE_NAME=[Warehouse], HIERARCHY_NAME=Warehouse, HIERARCHY_UNIQUE_NAME=[Warehouse], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Warehouse, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=61, DEFAULT_MEMBER=[Warehouse].[All Warehouses], ALL_MEMBER=[Warehouse].[All Warehouses], DESCRIPTION= Cube - Warehouse Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=6, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=HR, DIMENSION_UNIQUE_NAME=[Measures], HIERARCHY_NAME=Measures, HIERARCHY_UNIQUE_NAME=[Measures], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Measures, DIMENSION_TYPE=2, HIERARCHY_CARDINALITY=5, DEFAULT_MEMBER=[Measures].[Org Salary], ALL_MEMBER=null, DESCRIPTION=HR Cube - Measures Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=0, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=HR, DIMENSION_UNIQUE_NAME=[Time], HIERARCHY_NAME=Time, HIERARCHY_UNIQUE_NAME=[Time], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Time, DIMENSION_TYPE=1, HIERARCHY_CARDINALITY=34, DEFAULT_MEMBER=[Time].[1997], ALL_MEMBER=null, DESCRIPTION=HR Cube - Time Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=1, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=HR, DIMENSION_UNIQUE_NAME=[Store], HIERARCHY_NAME=Store, HIERARCHY_UNIQUE_NAME=[Store], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=63, DEFAULT_MEMBER=[Store].[All Stores], ALL_MEMBER=[Store].[All Stores], DESCRIPTION=HR Cube - Store Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=2, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=HR, DIMENSION_UNIQUE_NAME=[Pay Type], HIERARCHY_NAME=Pay Type, HIERARCHY_UNIQUE_NAME=[Pay Type], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Pay Type, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=3, DEFAULT_MEMBER=[Pay Type].[All Pay Types], ALL_MEMBER=[Pay Type].[All Pay Types], DESCRIPTION=HR Cube - Pay Type Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=3, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=HR, DIMENSION_UNIQUE_NAME=[Store Type], HIERARCHY_NAME=Store Type, HIERARCHY_UNIQUE_NAME=[Store Type], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store Type, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=7, DEFAULT_MEMBER=[Store Type].[All Store Types], ALL_MEMBER=[Store Type].[All Store Types], DESCRIPTION=HR Cube - Store Type Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=4, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=HR, DIMENSION_UNIQUE_NAME=[Position], HIERARCHY_NAME=Position, HIERARCHY_UNIQUE_NAME=[Position], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Position, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=24, DEFAULT_MEMBER=[Position].[All Position], ALL_MEMBER=[Position].[All Position], DESCRIPTION=HR Cube - Position Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=5, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=HR, DIMENSION_UNIQUE_NAME=[Department], HIERARCHY_NAME=Department, HIERARCHY_UNIQUE_NAME=[Department], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Department, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=13, DEFAULT_MEMBER=[Department].[All Departments], ALL_MEMBER=[Department].[All Departments], DESCRIPTION=HR Cube - Department Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=6, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=HR, DIMENSION_UNIQUE_NAME=[Employees], HIERARCHY_NAME=Employees, HIERARCHY_UNIQUE_NAME=[Employees], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Employees, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=1156, DEFAULT_MEMBER=[Employees].[All Employees], ALL_MEMBER=[Employees].[All Employees], DESCRIPTION=HR Cube - Employees Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=7, DIMENSION_IS_SHARED=true, PARENT_CHILD=true
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Measures], HIERARCHY_NAME=Measures, HIERARCHY_UNIQUE_NAME=[Measures], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Measures, DIMENSION_TYPE=2, HIERARCHY_CARDINALITY=9, DEFAULT_MEMBER=[Measures].[Unit Sales], ALL_MEMBER=null, DESCRIPTION=Sales Cube - Measures Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=0, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Store], HIERARCHY_NAME=Store, HIERARCHY_UNIQUE_NAME=[Store], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=63, DEFAULT_MEMBER=[Store].[All Stores], ALL_MEMBER=[Store].[All Stores], DESCRIPTION=Sales Cube - Store Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=1, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Store Size in SQFT], HIERARCHY_NAME=Store Size in SQFT, HIERARCHY_UNIQUE_NAME=[Store Size in SQFT], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store Size in SQFT, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=22, DEFAULT_MEMBER=[Store Size in SQFT].[All Store Size in SQFTs], ALL_MEMBER=[Store Size in SQFT].[All Store Size in SQFTs], DESCRIPTION=Sales Cube - Store Size in SQFT Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=2, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Store Type], HIERARCHY_NAME=Store Type, HIERARCHY_UNIQUE_NAME=[Store Type], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store Type, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=7, DEFAULT_MEMBER=[Store Type].[All Store Types], ALL_MEMBER=[Store Type].[All Store Types], DESCRIPTION=Sales Cube - Store Type Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=3, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Time], HIERARCHY_NAME=Time, HIERARCHY_UNIQUE_NAME=[Time], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Time, DIMENSION_TYPE=1, HIERARCHY_CARDINALITY=34, DEFAULT_MEMBER=[Time].[1997], ALL_MEMBER=null, DESCRIPTION=Sales Cube - Time Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=4, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Time], HIERARCHY_NAME=Time.Weekly, HIERARCHY_UNIQUE_NAME=[Time.Weekly], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Weekly, DIMENSION_TYPE=1, HIERARCHY_CARDINALITY=837, DEFAULT_MEMBER=[Time.Weekly].[All Time.Weeklys], ALL_MEMBER=[Time.Weekly].[All Time.Weeklys], DESCRIPTION=Sales Cube - Time.Weekly Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=5, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Product], HIERARCHY_NAME=Product, HIERARCHY_UNIQUE_NAME=[Product], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Product, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=2256, DEFAULT_MEMBER=[Product].[All Products], ALL_MEMBER=[Product].[All Products], DESCRIPTION=Sales Cube - Product Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=6, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Promotion Media], HIERARCHY_NAME=Promotion Media, HIERARCHY_UNIQUE_NAME=[Promotion Media], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Promotion Media, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=15, DEFAULT_MEMBER=[Promotion Media].[All Media], ALL_MEMBER=[Promotion Media].[All Media], DESCRIPTION=Sales Cube - Promotion Media Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=7, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Promotions], HIERARCHY_NAME=Promotions, HIERARCHY_UNIQUE_NAME=[Promotions], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Promotions, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=52, DEFAULT_MEMBER=[Promotions].[All Promotions], ALL_MEMBER=[Promotions].[All Promotions], DESCRIPTION=Sales Cube - Promotions Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=8, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Customers], HIERARCHY_NAME=Customers, HIERARCHY_UNIQUE_NAME=[Customers], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Customers, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=10407, DEFAULT_MEMBER=[Customers].[All Customers], ALL_MEMBER=[Customers].[All Customers], DESCRIPTION=Sales Cube - Customers Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=9, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Education Level], HIERARCHY_NAME=Education Level, HIERARCHY_UNIQUE_NAME=[Education Level], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Education Level, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=6, DEFAULT_MEMBER=[Education Level].[All Education Levels], ALL_MEMBER=[Education Level].[All Education Levels], DESCRIPTION=Sales Cube - Education Level Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=10, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Gender], HIERARCHY_NAME=Gender, HIERARCHY_UNIQUE_NAME=[Gender], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Gender, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=3, DEFAULT_MEMBER=[Gender].[All Gender], ALL_MEMBER=[Gender].[All Gender], DESCRIPTION=Sales Cube - Gender Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=11, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Marital Status], HIERARCHY_NAME=Marital Status, HIERARCHY_UNIQUE_NAME=[Marital Status], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Marital Status, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=112, DEFAULT_MEMBER=[Marital Status].[All Marital Status], ALL_MEMBER=[Marital Status].[All Marital Status], DESCRIPTION=Sales Cube - Marital Status Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=12, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Yearly Income], HIERARCHY_NAME=Yearly Income, HIERARCHY_UNIQUE_NAME=[Yearly Income], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Yearly Income, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=9, DEFAULT_MEMBER=[Yearly Income].[All Yearly Incomes], ALL_MEMBER=[Yearly Income].[All Yearly Incomes], DESCRIPTION=Sales Cube - Yearly Income Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=13, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales 2, DIMENSION_UNIQUE_NAME=[Measures], HIERARCHY_NAME=Measures, HIERARCHY_UNIQUE_NAME=[Measures], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Measures, DIMENSION_TYPE=2, HIERARCHY_CARDINALITY=7, DEFAULT_MEMBER=[Measures].[Sales Count], ALL_MEMBER=null, DESCRIPTION=Sales 2 Cube - Measures Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=0, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales 2, DIMENSION_UNIQUE_NAME=[Time], HIERARCHY_NAME=Time, HIERARCHY_UNIQUE_NAME=[Time], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Time, DIMENSION_TYPE=1, HIERARCHY_CARDINALITY=34, DEFAULT_MEMBER=[Time].[1997], ALL_MEMBER=null, DESCRIPTION=Sales 2 Cube - Time Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=1, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales 2, DIMENSION_UNIQUE_NAME=[Time], HIERARCHY_NAME=Time.Weekly, HIERARCHY_UNIQUE_NAME=[Time.Weekly], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Weekly, DIMENSION_TYPE=1, HIERARCHY_CARDINALITY=837, DEFAULT_MEMBER=[Time.Weekly].[All Time.Weeklys], ALL_MEMBER=[Time.Weekly].[All Time.Weeklys], DESCRIPTION=Sales 2 Cube - Time.Weekly Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=2, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales 2, DIMENSION_UNIQUE_NAME=[Product], HIERARCHY_NAME=Product, HIERARCHY_UNIQUE_NAME=[Product], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Product, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=2256, DEFAULT_MEMBER=[Product].[All Products], ALL_MEMBER=[Product].[All Products], DESCRIPTION=Sales 2 Cube - Product Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=3, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales 2, DIMENSION_UNIQUE_NAME=[Gender], HIERARCHY_NAME=Gender, HIERARCHY_UNIQUE_NAME=[Gender], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Gender, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=3, DEFAULT_MEMBER=[Gender].[All Gender], ALL_MEMBER=[Gender].[All Gender], DESCRIPTION=Sales 2 Cube - Gender Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=4, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Measures], HIERARCHY_NAME=Measures, HIERARCHY_UNIQUE_NAME=[Measures], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Measures, DIMENSION_TYPE=2, HIERARCHY_CARDINALITY=5, DEFAULT_MEMBER=[Measures].[Unit Sales], ALL_MEMBER=null, DESCRIPTION=Sales Ragged Cube - Measures Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=0, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Store], HIERARCHY_NAME=Store, HIERARCHY_UNIQUE_NAME=[Store], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=68, DEFAULT_MEMBER=[Store].[All Stores], ALL_MEMBER=[Store].[All Stores], DESCRIPTION=Sales Ragged Cube - Store Hierarchy, STRUCTURE=1, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=1, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Geography], HIERARCHY_NAME=Geography, HIERARCHY_UNIQUE_NAME=[Geography], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Geography, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=43, DEFAULT_MEMBER=[Geography].[All Geographys], ALL_MEMBER=[Geography].[All Geographys], DESCRIPTION=Sales Ragged Cube - Geography Hierarchy, STRUCTURE=1, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=2, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Store Size in SQFT], HIERARCHY_NAME=Store Size in SQFT, HIERARCHY_UNIQUE_NAME=[Store Size in SQFT], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store Size in SQFT, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=22, DEFAULT_MEMBER=[Store Size in SQFT].[All Store Size in SQFTs], ALL_MEMBER=[Store Size in SQFT].[All Store Size in SQFTs], DESCRIPTION=Sales Ragged Cube - Store Size in SQFT Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=3, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Store Type], HIERARCHY_NAME=Store Type, HIERARCHY_UNIQUE_NAME=[Store Type], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store Type, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=7, DEFAULT_MEMBER=[Store Type].[All Store Types], ALL_MEMBER=[Store Type].[All Store Types], DESCRIPTION=Sales Ragged Cube - Store Type Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=4, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Time], HIERARCHY_NAME=Time, HIERARCHY_UNIQUE_NAME=[Time], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Time, DIMENSION_TYPE=1, HIERARCHY_CARDINALITY=34, DEFAULT_MEMBER=[Time].[1997], ALL_MEMBER=null, DESCRIPTION=Sales Ragged Cube - Time Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=5, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Time], HIERARCHY_NAME=Time.Weekly, HIERARCHY_UNIQUE_NAME=[Time.Weekly], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Weekly, DIMENSION_TYPE=1, HIERARCHY_CARDINALITY=837, DEFAULT_MEMBER=[Time.Weekly].[All Time.Weeklys], ALL_MEMBER=[Time.Weekly].[All Time.Weeklys], DESCRIPTION=Sales Ragged Cube - Time.Weekly Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=6, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Product], HIERARCHY_NAME=Product, HIERARCHY_UNIQUE_NAME=[Product], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Product, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=2256, DEFAULT_MEMBER=[Product].[All Products], ALL_MEMBER=[Product].[All Products], DESCRIPTION=Sales Ragged Cube - Product Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=7, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Promotion Media], HIERARCHY_NAME=Promotion Media, HIERARCHY_UNIQUE_NAME=[Promotion Media], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Promotion Media, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=15, DEFAULT_MEMBER=[Promotion Media].[All Media], ALL_MEMBER=[Promotion Media].[All Media], DESCRIPTION=Sales Ragged Cube - Promotion Media Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=8, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Promotions], HIERARCHY_NAME=Promotions, HIERARCHY_UNIQUE_NAME=[Promotions], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Promotions, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=52, DEFAULT_MEMBER=[Promotions].[All Promotions], ALL_MEMBER=[Promotions].[All Promotions], DESCRIPTION=Sales Ragged Cube - Promotions Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=9, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Customers], HIERARCHY_NAME=Customers, HIERARCHY_UNIQUE_NAME=[Customers], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Customers, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=10307, DEFAULT_MEMBER=[Customers].[All Customers], ALL_MEMBER=[Customers].[All Customers], DESCRIPTION=Sales Ragged Cube - Customers Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=10, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Education Level], HIERARCHY_NAME=Education Level, HIERARCHY_UNIQUE_NAME=[Education Level], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Education Level, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=6, DEFAULT_MEMBER=[Education Level].[All Education Levels], ALL_MEMBER=[Education Level].[All Education Levels], DESCRIPTION=Sales Ragged Cube - Education Level Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=11, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Gender], HIERARCHY_NAME=Gender, HIERARCHY_UNIQUE_NAME=[Gender], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Gender, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=3, DEFAULT_MEMBER=[Gender].[All Gender], ALL_MEMBER=[Gender].[All Gender], DESCRIPTION=Sales Ragged Cube - Gender Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=12, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Marital Status], HIERARCHY_NAME=Marital Status, HIERARCHY_UNIQUE_NAME=[Marital Status], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Marital Status, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=3, DEFAULT_MEMBER=[Marital Status].[All Marital Status], ALL_MEMBER=[Marital Status].[All Marital Status], DESCRIPTION=Sales Ragged Cube - Marital Status Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=13, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Yearly Income], HIERARCHY_NAME=Yearly Income, HIERARCHY_UNIQUE_NAME=[Yearly Income], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Yearly Income, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=9, DEFAULT_MEMBER=[Yearly Income].[All Yearly Incomes], ALL_MEMBER=[Yearly Income].[All Yearly Incomes], DESCRIPTION=Sales Ragged Cube - Yearly Income Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=14, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Store, DIMENSION_UNIQUE_NAME=[Measures], HIERARCHY_NAME=Measures, HIERARCHY_UNIQUE_NAME=[Measures], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Measures, DIMENSION_TYPE=2, HIERARCHY_CARDINALITY=3, DEFAULT_MEMBER=[Measures].[Store Sqft], ALL_MEMBER=null, DESCRIPTION=Store Cube - Measures Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=0, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Store, DIMENSION_UNIQUE_NAME=[Store Type], HIERARCHY_NAME=Store Type, HIERARCHY_UNIQUE_NAME=[Store Type], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store Type, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=7, DEFAULT_MEMBER=[Store Type].[All Store Types], ALL_MEMBER=[Store Type].[All Store Types], DESCRIPTION=Store Cube - Store Type Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=1, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Store, DIMENSION_UNIQUE_NAME=[Store], HIERARCHY_NAME=Store, HIERARCHY_UNIQUE_NAME=[Store], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=63, DEFAULT_MEMBER=[Store].[All Stores], ALL_MEMBER=[Store].[All Stores], DESCRIPTION=Store Cube - Store Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=2, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Store, DIMENSION_UNIQUE_NAME=[Has coffee bar], HIERARCHY_NAME=Has coffee bar, HIERARCHY_UNIQUE_NAME=[Has coffee bar], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Has coffee bar, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=3, DEFAULT_MEMBER=[Has coffee bar].[All Has coffee bars], ALL_MEMBER=[Has coffee bar].[All Has coffee bars], DESCRIPTION=Store Cube - Has coffee bar Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=3, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse, DIMENSION_UNIQUE_NAME=[Measures], HIERARCHY_NAME=Measures, HIERARCHY_UNIQUE_NAME=[Measures], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Measures, DIMENSION_TYPE=2, HIERARCHY_CARDINALITY=9, DEFAULT_MEMBER=[Measures].[Store Invoice], ALL_MEMBER=null, DESCRIPTION=Warehouse Cube - Measures Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=0, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse, DIMENSION_UNIQUE_NAME=[Store], HIERARCHY_NAME=Store, HIERARCHY_UNIQUE_NAME=[Store], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=63, DEFAULT_MEMBER=[Store].[All Stores], ALL_MEMBER=[Store].[All Stores], DESCRIPTION=Warehouse Cube - Store Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=1, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse, DIMENSION_UNIQUE_NAME=[Store Size in SQFT], HIERARCHY_NAME=Store Size in SQFT, HIERARCHY_UNIQUE_NAME=[Store Size in SQFT], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store Size in SQFT, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=22, DEFAULT_MEMBER=[Store Size in SQFT].[All Store Size in SQFTs], ALL_MEMBER=[Store Size in SQFT].[All Store Size in SQFTs], DESCRIPTION=Warehouse Cube - Store Size in SQFT Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=2, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse, DIMENSION_UNIQUE_NAME=[Store Type], HIERARCHY_NAME=Store Type, HIERARCHY_UNIQUE_NAME=[Store Type], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store Type, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=7, DEFAULT_MEMBER=[Store Type].[All Store Types], ALL_MEMBER=[Store Type].[All Store Types], DESCRIPTION=Warehouse Cube - Store Type Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=3, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse, DIMENSION_UNIQUE_NAME=[Time], HIERARCHY_NAME=Time, HIERARCHY_UNIQUE_NAME=[Time], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Time, DIMENSION_TYPE=1, HIERARCHY_CARDINALITY=34, DEFAULT_MEMBER=[Time].[1997], ALL_MEMBER=null, DESCRIPTION=Warehouse Cube - Time Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=4, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse, DIMENSION_UNIQUE_NAME=[Time], HIERARCHY_NAME=Time.Weekly, HIERARCHY_UNIQUE_NAME=[Time.Weekly], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Weekly, DIMENSION_TYPE=1, HIERARCHY_CARDINALITY=837, DEFAULT_MEMBER=[Time.Weekly].[All Time.Weeklys], ALL_MEMBER=[Time.Weekly].[All Time.Weeklys], DESCRIPTION=Warehouse Cube - Time.Weekly Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=5, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse, DIMENSION_UNIQUE_NAME=[Product], HIERARCHY_NAME=Product, HIERARCHY_UNIQUE_NAME=[Product], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Product, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=2256, DEFAULT_MEMBER=[Product].[All Products], ALL_MEMBER=[Product].[All Products], DESCRIPTION=Warehouse Cube - Product Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=6, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse, DIMENSION_UNIQUE_NAME=[Warehouse], HIERARCHY_NAME=Warehouse, HIERARCHY_UNIQUE_NAME=[Warehouse], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Warehouse, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=61, DEFAULT_MEMBER=[Warehouse].[All Warehouses], ALL_MEMBER=[Warehouse].[All Warehouses], DESCRIPTION=Warehouse Cube - Warehouse Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=7, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse and Sales, DIMENSION_UNIQUE_NAME=[Measures], HIERARCHY_NAME=Measures, HIERARCHY_UNIQUE_NAME=[Measures], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Measures, DIMENSION_TYPE=2, HIERARCHY_CARDINALITY=15, DEFAULT_MEMBER=[Measures].[Store Sales], ALL_MEMBER=null, DESCRIPTION=Warehouse and Sales Cube - Measures Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=0, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse and Sales, DIMENSION_UNIQUE_NAME=[Customers], HIERARCHY_NAME=Customers, HIERARCHY_UNIQUE_NAME=[Customers], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Customers, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=10407, DEFAULT_MEMBER=[Customers].[All Customers], ALL_MEMBER=[Customers].[All Customers], DESCRIPTION=Warehouse and Sales Cube - Customers Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=1, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse and Sales, DIMENSION_UNIQUE_NAME=[Education Level], HIERARCHY_NAME=Education Level, HIERARCHY_UNIQUE_NAME=[Education Level], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Education Level, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=6, DEFAULT_MEMBER=[Education Level].[All Education Levels], ALL_MEMBER=[Education Level].[All Education Levels], DESCRIPTION=Warehouse and Sales Cube - Education Level Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=2, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse and Sales, DIMENSION_UNIQUE_NAME=[Gender], HIERARCHY_NAME=Gender, HIERARCHY_UNIQUE_NAME=[Gender], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Gender, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=3, DEFAULT_MEMBER=[Gender].[All Gender], ALL_MEMBER=[Gender].[All Gender], DESCRIPTION=Warehouse and Sales Cube - Gender Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=3, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse and Sales, DIMENSION_UNIQUE_NAME=[Marital Status], HIERARCHY_NAME=Marital Status, HIERARCHY_UNIQUE_NAME=[Marital Status], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Marital Status, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=112, DEFAULT_MEMBER=[Marital Status].[All Marital Status], ALL_MEMBER=[Marital Status].[All Marital Status], DESCRIPTION=Warehouse and Sales Cube - Marital Status Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=4, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse and Sales, DIMENSION_UNIQUE_NAME=[Product], HIERARCHY_NAME=Product, HIERARCHY_UNIQUE_NAME=[Product], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Product, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=2256, DEFAULT_MEMBER=[Product].[All Products], ALL_MEMBER=[Product].[All Products], DESCRIPTION=Warehouse and Sales Cube - Product Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=5, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse and Sales, DIMENSION_UNIQUE_NAME=[Promotion Media], HIERARCHY_NAME=Promotion Media, HIERARCHY_UNIQUE_NAME=[Promotion Media], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Promotion Media, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=15, DEFAULT_MEMBER=[Promotion Media].[All Media], ALL_MEMBER=[Promotion Media].[All Media], DESCRIPTION=Warehouse and Sales Cube - Promotion Media Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=6, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse and Sales, DIMENSION_UNIQUE_NAME=[Promotions], HIERARCHY_NAME=Promotions, HIERARCHY_UNIQUE_NAME=[Promotions], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Promotions, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=52, DEFAULT_MEMBER=[Promotions].[All Promotions], ALL_MEMBER=[Promotions].[All Promotions], DESCRIPTION=Warehouse and Sales Cube - Promotions Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=7, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse and Sales, DIMENSION_UNIQUE_NAME=[Store], HIERARCHY_NAME=Store, HIERARCHY_UNIQUE_NAME=[Store], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=63, DEFAULT_MEMBER=[Store].[All Stores], ALL_MEMBER=[Store].[All Stores], DESCRIPTION=Warehouse and Sales Cube - Store Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=8, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse and Sales, DIMENSION_UNIQUE_NAME=[Time], HIERARCHY_NAME=Time, HIERARCHY_UNIQUE_NAME=[Time], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Time, DIMENSION_TYPE=1, HIERARCHY_CARDINALITY=34, DEFAULT_MEMBER=[Time].[1997], ALL_MEMBER=null, DESCRIPTION=Warehouse and Sales Cube - Time Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=9, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse and Sales, DIMENSION_UNIQUE_NAME=[Time], HIERARCHY_NAME=Time.Weekly, HIERARCHY_UNIQUE_NAME=[Time.Weekly], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Weekly, DIMENSION_TYPE=1, HIERARCHY_CARDINALITY=837, DEFAULT_MEMBER=[Time.Weekly].[All Time.Weeklys], ALL_MEMBER=[Time.Weekly].[All Time.Weeklys], DESCRIPTION=Warehouse and Sales Cube - Time.Weekly Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=10, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse and Sales, DIMENSION_UNIQUE_NAME=[Yearly Income], HIERARCHY_NAME=Yearly Income, HIERARCHY_UNIQUE_NAME=[Yearly Income], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Yearly Income, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=9, DEFAULT_MEMBER=[Yearly Income].[All Yearly Incomes], ALL_MEMBER=[Yearly Income].[All Yearly Incomes], DESCRIPTION=Warehouse and Sales Cube - Yearly Income Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=11, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse and Sales, DIMENSION_UNIQUE_NAME=[Warehouse], HIERARCHY_NAME=Warehouse, HIERARCHY_UNIQUE_NAME=[Warehouse], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Warehouse, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=61, DEFAULT_MEMBER=[Warehouse].[All Warehouses], ALL_MEMBER=[Warehouse].[All Warehouses], DESCRIPTION=Warehouse and Sales Cube - Warehouse Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=12, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] ')
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=, DIMENSION_UNIQUE_NAME=[Store], HIERARCHY_NAME=Store, HIERARCHY_UNIQUE_NAME=[Store], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=63, DEFAULT_MEMBER=[Store].[All Stores], ALL_MEMBER=[Store].[All Stores], DESCRIPTION= Cube - Store Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=1, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=, DIMENSION_UNIQUE_NAME=[Store Size in SQFT], HIERARCHY_NAME=Store Size in SQFT, HIERARCHY_UNIQUE_NAME=[Store Size in SQFT], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store Size in SQFT, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=22, DEFAULT_MEMBER=[Store Size in SQFT].[All Store Size in SQFTs], ALL_MEMBER=[Store Size in SQFT].[All Store Size in SQFTs], DESCRIPTION= Cube - Store Size in SQFT Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=2, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=, DIMENSION_UNIQUE_NAME=[Store Type], HIERARCHY_NAME=Store Type, HIERARCHY_UNIQUE_NAME=[Store Type], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store Type, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=7, DEFAULT_MEMBER=[Store Type].[All Store Types], ALL_MEMBER=[Store Type].[All Store Types], DESCRIPTION= Cube - Store Type Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=3, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=, DIMENSION_UNIQUE_NAME=[Time], HIERARCHY_NAME=Time, HIERARCHY_UNIQUE_NAME=[Time], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Time, DIMENSION_TYPE=1, HIERARCHY_CARDINALITY=34, DEFAULT_MEMBER=[Time].[1997], ALL_MEMBER=null, DESCRIPTION= Cube - Time Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=4, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=, DIMENSION_UNIQUE_NAME=[Time], HIERARCHY_NAME=Time.Weekly, HIERARCHY_UNIQUE_NAME=[Time.Weekly], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Weekly, DIMENSION_TYPE=1, HIERARCHY_CARDINALITY=837, DEFAULT_MEMBER=[Time.Weekly].[All Time.Weeklys], ALL_MEMBER=[Time.Weekly].[All Time.Weeklys], DESCRIPTION= Cube - Time.Weekly Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=5, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=, DIMENSION_UNIQUE_NAME=[Warehouse], HIERARCHY_NAME=Warehouse, HIERARCHY_UNIQUE_NAME=[Warehouse], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Warehouse, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=61, DEFAULT_MEMBER=[Warehouse].[All Warehouses], ALL_MEMBER=[Warehouse].[All Warehouses], DESCRIPTION= Cube - Warehouse Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=6, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=HR, DIMENSION_UNIQUE_NAME=[Measures], HIERARCHY_NAME=Measures, HIERARCHY_UNIQUE_NAME=[Measures], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Measures, DIMENSION_TYPE=2, HIERARCHY_CARDINALITY=5, DEFAULT_MEMBER=[Measures].[Org Salary], ALL_MEMBER=null, DESCRIPTION=HR Cube - Measures Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=0, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=HR, DIMENSION_UNIQUE_NAME=[Time], HIERARCHY_NAME=Time, HIERARCHY_UNIQUE_NAME=[Time], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Time, DIMENSION_TYPE=1, HIERARCHY_CARDINALITY=34, DEFAULT_MEMBER=[Time].[1997], ALL_MEMBER=null, DESCRIPTION=HR Cube - Time Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=1, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=HR, DIMENSION_UNIQUE_NAME=[Store], HIERARCHY_NAME=Store, HIERARCHY_UNIQUE_NAME=[Store], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=63, DEFAULT_MEMBER=[Store].[All Stores], ALL_MEMBER=[Store].[All Stores], DESCRIPTION=HR Cube - Store Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=2, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=HR, DIMENSION_UNIQUE_NAME=[Pay Type], HIERARCHY_NAME=Pay Type, HIERARCHY_UNIQUE_NAME=[Pay Type], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Pay Type, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=3, DEFAULT_MEMBER=[Pay Type].[All Pay Types], ALL_MEMBER=[Pay Type].[All Pay Types], DESCRIPTION=HR Cube - Pay Type Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=3, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=HR, DIMENSION_UNIQUE_NAME=[Store Type], HIERARCHY_NAME=Store Type, HIERARCHY_UNIQUE_NAME=[Store Type], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store Type, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=7, DEFAULT_MEMBER=[Store Type].[All Store Types], ALL_MEMBER=[Store Type].[All Store Types], DESCRIPTION=HR Cube - Store Type Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=4, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=HR, DIMENSION_UNIQUE_NAME=[Position], HIERARCHY_NAME=Position, HIERARCHY_UNIQUE_NAME=[Position], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Position, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=24, DEFAULT_MEMBER=[Position].[All Position], ALL_MEMBER=[Position].[All Position], DESCRIPTION=HR Cube - Position Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=5, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=HR, DIMENSION_UNIQUE_NAME=[Department], HIERARCHY_NAME=Department, HIERARCHY_UNIQUE_NAME=[Department], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Department, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=13, DEFAULT_MEMBER=[Department].[All Departments], ALL_MEMBER=[Department].[All Departments], DESCRIPTION=HR Cube - Department Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=6, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=HR, DIMENSION_UNIQUE_NAME=[Employees], HIERARCHY_NAME=Employees, HIERARCHY_UNIQUE_NAME=[Employees], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Employees, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=1156, DEFAULT_MEMBER=[Employees].[All Employees], ALL_MEMBER=[Employees].[All Employees], DESCRIPTION=HR Cube - Employees Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=7, DIMENSION_IS_SHARED=true, PARENT_CHILD=true
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Measures], HIERARCHY_NAME=Measures, HIERARCHY_UNIQUE_NAME=[Measures], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Measures, DIMENSION_TYPE=2, HIERARCHY_CARDINALITY=9, DEFAULT_MEMBER=[Measures].[Unit Sales], ALL_MEMBER=null, DESCRIPTION=Sales Cube - Measures Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=0, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Store], HIERARCHY_NAME=Store, HIERARCHY_UNIQUE_NAME=[Store], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=63, DEFAULT_MEMBER=[Store].[All Stores], ALL_MEMBER=[Store].[All Stores], DESCRIPTION=Sales Cube - Store Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=1, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Store Size in SQFT], HIERARCHY_NAME=Store Size in SQFT, HIERARCHY_UNIQUE_NAME=[Store Size in SQFT], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store Size in SQFT, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=22, DEFAULT_MEMBER=[Store Size in SQFT].[All Store Size in SQFTs], ALL_MEMBER=[Store Size in SQFT].[All Store Size in SQFTs], DESCRIPTION=Sales Cube - Store Size in SQFT Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=2, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Store Type], HIERARCHY_NAME=Store Type, HIERARCHY_UNIQUE_NAME=[Store Type], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store Type, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=7, DEFAULT_MEMBER=[Store Type].[All Store Types], ALL_MEMBER=[Store Type].[All Store Types], DESCRIPTION=Sales Cube - Store Type Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=3, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Time], HIERARCHY_NAME=Time, HIERARCHY_UNIQUE_NAME=[Time], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Time, DIMENSION_TYPE=1, HIERARCHY_CARDINALITY=34, DEFAULT_MEMBER=[Time].[1997], ALL_MEMBER=null, DESCRIPTION=Sales Cube - Time Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=4, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Time], HIERARCHY_NAME=Time.Weekly, HIERARCHY_UNIQUE_NAME=[Time.Weekly], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Weekly, DIMENSION_TYPE=1, HIERARCHY_CARDINALITY=837, DEFAULT_MEMBER=[Time.Weekly].[All Time.Weeklys], ALL_MEMBER=[Time.Weekly].[All Time.Weeklys], DESCRIPTION=Sales Cube - Time.Weekly Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=5, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Product], HIERARCHY_NAME=Product, HIERARCHY_UNIQUE_NAME=[Product], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Product, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=2256, DEFAULT_MEMBER=[Product].[All Products], ALL_MEMBER=[Product].[All Products], DESCRIPTION=Sales Cube - Product Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=6, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Promotion Media], HIERARCHY_NAME=Promotion Media, HIERARCHY_UNIQUE_NAME=[Promotion Media], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Promotion Media, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=15, DEFAULT_MEMBER=[Promotion Media].[All Media], ALL_MEMBER=[Promotion Media].[All Media], DESCRIPTION=Sales Cube - Promotion Media Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=7, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Promotions], HIERARCHY_NAME=Promotions, HIERARCHY_UNIQUE_NAME=[Promotions], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Promotions, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=52, DEFAULT_MEMBER=[Promotions].[All Promotions], ALL_MEMBER=[Promotions].[All Promotions], DESCRIPTION=Sales Cube - Promotions Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=8, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Customers], HIERARCHY_NAME=Customers, HIERARCHY_UNIQUE_NAME=[Customers], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Customers, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=10407, DEFAULT_MEMBER=[Customers].[All Customers], ALL_MEMBER=[Customers].[All Customers], DESCRIPTION=Sales Cube - Customers Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=9, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Education Level], HIERARCHY_NAME=Education Level, HIERARCHY_UNIQUE_NAME=[Education Level], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Education Level, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=6, DEFAULT_MEMBER=[Education Level].[All Education Levels], ALL_MEMBER=[Education Level].[All Education Levels], DESCRIPTION=Sales Cube - Education Level Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=10, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Gender], HIERARCHY_NAME=Gender, HIERARCHY_UNIQUE_NAME=[Gender], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Gender, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=3, DEFAULT_MEMBER=[Gender].[All Gender], ALL_MEMBER=[Gender].[All Gender], DESCRIPTION=Sales Cube - Gender Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=11, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Marital Status], HIERARCHY_NAME=Marital Status, HIERARCHY_UNIQUE_NAME=[Marital Status], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Marital Status, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=112, DEFAULT_MEMBER=[Marital Status].[All Marital Status], ALL_MEMBER=[Marital Status].[All Marital Status], DESCRIPTION=Sales Cube - Marital Status Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=12, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales, DIMENSION_UNIQUE_NAME=[Yearly Income], HIERARCHY_NAME=Yearly Income, HIERARCHY_UNIQUE_NAME=[Yearly Income], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Yearly Income, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=9, DEFAULT_MEMBER=[Yearly Income].[All Yearly Incomes], ALL_MEMBER=[Yearly Income].[All Yearly Incomes], DESCRIPTION=Sales Cube - Yearly Income Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=13, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales 2, DIMENSION_UNIQUE_NAME=[Measures], HIERARCHY_NAME=Measures, HIERARCHY_UNIQUE_NAME=[Measures], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Measures, DIMENSION_TYPE=2, HIERARCHY_CARDINALITY=7, DEFAULT_MEMBER=[Measures].[Sales Count], ALL_MEMBER=null, DESCRIPTION=Sales 2 Cube - Measures Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=0, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales 2, DIMENSION_UNIQUE_NAME=[Time], HIERARCHY_NAME=Time, HIERARCHY_UNIQUE_NAME=[Time], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Time, DIMENSION_TYPE=1, HIERARCHY_CARDINALITY=34, DEFAULT_MEMBER=[Time].[1997], ALL_MEMBER=null, DESCRIPTION=Sales 2 Cube - Time Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=1, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales 2, DIMENSION_UNIQUE_NAME=[Time], HIERARCHY_NAME=Time.Weekly, HIERARCHY_UNIQUE_NAME=[Time.Weekly], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Weekly, DIMENSION_TYPE=1, HIERARCHY_CARDINALITY=837, DEFAULT_MEMBER=[Time.Weekly].[All Time.Weeklys], ALL_MEMBER=[Time.Weekly].[All Time.Weeklys], DESCRIPTION=Sales 2 Cube - Time.Weekly Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=2, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales 2, DIMENSION_UNIQUE_NAME=[Product], HIERARCHY_NAME=Product, HIERARCHY_UNIQUE_NAME=[Product], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Product, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=2256, DEFAULT_MEMBER=[Product].[All Products], ALL_MEMBER=[Product].[All Products], DESCRIPTION=Sales 2 Cube - Product Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=3, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales 2, DIMENSION_UNIQUE_NAME=[Gender], HIERARCHY_NAME=Gender, HIERARCHY_UNIQUE_NAME=[Gender], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Gender, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=3, DEFAULT_MEMBER=[Gender].[All Gender], ALL_MEMBER=[Gender].[All Gender], DESCRIPTION=Sales 2 Cube - Gender Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=4, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Measures], HIERARCHY_NAME=Measures, HIERARCHY_UNIQUE_NAME=[Measures], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Measures, DIMENSION_TYPE=2, HIERARCHY_CARDINALITY=5, DEFAULT_MEMBER=[Measures].[Unit Sales], ALL_MEMBER=null, DESCRIPTION=Sales Ragged Cube - Measures Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=0, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Store], HIERARCHY_NAME=Store, HIERARCHY_UNIQUE_NAME=[Store], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=68, DEFAULT_MEMBER=[Store].[All Stores], ALL_MEMBER=[Store].[All Stores], DESCRIPTION=Sales Ragged Cube - Store Hierarchy, STRUCTURE=1, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=1, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Geography], HIERARCHY_NAME=Geography, HIERARCHY_UNIQUE_NAME=[Geography], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Geography, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=43, DEFAULT_MEMBER=[Geography].[All Geographys], ALL_MEMBER=[Geography].[All Geographys], DESCRIPTION=Sales Ragged Cube - Geography Hierarchy, STRUCTURE=1, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=2, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Store Size in SQFT], HIERARCHY_NAME=Store Size in SQFT, HIERARCHY_UNIQUE_NAME=[Store Size in SQFT], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store Size in SQFT, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=22, DEFAULT_MEMBER=[Store Size in SQFT].[All Store Size in SQFTs], ALL_MEMBER=[Store Size in SQFT].[All Store Size in SQFTs], DESCRIPTION=Sales Ragged Cube - Store Size in SQFT Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=3, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Store Type], HIERARCHY_NAME=Store Type, HIERARCHY_UNIQUE_NAME=[Store Type], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store Type, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=7, DEFAULT_MEMBER=[Store Type].[All Store Types], ALL_MEMBER=[Store Type].[All Store Types], DESCRIPTION=Sales Ragged Cube - Store Type Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=4, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Time], HIERARCHY_NAME=Time, HIERARCHY_UNIQUE_NAME=[Time], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Time, DIMENSION_TYPE=1, HIERARCHY_CARDINALITY=34, DEFAULT_MEMBER=[Time].[1997], ALL_MEMBER=null, DESCRIPTION=Sales Ragged Cube - Time Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=5, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Time], HIERARCHY_NAME=Time.Weekly, HIERARCHY_UNIQUE_NAME=[Time.Weekly], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Weekly, DIMENSION_TYPE=1, HIERARCHY_CARDINALITY=837, DEFAULT_MEMBER=[Time.Weekly].[All Time.Weeklys], ALL_MEMBER=[Time.Weekly].[All Time.Weeklys], DESCRIPTION=Sales Ragged Cube - Time.Weekly Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=6, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Product], HIERARCHY_NAME=Product, HIERARCHY_UNIQUE_NAME=[Product], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Product, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=2256, DEFAULT_MEMBER=[Product].[All Products], ALL_MEMBER=[Product].[All Products], DESCRIPTION=Sales Ragged Cube - Product Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=7, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Promotion Media], HIERARCHY_NAME=Promotion Media, HIERARCHY_UNIQUE_NAME=[Promotion Media], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Promotion Media, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=15, DEFAULT_MEMBER=[Promotion Media].[All Media], ALL_MEMBER=[Promotion Media].[All Media], DESCRIPTION=Sales Ragged Cube - Promotion Media Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=8, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Promotions], HIERARCHY_NAME=Promotions, HIERARCHY_UNIQUE_NAME=[Promotions], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Promotions, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=52, DEFAULT_MEMBER=[Promotions].[All Promotions], ALL_MEMBER=[Promotions].[All Promotions], DESCRIPTION=Sales Ragged Cube - Promotions Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=9, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Customers], HIERARCHY_NAME=Customers, HIERARCHY_UNIQUE_NAME=[Customers], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Customers, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=10307, DEFAULT_MEMBER=[Customers].[All Customers], ALL_MEMBER=[Customers].[All Customers], DESCRIPTION=Sales Ragged Cube - Customers Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=10, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Education Level], HIERARCHY_NAME=Education Level, HIERARCHY_UNIQUE_NAME=[Education Level], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Education Level, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=6, DEFAULT_MEMBER=[Education Level].[All Education Levels], ALL_MEMBER=[Education Level].[All Education Levels], DESCRIPTION=Sales Ragged Cube - Education Level Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=11, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Gender], HIERARCHY_NAME=Gender, HIERARCHY_UNIQUE_NAME=[Gender], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Gender, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=3, DEFAULT_MEMBER=[Gender].[All Gender], ALL_MEMBER=[Gender].[All Gender], DESCRIPTION=Sales Ragged Cube - Gender Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=12, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Marital Status], HIERARCHY_NAME=Marital Status, HIERARCHY_UNIQUE_NAME=[Marital Status], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Marital Status, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=3, DEFAULT_MEMBER=[Marital Status].[All Marital Status], ALL_MEMBER=[Marital Status].[All Marital Status], DESCRIPTION=Sales Ragged Cube - Marital Status Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=13, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Sales Ragged, DIMENSION_UNIQUE_NAME=[Yearly Income], HIERARCHY_NAME=Yearly Income, HIERARCHY_UNIQUE_NAME=[Yearly Income], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Yearly Income, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=9, DEFAULT_MEMBER=[Yearly Income].[All Yearly Incomes], ALL_MEMBER=[Yearly Income].[All Yearly Incomes], DESCRIPTION=Sales Ragged Cube - Yearly Income Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=14, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Store, DIMENSION_UNIQUE_NAME=[Measures], HIERARCHY_NAME=Measures, HIERARCHY_UNIQUE_NAME=[Measures], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Measures, DIMENSION_TYPE=2, HIERARCHY_CARDINALITY=3, DEFAULT_MEMBER=[Measures].[Store Sqft], ALL_MEMBER=null, DESCRIPTION=Store Cube - Measures Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=0, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Store, DIMENSION_UNIQUE_NAME=[Store Type], HIERARCHY_NAME=Store Type, HIERARCHY_UNIQUE_NAME=[Store Type], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store Type, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=7, DEFAULT_MEMBER=[Store Type].[All Store Types], ALL_MEMBER=[Store Type].[All Store Types], DESCRIPTION=Store Cube - Store Type Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=1, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Store, DIMENSION_UNIQUE_NAME=[Store], HIERARCHY_NAME=Store, HIERARCHY_UNIQUE_NAME=[Store], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=63, DEFAULT_MEMBER=[Store].[All Stores], ALL_MEMBER=[Store].[All Stores], DESCRIPTION=Store Cube - Store Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=2, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Store, DIMENSION_UNIQUE_NAME=[Has coffee bar], HIERARCHY_NAME=Has coffee bar, HIERARCHY_UNIQUE_NAME=[Has coffee bar], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Has coffee bar, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=3, DEFAULT_MEMBER=[Has coffee bar].[All Has coffee bars], ALL_MEMBER=[Has coffee bar].[All Has coffee bars], DESCRIPTION=Store Cube - Has coffee bar Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=3, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse, DIMENSION_UNIQUE_NAME=[Measures], HIERARCHY_NAME=Measures, HIERARCHY_UNIQUE_NAME=[Measures], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Measures, DIMENSION_TYPE=2, HIERARCHY_CARDINALITY=9, DEFAULT_MEMBER=[Measures].[Store Invoice], ALL_MEMBER=null, DESCRIPTION=Warehouse Cube - Measures Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=0, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse, DIMENSION_UNIQUE_NAME=[Store], HIERARCHY_NAME=Store, HIERARCHY_UNIQUE_NAME=[Store], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=63, DEFAULT_MEMBER=[Store].[All Stores], ALL_MEMBER=[Store].[All Stores], DESCRIPTION=Warehouse Cube - Store Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=1, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse, DIMENSION_UNIQUE_NAME=[Store Size in SQFT], HIERARCHY_NAME=Store Size in SQFT, HIERARCHY_UNIQUE_NAME=[Store Size in SQFT], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store Size in SQFT, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=22, DEFAULT_MEMBER=[Store Size in SQFT].[All Store Size in SQFTs], ALL_MEMBER=[Store Size in SQFT].[All Store Size in SQFTs], DESCRIPTION=Warehouse Cube - Store Size in SQFT Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=2, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse, DIMENSION_UNIQUE_NAME=[Store Type], HIERARCHY_NAME=Store Type, HIERARCHY_UNIQUE_NAME=[Store Type], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store Type, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=7, DEFAULT_MEMBER=[Store Type].[All Store Types], ALL_MEMBER=[Store Type].[All Store Types], DESCRIPTION=Warehouse Cube - Store Type Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=3, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse, DIMENSION_UNIQUE_NAME=[Time], HIERARCHY_NAME=Time, HIERARCHY_UNIQUE_NAME=[Time], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Time, DIMENSION_TYPE=1, HIERARCHY_CARDINALITY=34, DEFAULT_MEMBER=[Time].[1997], ALL_MEMBER=null, DESCRIPTION=Warehouse Cube - Time Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=4, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse, DIMENSION_UNIQUE_NAME=[Time], HIERARCHY_NAME=Time.Weekly, HIERARCHY_UNIQUE_NAME=[Time.Weekly], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Weekly, DIMENSION_TYPE=1, HIERARCHY_CARDINALITY=837, DEFAULT_MEMBER=[Time.Weekly].[All Time.Weeklys], ALL_MEMBER=[Time.Weekly].[All Time.Weeklys], DESCRIPTION=Warehouse Cube - Time.Weekly Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=5, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse, DIMENSION_UNIQUE_NAME=[Product], HIERARCHY_NAME=Product, HIERARCHY_UNIQUE_NAME=[Product], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Product, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=2256, DEFAULT_MEMBER=[Product].[All Products], ALL_MEMBER=[Product].[All Products], DESCRIPTION=Warehouse Cube - Product Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=6, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse, DIMENSION_UNIQUE_NAME=[Warehouse], HIERARCHY_NAME=Warehouse, HIERARCHY_UNIQUE_NAME=[Warehouse], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Warehouse, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=61, DEFAULT_MEMBER=[Warehouse].[All Warehouses], ALL_MEMBER=[Warehouse].[All Warehouses], DESCRIPTION=Warehouse Cube - Warehouse Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=7, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse and Sales, DIMENSION_UNIQUE_NAME=[Measures], HIERARCHY_NAME=Measures, HIERARCHY_UNIQUE_NAME=[Measures], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Measures, DIMENSION_TYPE=2, HIERARCHY_CARDINALITY=15, DEFAULT_MEMBER=[Measures].[Store Sales], ALL_MEMBER=null, DESCRIPTION=Warehouse and Sales Cube - Measures Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=0, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse and Sales, DIMENSION_UNIQUE_NAME=[Customers], HIERARCHY_NAME=Customers, HIERARCHY_UNIQUE_NAME=[Customers], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Customers, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=10407, DEFAULT_MEMBER=[Customers].[All Customers], ALL_MEMBER=[Customers].[All Customers], DESCRIPTION=Warehouse and Sales Cube - Customers Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=1, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse and Sales, DIMENSION_UNIQUE_NAME=[Education Level], HIERARCHY_NAME=Education Level, HIERARCHY_UNIQUE_NAME=[Education Level], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Education Level, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=6, DEFAULT_MEMBER=[Education Level].[All Education Levels], ALL_MEMBER=[Education Level].[All Education Levels], DESCRIPTION=Warehouse and Sales Cube - Education Level Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=2, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse and Sales, DIMENSION_UNIQUE_NAME=[Gender], HIERARCHY_NAME=Gender, HIERARCHY_UNIQUE_NAME=[Gender], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Gender, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=3, DEFAULT_MEMBER=[Gender].[All Gender], ALL_MEMBER=[Gender].[All Gender], DESCRIPTION=Warehouse and Sales Cube - Gender Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=3, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse and Sales, DIMENSION_UNIQUE_NAME=[Marital Status], HIERARCHY_NAME=Marital Status, HIERARCHY_UNIQUE_NAME=[Marital Status], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Marital Status, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=112, DEFAULT_MEMBER=[Marital Status].[All Marital Status], ALL_MEMBER=[Marital Status].[All Marital Status], DESCRIPTION=Warehouse and Sales Cube - Marital Status Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=4, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse and Sales, DIMENSION_UNIQUE_NAME=[Product], HIERARCHY_NAME=Product, HIERARCHY_UNIQUE_NAME=[Product], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Product, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=2256, DEFAULT_MEMBER=[Product].[All Products], ALL_MEMBER=[Product].[All Products], DESCRIPTION=Warehouse and Sales Cube - Product Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=5, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse and Sales, DIMENSION_UNIQUE_NAME=[Promotion Media], HIERARCHY_NAME=Promotion Media, HIERARCHY_UNIQUE_NAME=[Promotion Media], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Promotion Media, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=15, DEFAULT_MEMBER=[Promotion Media].[All Media], ALL_MEMBER=[Promotion Media].[All Media], DESCRIPTION=Warehouse and Sales Cube - Promotion Media Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=6, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse and Sales, DIMENSION_UNIQUE_NAME=[Promotions], HIERARCHY_NAME=Promotions, HIERARCHY_UNIQUE_NAME=[Promotions], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Promotions, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=52, DEFAULT_MEMBER=[Promotions].[All Promotions], ALL_MEMBER=[Promotions].[All Promotions], DESCRIPTION=Warehouse and Sales Cube - Promotions Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=7, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse and Sales, DIMENSION_UNIQUE_NAME=[Store], HIERARCHY_NAME=Store, HIERARCHY_UNIQUE_NAME=[Store], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Store, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=63, DEFAULT_MEMBER=[Store].[All Stores], ALL_MEMBER=[Store].[All Stores], DESCRIPTION=Warehouse and Sales Cube - Store Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=8, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse and Sales, DIMENSION_UNIQUE_NAME=[Time], HIERARCHY_NAME=Time, HIERARCHY_UNIQUE_NAME=[Time], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Time, DIMENSION_TYPE=1, HIERARCHY_CARDINALITY=34, DEFAULT_MEMBER=[Time].[1997], ALL_MEMBER=null, DESCRIPTION=Warehouse and Sales Cube - Time Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=9, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse and Sales, DIMENSION_UNIQUE_NAME=[Time], HIERARCHY_NAME=Time.Weekly, HIERARCHY_UNIQUE_NAME=[Time.Weekly], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Weekly, DIMENSION_TYPE=1, HIERARCHY_CARDINALITY=837, DEFAULT_MEMBER=[Time.Weekly].[All Time.Weeklys], ALL_MEMBER=[Time.Weekly].[All Time.Weeklys], DESCRIPTION=Warehouse and Sales Cube - Time.Weekly Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=10, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse and Sales, DIMENSION_UNIQUE_NAME=[Yearly Income], HIERARCHY_NAME=Yearly Income, HIERARCHY_UNIQUE_NAME=[Yearly Income], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Yearly Income, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=9, DEFAULT_MEMBER=[Yearly Income].[All Yearly Incomes], ALL_MEMBER=[Yearly Income].[All Yearly Incomes], DESCRIPTION=Warehouse and Sales Cube - Yearly Income Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=11, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] CATALOG_NAME=FoodMart, SCHEMA_NAME=FoodMart, CUBE_NAME=Warehouse and Sales, DIMENSION_UNIQUE_NAME=[Warehouse], HIERARCHY_NAME=Warehouse, HIERARCHY_UNIQUE_NAME=[Warehouse], HIERARCHY_GUID=null, HIERARCHY_CAPTION=Warehouse, DIMENSION_TYPE=3, HIERARCHY_CARDINALITY=61, DEFAULT_MEMBER=[Warehouse].[All Warehouses], ALL_MEMBER=[Warehouse].[All Warehouses], DESCRIPTION=Warehouse and Sales Cube - Warehouse Hierarchy, STRUCTURE=0, IS_VIRTUAL=false, IS_READWRITE=false, DIMENSION_UNIQUE_SETTINGS=0, DIMENSION_IS_VISIBLE=true, HIERARCHY_IS_VISIBLE=true, HIERARCHY_ORDINAL=12, DIMENSION_IS_SHARED=true, PARENT_CHILD=false
    [junit] ')
    [junit] Tests run: 3034, Failures: 10, Errors: 0, Time elapsed: 1,650.11 sec
    [junit] Test mondrian.test.Main FAILED
[junitreport] Processing <http://ci.pentaho.com/job/mondrian/ws/junit-results/TESTS-TestSuites.xml> to /tmp/null689161576
[junitreport] Loading stylesheet jar:file:/opt/ant1.7/lib/ant-junit.jar!/org/apache/tools/ant/taskdefs/optional/junit/xsl/junit-frames.xsl
[junitreport] Transform time: 2617ms
[junitreport] Deleting: /tmp/null689161576

BUILD FAILED
<http://ci.pentaho.com/job/mondrian/ws/build.xml>:778: condition satisfied

Total time: 28 minutes 11 seconds
Recording test results
Archiving artifacts
Recording fingerprints



More information about the Mondrian mailing list