Constant Field Values

Contents

mondrian.gui.*

  • mondrian.gui.JdbcMetaData 
    Modifier and Type Constant Field Value
    public static final String LEVEL_SEPARATOR "->"
  • mondrian.gui.mondrian.gui.JdbcTreeModel.Node 
    Modifier and Type Constant Field Value
    static final int CATALOG 0
    static final int COLUMN 2
    static final int TABLE 1

mondrian.olap.*

  • mondrian.olap.fun.CacheFunDef 
    Modifier and Type Constant Field Value
    static final String NAME "Cache"
  • mondrian.olap.fun.FunUtil 
    Modifier and Type Constant Field Value
    public static final boolean BooleanNull false
    public static final double DoubleEmpty -1.2345E-8
    public static final double DoubleNull 1.2345E-8
    public static final int IntegerNull -2147483647
  • mondrian.olap.fun.mondrian.olap.fun.FunUtil.Quicksorter 
    Modifier and Type Constant Field Value
    public final int TOO_SMALL 8
  • mondrian.olap.fun.LinReg 
    Modifier and Type Constant Field Value
    public static final int Intercept 2
    public static final int Point 0
    public static final int R2 1
    public static final int Slope 3
    public static final int Variance 4
  • mondrian.olap.fun.RankFunDef 
    Modifier and Type Constant Field Value
    static final boolean debug false

mondrian.olap4j.*

  • mondrian.olap4j.mondrian.olap4j.MondrianOlap4jDriverVersion 
    Modifier and Type Constant Field Value
    static final int MAJOR_VERSION 3
    static final int MINOR_VERSION 1101356
    static final String NAME "Mondrian olap4j driver"
    static final String VERSION "3.11.0.1-356"

mondrian.parser.*

mondrian.recorder.*

mondrian.rolap.*

  • mondrian.rolap.BatchTestCase 
    Modifier and Type Constant Field Value
    protected final String cubeNameSales "Sales"
    protected final String fieldProductDepartment "product_department"
    protected final String fieldProductFamily "product_family"
    protected final String fieldYear "the_year"
    protected final String measureUnitSales "[Measures].[Unit Sales]"
    protected final String tableCustomer "customer"
    protected final String tableProductClass "product_class"
    protected final String tableTime "time_by_day"
  • mondrian.rolap.BitKey.AbstractBitKey 
    Modifier and Type Constant Field Value
    protected static final int ChunkBitCount 6
    protected static final int Mask 63
    protected static final long WORD_MASK -1L
  • mondrian.rolap.RolapConnectionProperties 
    Modifier and Type Constant Field Value
    public static final String JdbcPropertyPrefix "jdbc."
  • mondrian.rolap.RolapLevel 
    Modifier and Type Constant Field Value
    static final int FLAG_ALL 2
    static final int FLAG_UNIQUE 4
  • mondrian.rolap.mondrian.rolap.RolapNativeTopCountTestCases 
    Modifier and Type Constant Field Value
    static final String CUSTOM_COUNT_MEASURE_CUBE " <Cube name=\"StoreWithCountM\" visible=\"true\" cache=\"true\" enabled=\"true\">\n <Table name=\"store\">\n </Table>\n <Dimension visible=\"true\" highCardinality=\"false\" name=\"Store Type\">\n <Hierarchy visible=\"true\" hasAll=\"true\">\n <Level name=\"Store Type\" visible=\"true\" column=\"store_type\" type=\"String\" uniqueMembers=\"true\" levelType=\"Regular\" hideMemberIf=\"Never\">\n </Level>\n </Hierarchy>\n </Dimension>\n <DimensionUsage source=\"Store\" name=\"Store\" visible=\"true\" highCardinality=\"false\">\n </DimensionUsage>\n <Dimension visible=\"true\" highCardinality=\"false\" name=\"Has coffee bar\">\n <Hierarchy visible=\"true\" hasAll=\"true\">\n <Level name=\"Has coffee bar\" visible=\"true\" column=\"coffee_bar\" type=\"Boolean\" uniqueMembers=\"true\" levelType=\"Regular\" hideMemberIf=\"Never\">\n </Level>\n </Hierarchy>\n </Dimension>\n <Measure name=\"Store Sqft\" column=\"store_sqft\" formatString=\"#,###\" aggregator=\"sum\">\n </Measure>\n <Measure name=\"Grocery Sqft\" column=\"grocery_sqft\" formatString=\"#,###\" aggregator=\"sum\">\n </Measure>\n <Measure name=\"CountM\" column=\"store_id\" formatString=\"Standard\" aggregator=\"count\" visible=\"true\">\n </Measure>\n </Cube>"
    static final String CUSTOM_COUNT_MEASURE_CUBE_NAME "StoreWithCountM"
    static final String CUSTOM_COUNT_MEASURE_QUERY "SELECT [Measures].[CountM] ON COLUMNS, TOPCOUNT([Store Type].[All Store Types].Children, 3, [Measures].[CountM]) ON ROWS FROM [StoreWithCountM]"
    static final String CUSTOM_COUNT_MEASURE_RESULT "Axis #0:\n{}\nAxis #1:\n{[Measures].[CountM]}\nAxis #2:\n{[Store Type].[Supermarket]}\n{[Store Type].[Deluxe Supermarket]}\n{[Store Type].[Mid-Size Grocery]}\nRow #0: 8\nRow #1: 6\nRow #2: 4\n"
    static final String EMPTY_CELLS_ARE_HIDDEN_WHEN_NON_EMPTY_QUERY "SELECT [Measures].[Unit Sales] ON COLUMNS, NON EMPTY TOPCOUNT([Customers].[Country].Members, 2, [Measures].[Unit Sales]) ON ROWS FROM [Sales] WHERE [Time].[1997].[Q3]"
    static final String EMPTY_CELLS_ARE_HIDDEN_WHEN_NON_EMPTY_RESULT "Axis #0:\n{[Time].[1997].[Q3]}\nAxis #1:\n{[Measures].[Unit Sales]}\nAxis #2:\n{[Customers].[USA]}\nRow #0: 65,848\n"
    static final String EMPTY_CELLS_ARE_SHOWN_COUNTRIES_QUERY "SELECT [Measures].[Unit Sales] ON COLUMNS, TOPCOUNT([Customers].[Country].Members, 2, [Measures].[Unit Sales]) ON ROWS FROM [Sales] WHERE [Time].[1997].[Q3]"
    static final String EMPTY_CELLS_ARE_SHOWN_COUNTRIES_RESULT "Axis #0:\n{[Time].[1997].[Q3]}\nAxis #1:\n{[Measures].[Unit Sales]}\nAxis #2:\n{[Customers].[USA]}\n{[Customers].[Canada]}\nRow #0: 65,848\nRow #1: \n"
    static final String EMPTY_CELLS_ARE_SHOWN_NOT_MORE_THAN_EXIST_QUERY "SELECT [Measures].[Unit Sales] ON COLUMNS, TOPCOUNT([Customers].[Country].Members, 10, [Measures].[Unit Sales]) ON ROWS FROM [Sales] WHERE [Time].[1997].[Q3]"
    static final String EMPTY_CELLS_ARE_SHOWN_NOT_MORE_THAN_EXIST_RESULT "Axis #0:\n{[Time].[1997].[Q3]}\nAxis #1:\n{[Measures].[Unit Sales]}\nAxis #2:\n{[Customers].[USA]}\n{[Customers].[Canada]}\n{[Customers].[Mexico]}\nRow #0: 65,848\nRow #1: \nRow #2: \n"
    static final String EMPTY_CELLS_ARE_SHOWN_STATES_QUERY "SELECT [Measures].[Unit Sales] ON COLUMNS, TOPCOUNT([Customers].[State Province].Members, 6, [Measures].[Unit Sales]) ON ROWS FROM [Sales] WHERE [Time].[1997].[Q3]"
    static final String EMPTY_CELLS_ARE_SHOWN_STATES_RESULT "Axis #0:\n{[Time].[1997].[Q3]}\nAxis #1:\n{[Measures].[Unit Sales]}\nAxis #2:\n{[Customers].[USA].[WA]}\n{[Customers].[USA].[CA]}\n{[Customers].[USA].[OR]}\n{[Customers].[Canada].[BC]}\n{[Customers].[Mexico].[DF]}\n{[Customers].[Mexico].[Guerrero]}\nRow #0: 30,538\nRow #1: 18,370\nRow #2: 16,940\nRow #3: \nRow #4: \nRow #5: \n"
    static final String IMPLICIT_COUNT_MEASURE_QUERY "SELECT [Measures].[Fact Count] ON COLUMNS, TOPCOUNT([Store Type].[All Store Types].Children, 3, [Measures].[Fact Count]) ON ROWS FROM [Store]"
    static final String IMPLICIT_COUNT_MEASURE_RESULT "Axis #0:\n{}\nAxis #1:\n{[Measures].[Fact Count]}\nAxis #2:\n{[Store Type].[Supermarket]}\n{[Store Type].[Deluxe Supermarket]}\n{[Store Type].[Mid-Size Grocery]}\nRow #0: 8\nRow #1: 6\nRow #2: 4\n"
    static final String NON_EMPTY_IS_NOT_IGNORED_WHEN_TWO_PARAMS_QUERY "SELECT NON EMPTY TOPCOUNT([Customers].[State Province].members, 3) ON COLUMNS FROM [Sales] "
    static final String NON_EMPTY_IS_NOT_IGNORED_WHEN_TWO_PARAMS_RESULT "Axis #0:\n{}\nAxis #1:\n"
    static final String RESULTS_ARE_SHOWN_NOT_MORE_THAN_EXIST_2_PARAMS_QUERY "SELECT TOPCOUNT([Customers].[Country].members, 5) ON COLUMNS FROM [Sales] "
    static final String RESULTS_ARE_SHOWN_NOT_MORE_THAN_EXIST_2_PARAMS_RESULT "Axis #0:\n{}\nAxis #1:\n{[Customers].[Canada]}\n{[Customers].[Mexico]}\n{[Customers].[USA]}\nRow #0: \nRow #0: \nRow #0: 266,773\n"
    static final String ROLE_RESTRICTION_WORKS_DF_QUERY "SELECT [Measures].[Unit Sales] ON COLUMNS, TOPCOUNT([Customers].[State Province].Members, 6, [Measures].[Unit Sales]) ON ROWS FROM [Sales] WHERE [Time].[1997].[Q3]"
    static final String ROLE_RESTRICTION_WORKS_DF_RESULT "Axis #0:\n{[Time].[1997].[Q3]}\nAxis #1:\n{[Measures].[Unit Sales]}\nAxis #2:\n{[Customers].[USA].[WA]}\n{[Customers].[USA].[CA]}\n{[Customers].[USA].[OR]}\n{[Customers].[Canada].[BC]}\n{[Customers].[Mexico].[DF]}\nRow #0: 30,538\nRow #1: 18,370\nRow #2: 16,940\nRow #3: \nRow #4: \n"
    static final String ROLE_RESTRICTION_WORKS_DF_ROLE_DEF "<Role name=\"Only_DF_State\">\n <SchemaGrant access=\"none\">\n <CubeGrant cube=\"Sales\" access=\"all\">\n <HierarchyGrant hierarchy=\"[Customers]\" access=\"custom\" rollupPolicy=\"partial\">\n <MemberGrant member=\"[Customers].[USA].[WA]\" access=\"all\"/>\n <MemberGrant member=\"[Customers].[USA].[OR]\" access=\"all\"/>\n <MemberGrant member=\"[Customers].[USA].[CA]\" access=\"all\"/>\n <MemberGrant member=\"[Customers].[Canada]\" access=\"all\"/>\n <MemberGrant member=\"[Customers].[Mexico].[DF]\" access=\"all\"/>\n </HierarchyGrant>\n </CubeGrant>\n </SchemaGrant>\n</Role>\n"
    static final String ROLE_RESTRICTION_WORKS_DF_ROLE_NAME "Only_DF_State"
    static final String ROLE_RESTRICTION_WORKS_WA_QUERY "SELECT [Measures].[Unit Sales] ON COLUMNS, TOPCOUNT([Customers].[State Province].Members, 6, [Measures].[Unit Sales]) ON ROWS FROM [Sales] WHERE [Time].[1997].[Q3]"
    static final String ROLE_RESTRICTION_WORKS_WA_RESULT "Axis #0:\n{[Time].[1997].[Q3]}\nAxis #1:\n{[Measures].[Unit Sales]}\nAxis #2:\n{[Customers].[USA].[CA]}\n{[Customers].[USA].[OR]}\n{[Customers].[Canada].[BC]}\n{[Customers].[Mexico].[DF]}\n{[Customers].[Mexico].[Guerrero]}\n{[Customers].[Mexico].[Jalisco]}\nRow #0: 18,370\nRow #1: 16,940\nRow #2: \nRow #3: \nRow #4: \nRow #5: \n"
    static final String ROLE_RESTRICTION_WORKS_WA_ROLE_DEF "<Role name=\"No_WA_State\">\n <SchemaGrant access=\"none\">\n <CubeGrant cube=\"Sales\" access=\"all\">\n <HierarchyGrant hierarchy=\"[Customers]\" access=\"custom\" rollupPolicy=\"partial\">\n <MemberGrant member=\"[Customers].[USA].[WA]\" access=\"none\"/>\n <MemberGrant member=\"[Customers].[USA].[OR]\" access=\"all\"/>\n <MemberGrant member=\"[Customers].[USA].[CA]\" access=\"all\"/>\n <MemberGrant member=\"[Customers].[Canada]\" access=\"all\"/>\n <MemberGrant member=\"[Customers].[Mexico]\" access=\"all\"/>\n </HierarchyGrant>\n </CubeGrant>\n </SchemaGrant>\n</Role>\n"
    static final String ROLE_RESTRICTION_WORKS_WA_ROLE_NAME "No_WA_State"
    static final String SUM_MEASURE_QUERY "SELECT [Measures].[Store Sqft] ON COLUMNS, TOPCOUNT([Store Type].[All Store Types].Children, 3, [Measures].[Store Sqft]) ON ROWS FROM [Store]"
    static final String SUM_MEASURE_RESULT "Axis #0:\n{}\nAxis #1:\n{[Measures].[Store Sqft]}\nAxis #2:\n{[Store Type].[Supermarket]}\n{[Store Type].[Deluxe Supermarket]}\n{[Store Type].[Mid-Size Grocery]}\nRow #0: 193,480\nRow #1: 146,045\nRow #2: 109,343\n"
    static final String TOPCOUNT_MIMICS_HEAD_WHEN_TWO_PARAMS_CITIES_QUERY "SELECT TOPCOUNT([Customers].[City].members, 30) ON COLUMNS FROM [Sales] "
    static final String TOPCOUNT_MIMICS_HEAD_WHEN_TWO_PARAMS_CITIES_RESULT "Axis #0:\n{}\nAxis #1:\n{[Customers].[Canada].[BC].[Burnaby]}\n{[Customers].[Canada].[BC].[Cliffside]}\n{[Customers].[Canada].[BC].[Haney]}\n{[Customers].[Canada].[BC].[Ladner]}\n{[Customers].[Canada].[BC].[Langford]}\n{[Customers].[Canada].[BC].[Langley]}\n{[Customers].[Canada].[BC].[Metchosin]}\n{[Customers].[Canada].[BC].[N. Vancouver]}\n{[Customers].[Canada].[BC].[Newton]}\n{[Customers].[Canada].[BC].[Oak Bay]}\n{[Customers].[Canada].[BC].[Port Hammond]}\n{[Customers].[Canada].[BC].[Richmond]}\n{[Customers].[Canada].[BC].[Royal Oak]}\n{[Customers].[Canada].[BC].[Shawnee]}\n{[Customers].[Canada].[BC].[Sooke]}\n{[Customers].[Canada].[BC].[Vancouver]}\n{[Customers].[Canada].[BC].[Victoria]}\n{[Customers].[Canada].[BC].[Westminster]}\n{[Customers].[Mexico].[DF].[San Andres]}\n{[Customers].[Mexico].[DF].[Santa Anita]}\n{[Customers].[Mexico].[DF].[Santa Fe]}\n{[Customers].[Mexico].[DF].[Tixapan]}\n{[Customers].[Mexico].[Guerrero].[Acapulco]}\n{[Customers].[Mexico].[Jalisco].[Guadalajara]}\n{[Customers].[Mexico].[Mexico].[Mexico City]}\n{[Customers].[Mexico].[Oaxaca].[Tlaxiaco]}\n{[Customers].[Mexico].[Sinaloa].[La Cruz]}\n{[Customers].[Mexico].[Veracruz].[Orizaba]}\n{[Customers].[Mexico].[Yucatan].[Merida]}\n{[Customers].[Mexico].[Zacatecas].[Camacho]}\nRow #0: \nRow #0: \nRow #0: \nRow #0: \nRow #0: \nRow #0: \nRow #0: \nRow #0: \nRow #0: \nRow #0: \nRow #0: \nRow #0: \nRow #0: \nRow #0: \nRow #0: \nRow #0: \nRow #0: \nRow #0: \nRow #0: \nRow #0: \nRow #0: \nRow #0: \nRow #0: \nRow #0: \nRow #0: \nRow #0: \nRow #0: \nRow #0: \nRow #0: \nRow #0: \n"
    static final String TOPCOUNT_MIMICS_HEAD_WHEN_TWO_PARAMS_STATES_QUERY "SELECT TOPCOUNT([Customers].[State Province].members, 3) ON COLUMNS FROM [Sales] "
    static final String TOPCOUNT_MIMICS_HEAD_WHEN_TWO_PARAMS_STATES_RESULT "Axis #0:\n{}\nAxis #1:\n{[Customers].[Canada].[BC]}\n{[Customers].[Mexico].[DF]}\n{[Customers].[Mexico].[Guerrero]}\nRow #0: \nRow #0: \nRow #0: \n"
  • mondrian.rolap.mondrian.rolap.RolapResult.CellInfoPool 
    Modifier and Type Constant Field Value
    protected static final long MAX_AXIS_SIZE_2 2147483647L
    protected static final long MAX_AXIS_SIZE_3 2000000L
    protected static final long MAX_AXIS_SIZE_4 50000L
  • mondrian.rolap.RolapUtil 
    Modifier and Type Constant Field Value
    public static final String sqlNullLiteral "null"
  • mondrian.rolap.aggmatcher.DefaultDef.Mapper 
    Modifier and Type Constant Field Value
    protected static final int BAD_ID -1
  • mondrian.rolap.aggmatcher.DefaultDef.Regex 
    Modifier and Type Constant Field Value
    protected static final int BAD_ID -1
  • mondrian.rolap.aggmatcher.JdbcSchema 
    Modifier and Type Constant Field Value
    public static final String FACT_COUNT_COLUMN_NAME "FACT_COUNT"
    public static final int FACT_COUNT_COLUMN_USAGE 16
    public static final String FOREIGN_KEY_COLUMN_NAME "FOREIGN_KEY"
    public static final int FOREIGN_KEY_COLUMN_USAGE 2
    public static final String IGNORE_COLUMN_NAME "IGNORE"
    public static final int IGNORE_COLUMN_USAGE 32
    public static final String LEVEL_COLUMN_NAME "LEVEL"
    public static final int LEVEL_COLUMN_USAGE 8
    public static final String MEASURE_COLUMN_NAME "MEASURE"
    public static final int MEASURE_COLUMN_USAGE 4
    public static final String UNKNOWN_COLUMN_NAME "UNKNOWN"
    public static final int UNKNOWN_COLUMN_USAGE 1
  • mondrian.rolap.aggmatcher.SpeciesNonCollapsedAggTest 
    Modifier and Type Constant Field Value
    public static final String ANIMAL_SCHEMA "<?xml version=\'1.0\'?>\n<Schema name=\'Testmart\'>\n <Dimension name=\'Animal\'>\n <Hierarchy name=\'Animals\' hasAll=\'true\' allMemberName=\'All Animals\' primaryKey=\'SPECIES_ID\' primaryKeyTable=\'DIM_SPECIES\'>\n <Join leftKey=\'GENUS_ID\' rightAlias=\'DIM_GENUS\' rightKey=\'GENUS_ID\'>\n <Table name=\'DIM_SPECIES\' />\n <Join leftKey=\'FAMILY_ID\' rightKey=\'FAMILY_ID\'>\n <Table name=\'DIM_GENUS\' />\n <Table name=\'DIM_FAMILY\' />\n </Join>\n </Join>\n <Level name=\'Family\' table=\'DIM_FAMILY\' column=\'FAMILY_ID\' nameColumn=\'FAMILY_NAME\' uniqueMembers=\'true\' type=\'Numeric\' approxRowCount=\'2\' />\n <Level name=\'Genus\' table=\'DIM_GENUS\' column=\'GENUS_ID\' nameColumn=\'GENUS_NAME\' uniqueMembers=\'true\' type=\'Numeric\' approxRowCount=\'4\' />\n <Level name=\'Species\' table=\'DIM_SPECIES\' column=\'SPECIES_ID\' nameColumn=\'SPECIES_NAME\' uniqueMembers=\'true\' type=\'Numeric\' approxRowCount=\'8\' />\n </Hierarchy>\n </Dimension>\n <Cube name=\'Test\' defaultMeasure=\'Population\'>\n <Table name=\'SPECIES_MART\'>\n <AggName name=\'AGG_SPECIES_MART\'>\n <AggFactCount column=\'FACT_COUNT\' />\n <AggMeasure name=\'Measures.[Population]\' column=\'POPULATION\' />\n <AggLevel name=\'[Animal.Animals].[Genus]\' column=\'GEN_ID\' collapsed=\'false\' />\n </AggName>\n </Table>\n <DimensionUsage name=\'Animal\' source=\'Animal\' foreignKey=\'SPECIES_ID\'/>\n <Measure name=\'Population\' column=\'POPULATION\' aggregator=\'sum\'/>\n </Cube>\n <Role name=\'Test role\'>\n <SchemaGrant access=\'none\'>\n <CubeGrant cube=\'Test\' access=\'all\'>\n <HierarchyGrant hierarchy=\'[Animal.Animals]\' access=\'custom\' rollupPolicy=\'partial\'>\n <MemberGrant member=\'[Animal.Animals].[Family].[Loricariidae]\' access=\'all\'/>\n <MemberGrant member=\'[Animal.Animals].[Family].[Cichlidae]\' access=\'all\'/>\n <MemberGrant member=\'[Animal.Animals].[Family].[Cyprinidae]\' access=\'none\'/>\n </HierarchyGrant>\n </CubeGrant>\n </SchemaGrant>\n </Role>\n</Schema>"
  • mondrian.rolap.sql.SelectNotInGroupByTest 
    Modifier and Type Constant Field Value
    public static final String cubeA "<Cube name=\"CustomSales\">\n <Table name=\"sales_fact_1997\"/>\n <DimensionUsage name=\"CustomStore\" source=\"CustomStore\" foreignKey=\"store_id\"/>\n <Measure name=\"Custom Store Sales\" column=\"store_sales\" aggregator=\"sum\" formatString=\"#,###.00\"/>\n <Measure name=\"Custom Store Cost\" column=\"store_cost\" aggregator=\"sum\"/>\n <Measure name=\"Sales Count\" column=\"product_id\" aggregator=\"count\"/>\n</Cube>"
    public static final String queryCubeA "select {[Measures].[Custom Store Sales],[Measures].[Custom Store Cost]} on columns, {[CustomStore].[Store Name].Members} on rows from CustomSales"
    public static final String sqlWithAllGroupBy "select \n `store`.`store_country` as `c0`, \n `store`.`store_city` as `c1`, \n `store`.`store_state` as `c2`, \n `store`.`store_name` as `c3`\nfrom \n `store` as `store`\ngroup by \n `store`.`store_country`, \n `store`.`store_city`, \n `store`.`store_state`, \n `store`.`store_name`\norder by \n ISNULL(`store`.`store_country`), `store`.`store_country` ASC, \n ISNULL(`store`.`store_city`), `store`.`store_city` ASC, \n ISNULL(`store`.`store_name`), `store`.`store_name` ASC\n"
    public static final String sqlWithLevelGroupBy "select \n `store`.`store_country` as `c0`, \n `store`.`store_city` as `c1`, \n `store`.`store_state` as `c2`, \n `store`.`store_name` as `c3`\nfrom \n `store` as `store`\ngroup by \n `store`.`store_country`, \n `store`.`store_city`, \n `store`.`store_name`\norder by \n ISNULL(`store`.`store_country`), `store`.`store_country` ASC, \n ISNULL(`store`.`store_city`), `store`.`store_city` ASC, \n ISNULL(`store`.`store_name`), `store`.`store_name` ASC\n"
    public static final String sqlWithNoGroupBy "select \n `store`.`store_country` as `c0`, \n `store`.`store_city` as `c1`, \n `store`.`store_state` as `c2`, \n `store`.`store_name` as `c3`\nfrom \n `store` as `store`\norder by \n ISNULL(`store`.`store_country`), `store`.`store_country` ASC, \n ISNULL(`store`.`store_city`), `store`.`store_city` ASC, \n ISNULL(`store`.`store_name`), `store`.`store_name` ASC\n"
    public static final String storeDimensionLevelDependent "<Dimension name=\"CustomStore\">\n <Hierarchy hasAll=\"true\" primaryKey=\"store_id\">\n <Table name=\"store\"/>\n <Level name=\"Store Country\" column=\"store_country\" uniqueMembers=\"true\"/>\n <Level name=\"Store City\" column=\"store_city\" uniqueMembers=\"false\">\n <Property name=\"Store State\" column=\"store_state\" dependsOnLevelValue=\"true\"/>\n </Level>\n <Level name=\"Store Name\" column=\"store_name\" uniqueMembers=\"true\"/>\n </Hierarchy>\n</Dimension>"
    public static final String storeDimensionLevelIndependent "<Dimension name=\"CustomStore\">\n <Hierarchy hasAll=\"true\" primaryKey=\"store_id\">\n <Table name=\"store\"/>\n <Level name=\"Store Country\" column=\"store_country\" uniqueMembers=\"true\"/>\n <Level name=\"Store City\" column=\"store_city\" uniqueMembers=\"false\">\n <Property name=\"Store State\" column=\"store_state\"/>\n </Level>\n <Level name=\"Store Name\" column=\"store_name\" uniqueMembers=\"true\"/>\n </Hierarchy>\n</Dimension>"
    public static final String storeDimensionUniqueLevelDependentProp "<Dimension name=\"CustomStore\">\n <Hierarchy hasAll=\"true\" primaryKey=\"store_id\" uniqueKeyLevelName=\"Store Name\">\n <Table name=\"store\"/>\n <Level name=\"Store Country\" column=\"store_country\" uniqueMembers=\"true\"/>\n <Level name=\"Store City\" column=\"store_city\" uniqueMembers=\"false\">\n <Property name=\"Store State\" column=\"store_state\" dependsOnLevelValue=\"true\"/>\n </Level>\n <Level name=\"Store Name\" column=\"store_name\" uniqueMembers=\"true\"/>\n </Hierarchy>\n</Dimension>"
    public static final String storeDimensionUniqueLevelIndependentProp "<Dimension name=\"CustomStore\">\n <Hierarchy hasAll=\"true\" primaryKey=\"store_id\" uniqueKeyLevelName=\"Store Name\">\n <Table name=\"store\"/>\n <Level name=\"Store Country\" column=\"store_country\" uniqueMembers=\"true\"/>\n <Level name=\"Store City\" column=\"store_city\" uniqueMembers=\"false\">\n <Property name=\"Store State\" column=\"store_state\" dependsOnLevelValue=\"false\"/>\n </Level>\n <Level name=\"Store Name\" column=\"store_name\" uniqueMembers=\"true\"/>\n </Hierarchy>\n</Dimension>"

mondrian.server.*

mondrian.test.*

  • mondrian.test.BasicQueryTest 
    Modifier and Type Constant Field Value
    static final String EmptyResult "Axis #0:\n{}\nAxis #1:\nAxis #2:\n"
  • mondrian.test.CaptionTest.MyFoodmart 
    Modifier and Type Constant Field Value
    static final String foodmart "<?xml version=\"1.0\"?>\n<Schema name=\"FoodMart\">\n<!-- Shared dimensions -->\n <Dimension name=\"Store\">\n <Hierarchy hasAll=\"true\" primaryKey=\"store_id\">\n <Table name=\"store\"/>\n <Level name=\"Store Country\" column=\"store_country\" uniqueMembers=\"true\"/>\n <Level name=\"Store State\" column=\"store_state\" uniqueMembers=\"true\"/>\n <Level name=\"Store City\" column=\"store_city\" uniqueMembers=\"false\"/>\n <Level name=\"Store Name\" column=\"store_name\" uniqueMembers=\"true\">\n <Property name=\"Store Type\" column=\"store_type\"/>\n <Property name=\"Store Manager\" column=\"store_manager\"/>\n <Property name=\"Store Sqft\" column=\"store_sqft\" type=\"Numeric\"/>\n <Property name=\"Grocery Sqft\" column=\"grocery_sqft\" type=\"Numeric\"/>\n <Property name=\"Frozen Sqft\" column=\"frozen_sqft\" type=\"Numeric\"/>\n <Property name=\"Meat Sqft\" column=\"meat_sqft\" type=\"Numeric\"/>\n <Property name=\"Has coffee bar\" column=\"coffee_bar\" type=\"Boolean\"/>\n <Property name=\"Street address\" column=\"store_street_address\" type=\"String\"/>\n </Level>\n </Hierarchy>\n </Dimension>\n <Dimension name=\"Store Size in SQFT\" caption=\"Quadrat-Fuesse:-)\">\n <Hierarchy hasAll=\"true\" primaryKey=\"store_id\">\n <Table name=\"store\"/>\n <Level name=\"Store Sqft\" column=\"store_sqft\" type=\"Numeric\" uniqueMembers=\"true\"/>\n </Hierarchy>\n </Dimension>\n <Dimension name=\"Store Type\">\n <Hierarchy hasAll=\"true\" primaryKey=\"store_id\">\n <Table name=\"store\"/>\n <Level name=\"Store Type\" column=\"store_type\" uniqueMembers=\"true\"/>\n </Hierarchy>\n </Dimension>\n <Dimension name=\"Time\" type=\"TimeDimension\">\n <Hierarchy hasAll=\"false\" primaryKey=\"time_id\">\n <Table name=\"time_by_day\"/>\n <Level name=\"Year\" column=\"the_year\" type=\"Numeric\" uniqueMembers=\"true\"\n levelType=\"TimeYears\">\n <CaptionExpression>\n <SQL dialect=\"access\">\ncstr(the_year) + \'-12-31\'\n </SQL>\n <SQL dialect=\"mysql\">\nconcat(cast(`the_year` as char(4)), \'-12-31\')\n </SQL>\n <SQL dialect=\"derby\">\n\'foobar\'\n </SQL>\n <SQL dialect=\"generic\">\n\"the_year\" || \'-12-31\'\n </SQL>\n </CaptionExpression>\n </Level>\n <Level name=\"Quarter\" column=\"quarter\" uniqueMembers=\"false\"\n levelType=\"TimeQuarters\"/>\n <Level name=\"Month\" column=\"month_of_year\" uniqueMembers=\"false\" type=\"Numeric\"\n levelType=\"TimeMonths\"/>\n </Hierarchy>\n </Dimension>\n <Dimension name=\"Product\">\n <Hierarchy hasAll=\"true\" primaryKey=\"product_id\" primaryKeyTable=\"product\">\n <Join leftKey=\"product_class_id\" rightKey=\"product_class_id\">\n <Table name=\"product\"/>\n <Table name=\"product_class\"/>\n </Join>\n<!--\n <Query>\n <SQL dialect=\"generic\">\nSELECT *\nFROM \"product\", \"product_class\"\nWHERE \"product\".\"product_class_id\" = \"product_class\".\"product_class_id\"\n </SQL>\n </Query>\n <Level name=\"Product Family\" column=\"product_family\" uniqueMembers=\"true\"/>\n <Level name=\"Product Department\" column=\"product_department\" uniqueMembers=\"false\"/>\n <Level name=\"Product Category\" column=\"product_category\" uniqueMembers=\"false\"/>\n <Level name=\"Product Subcategory\" column=\"product_subcategory\" uniqueMembers=\"false\"/>\n <Level name=\"Brand Name\" column=\"brand_name\" uniqueMembers=\"false\"/>\n <Level name=\"Product Name\" column=\"product_name\" uniqueMembers=\"true\"/>\n-->\n <Level name=\"Product Family\" table=\"product_class\" column=\"product_family\"\n uniqueMembers=\"true\"/>\n <Level name=\"Product Department\" table=\"product_class\" column=\"product_department\"\n uniqueMembers=\"false\"/>\n <Level name=\"Product Category\" table=\"product_class\" column=\"product_category\"\n uniqueMembers=\"false\"/>\n <Level name=\"Product Subcategory\" table=\"product_class\" column=\"product_subcategory\"\n uniqueMembers=\"false\"/>\n <Level name=\"Brand Name\" table=\"product\" column=\"brand_name\" uniqueMembers=\"false\"/>\n <Level name=\"Product Name\" table=\"product\" column=\"product_name\"\n uniqueMembers=\"true\"/>\n </Hierarchy>\n </Dimension>\n <Dimension name=\"Warehouse\">\n <Hierarchy hasAll=\"true\" primaryKey=\"warehouse_id\">\n <Table name=\"warehouse\"/>\n <Level name=\"Country\" column=\"warehouse_country\" uniqueMembers=\"true\"/>\n <Level name=\"State Province\" column=\"warehouse_state_province\"\n uniqueMembers=\"true\"/>\n <Level name=\"City\" column=\"warehouse_city\" uniqueMembers=\"false\"/>\n <Level name=\"Warehouse Name\" column=\"warehouse_name\" uniqueMembers=\"true\"/>\n </Hierarchy>\n </Dimension>\n<!-- Sales -->\n<Cube name=\"Sales\">\n <Table name=\"sales_fact_1997\">\n <AggExclude pattern=\".*\" /> \n </Table>\n <DimensionUsage name=\"Store\" source=\"Store\" foreignKey=\"store_id\"/>\n <DimensionUsage name=\"Store Size in SQFT\" source=\"Store Size in SQFT\"\n foreignKey=\"store_id\"/>\n <DimensionUsage name=\"Store Type\" source=\"Store Type\" foreignKey=\"store_id\"/>\n <DimensionUsage name=\"Time\" source=\"Time\" foreignKey=\"time_id\"/>\n <DimensionUsage name=\"Product\" source=\"Product\" foreignKey=\"product_id\"/>\n <Dimension name=\"Promotion Media\" caption=\"Werbemedium\" foreignKey=\"promotion_id\">\n <Hierarchy hasAll=\"true\" allMemberName=\"All Media\" primaryKey=\"promotion_id\">\n <Table name=\"promotion\"/>\n <Level name=\"Media Type\" column=\"media_type\" uniqueMembers=\"true\"/>\n </Hierarchy>\n </Dimension>\n <Dimension name=\"Promotions\" foreignKey=\"promotion_id\">\n <Hierarchy hasAll=\"true\" allMemberName=\"All Promotions\" primaryKey=\"promotion_id\">\n <Table name=\"promotion\"/>\n <Level name=\"Promotion Name\" column=\"promotion_name\" uniqueMembers=\"true\"/>\n </Hierarchy>\n </Dimension>\n <Dimension name=\"Customers\" foreignKey=\"customer_id\">\n <Hierarchy hasAll=\"true\" allMemberName=\"All Customers\" primaryKey=\"customer_id\">\n <Table name=\"customer\"/>\n <Level name=\"Country\" column=\"country\" uniqueMembers=\"true\"/>\n <Level name=\"State Province\" column=\"state_province\" uniqueMembers=\"true\"/>\n <Level name=\"City\" column=\"city\" uniqueMembers=\"false\"/>\n <Level name=\"Name\" uniqueMembers=\"true\">\n <KeyExpression>\n <SQL dialect=\"oracle\">\n\"fname\" || \' \' || \"lname\"\n </SQL>\n <SQL dialect=\"access\">\nfname, \' \', lname\n </SQL>\n <SQL dialect=\"postgres\">\n\"fname\" || \' \' || \"lname\"\n </SQL>\n <SQL dialect=\"mysql\">\nCONCAT(`customer`.`fname`, \' \', `customer`.`lname`)\n </SQL>\n <SQL dialect=\"mssql\">\nfname, \' \', lname\n </SQL>\n <SQL dialect=\"generic\">\nlname\n </SQL>\n </KeyExpression>\n <Property name=\"Gender\" column=\"gender\"/>\n <Property name=\"Marital Status\" column=\"marital_status\"/>\n <Property name=\"Education\" column=\"education\"/>\n <Property name=\"Yearly Income\" column=\"yearly_income\"/>\n </Level>\n </Hierarchy>\n </Dimension>\n <Dimension name=\"Education Level\" foreignKey=\"customer_id\">\n <Hierarchy hasAll=\"true\" primaryKey=\"customer_id\">\n <Table name=\"customer\"/>\n <Level name=\"Education Level\" column=\"education\" uniqueMembers=\"true\"/>\n </Hierarchy>\n </Dimension>\n <Dimension name=\"Gender\" foreignKey=\"customer_id\">\n <Hierarchy hasAll=\"true\" allMemberName=\"All Gender\" primaryKey=\"customer_id\">\n <Table name=\"customer\"/>\n <Level name=\"Gender\" column=\"gender\" uniqueMembers=\"true\"/>\n </Hierarchy>\n </Dimension>\n <Dimension name=\"Marital Status\" foreignKey=\"customer_id\">\n <Hierarchy hasAll=\"true\" allMemberName=\"All Marital Status\" primaryKey=\"customer_id\">\n <Table name=\"customer\"/>\n <Level name=\"Marital Status\" column=\"marital_status\" uniqueMembers=\"true\"/>\n </Hierarchy>\n </Dimension>\n <Dimension name=\"Yearly Income\" foreignKey=\"customer_id\">\n <Hierarchy hasAll=\"true\" primaryKey=\"customer_id\">\n <Table name=\"customer\"/>\n <Level name=\"Yearly Income\" column=\"yearly_income\" uniqueMembers=\"true\"/>\n </Hierarchy>\n </Dimension>\n <Measure name=\"Unit Sales\" caption=\"Anzahl Verkauf\" column=\"unit_sales\" aggregator=\"sum\"\n formatString=\"Standard\"/>\n <Measure name=\"Store Cost\" column=\"store_cost\" aggregator=\"sum\"\n formatString=\"#,###.00\"/>\n <Measure name=\"Store Sales\" column=\"store_sales\" aggregator=\"sum\"\n formatString=\"#,###.00\"/>\n <Measure name=\"Sales Count\" column=\"product_id\" aggregator=\"count\"\n formatString=\"#,###\"/>\n <Measure name=\"Customer Count\" column=\"customer_id\"\n aggregator=\"distinct-count\" formatString=\"#,###\"/>\n <CalculatedMember\n name=\"Profit\"\n dimension=\"Measures\"\n formula=\"[Measures].[Store Sales] - [Measures].[Store Cost]\">\n <CalculatedMemberProperty name=\"FORMAT_STRING\" value=\"$#,##0.00\"/>\n </CalculatedMember>\n <CalculatedMember\n name=\"Profit last Period\"\n dimension=\"Measures\"\n formula=\"COALESCEEMPTY((Measures.[Profit], [Time].PREVMEMBER), Measures.[Profit])\"\n visible=\"false\"/>\n <CalculatedMember\n name=\"Profit Growth\"\n dimension=\"Measures\"\n formula=\"([Measures].[Profit] - [Measures].[Profit last Period]) / [Measures].[Profit last Period]\"\n visible=\"true\"\n caption=\"Gewinn-Wachstum\">\n <CalculatedMemberProperty name=\"FORMAT_STRING\" value=\"0.0%\"/>\n </CalculatedMember>\n</Cube>\n<Cube name=\"Warehouse\">\n <Table name=\"inventory_fact_1997\"/>\n <DimensionUsage name=\"Store\" source=\"Store\" foreignKey=\"store_id\"/>\n <DimensionUsage name=\"Store Size in SQFT\" source=\"Store Size in SQFT\"\n foreignKey=\"store_id\"/>\n <DimensionUsage name=\"Store Type\" source=\"Store Type\" foreignKey=\"store_id\"/>\n <DimensionUsage name=\"Time\" source=\"Time\" foreignKey=\"time_id\"/>\n <DimensionUsage name=\"Product\" source=\"Product\" foreignKey=\"product_id\"/>\n <DimensionUsage name=\"Warehouse\" source=\"Warehouse\" foreignKey=\"warehouse_id\"/>\n <Measure name=\"Store Invoice\" column=\"store_invoice\" aggregator=\"sum\"/>\n <Measure name=\"Supply Time\" column=\"supply_time\" aggregator=\"sum\"/>\n <Measure name=\"Warehouse Cost\" column=\"warehouse_cost\" aggregator=\"sum\"/>\n <Measure name=\"Warehouse Sales\" column=\"warehouse_sales\" aggregator=\"sum\"/>\n <Measure name=\"Units Shipped\" column=\"units_shipped\" aggregator=\"sum\" formatString=\"#.0\"/>\n <Measure name=\"Units Ordered\" column=\"units_ordered\" aggregator=\"sum\" formatString=\"#.0\"/>\n <Measure name=\"Warehouse Profit\" column=\"&quot;warehouse_sales&quot;-&quot;inventory_fact_1997&quot;.&quot;warehouse_cost&quot;\" aggregator=\"sum\"/>\n</Cube>\n<!-- Test a cube based upon a single table. -->\n<Cube name=\"Store\">\n <Table name=\"store\"/>\n <!-- We could have used the shared dimension \"Store Type\", but we\n want to test private dimensions without primary key. -->\n <Dimension name=\"Store Type\">\n <Hierarchy hasAll=\"true\">\n <Level name=\"Store Type\" column=\"store_type\" uniqueMembers=\"true\"/>\n </Hierarchy>\n </Dimension>\n <!-- We don\'t have to specify primary key or foreign key since the shared\n dimension \"Store\" has the same underlying table as the cube. -->\n <DimensionUsage name=\"Store\" source=\"Store\"/>\n <Dimension name=\"Has coffee bar\">\n <Hierarchy hasAll=\"true\">\n <Level name=\"Has coffee bar\" column=\"coffee_bar\" uniqueMembers=\"true\"/>\n </Hierarchy>\n </Dimension>\n <Measure name=\"Store Sqft\" column=\"store_sqft\" aggregator=\"sum\"\n formatString=\"#,###\"/>\n <Measure name=\"Grocery Sqft\" column=\"grocery_sqft\" aggregator=\"sum\"\n formatString=\"#,###\"/>\n</Cube>\n<Cube name=\"HR\">\n <Table name=\"salary\"/>\n <!-- Use private \"Time\" dimension because key is different than public\n \"Time\" dimension. -->\n <Dimension name=\"Time\" type=\"TimeDimension\" foreignKey=\"pay_date\">\n <Hierarchy hasAll=\"false\" primaryKey=\"the_date\">\n <Table name=\"time_by_day\"/>\n <Level name=\"Year\" column=\"the_year\" type=\"Numeric\" uniqueMembers=\"true\"\n levelType=\"TimeYears\"/>\n <Level name=\"Quarter\" column=\"quarter\" uniqueMembers=\"false\"\n levelType=\"TimeQuarters\"/>\n <Level name=\"Month\" column=\"month_of_year\" uniqueMembers=\"false\"\n type=\"Numeric\" levelType=\"TimeMonths\"/>\n </Hierarchy>\n </Dimension>\n <Dimension name=\"Store\" foreignKey=\"employee_id\" >\n <Hierarchy hasAll=\"true\" primaryKey=\"employee_id\"\n primaryKeyTable=\"employee\">\n <Join leftKey=\"store_id\" rightKey=\"store_id\">\n <Table name=\"employee\"/>\n <Table name=\"store\"/>\n </Join>\n <Level name=\"Store Country\" table=\"store\" column=\"store_country\"\n uniqueMembers=\"true\"/>\n <Level name=\"Store State\" table=\"store\" column=\"store_state\"\n uniqueMembers=\"true\"/>\n <Level name=\"Store City\" table=\"store\" column=\"store_city\"\n uniqueMembers=\"false\"/>\n <Level name=\"Store Name\" table=\"store\" column=\"store_name\"\n uniqueMembers=\"true\">\n <Property name=\"Store Type\" column=\"store_type\"/>\n <Property name=\"Store Manager\" column=\"store_manager\"/>\n <Property name=\"Store Sqft\" column=\"store_sqft\" type=\"Numeric\"/>\n <Property name=\"Grocery Sqft\" column=\"grocery_sqft\" type=\"Numeric\"/>\n <Property name=\"Frozen Sqft\" column=\"frozen_sqft\" type=\"Numeric\"/>\n <Property name=\"Meat Sqft\" column=\"meat_sqft\" type=\"Numeric\"/>\n <Property name=\"Has coffee bar\" column=\"coffee_bar\" type=\"Boolean\"/>\n <Property name=\"Street address\" column=\"store_street_address\"\n type=\"String\"/>\n </Level>\n </Hierarchy>\n </Dimension>\n <Dimension name=\"Pay Type\" foreignKey=\"employee_id\">\n <Hierarchy hasAll=\"true\" primaryKey=\"employee_id\"\n primaryKeyTable=\"employee\">\n <Join leftKey=\"position_id\" rightKey=\"position_id\">\n <Table name=\"employee\"/>\n <Table name=\"position\"/>\n </Join>\n <Level name=\"Pay Type\" table=\"position\" column=\"pay_type\"\n uniqueMembers=\"true\"/>\n </Hierarchy>\n </Dimension>\n <Dimension name=\"Store Type\" foreignKey=\"employee_id\">\n <Hierarchy hasAll=\"true\" primaryKeyTable=\"employee\" primaryKey=\"employee_id\">\n <Join leftKey=\"store_id\" rightKey=\"store_id\">\n <Table name=\"employee\"/>\n <Table name=\"store\"/>\n </Join>\n <Level name=\"Store Type\" table=\"store\" column=\"store_type\"\n uniqueMembers=\"true\"/>\n </Hierarchy>\n </Dimension>\n <Dimension name=\"Position\" foreignKey=\"employee_id\">\n <Hierarchy hasAll=\"true\" allMemberName=\"All Position\"\n primaryKey=\"employee_id\">\n <Table name=\"employee\"/>\n <Level name=\"Management Role\" uniqueMembers=\"true\"\n column=\"management_role\"/>\n <Level name=\"Position Title\" uniqueMembers=\"false\"\n column=\"position_title\" ordinalColumn=\"position_id\"/>\n </Hierarchy>\n </Dimension>\n <Dimension name=\"Department\" foreignKey=\"department_id\">\n <Hierarchy hasAll=\"true\" primaryKey=\"department_id\">\n <Table name=\"department\"/>\n <Level name=\"Department Description\" uniqueMembers=\"true\"\n column=\"department_id\"/>\n </Hierarchy>\n </Dimension>\n <Dimension name=\"Employees\" foreignKey=\"employee_id\">\n <Hierarchy hasAll=\"true\" allMemberName=\"All Employees\"\n primaryKey=\"employee_id\">\n <Table name=\"employee\"/>\n <Level name=\"Employee Id\" type=\"Numeric\" uniqueMembers=\"true\"\n column=\"employee_id\" parentColumn=\"supervisor_id\"\n nameColumn=\"full_name\" nullParentValue=\"0\">\n <Closure parentColumn=\"supervisor_id\" childColumn=\"employee_id\">\n <Table name=\"employee_closure\"/>\n </Closure>\n <Property name=\"Marital Status\" column=\"marital_status\"/>\n <Property name=\"Position Title\" column=\"position_title\"/>\n <Property name=\"Gender\" column=\"gender\"/>\n <Property name=\"Salary\" column=\"salary\"/>\n <Property name=\"Education Level\" column=\"education_level\"/>\n <Property name=\"Management Role\" column=\"management_role\"/>\n </Level>\n </Hierarchy>\n </Dimension>\n <!-- Explicit Closure of [Employees] (just for unit testing):\n == [Employees] is a parent/child hierarchy (along the relationship\n == supervisor_id/employee_id). The table employee_closure expresses the\n == closure of the parent/child relation, ie it represents\n == ancestor/descendant, having a row for each ancestor/descendant pair.\n ==\n == The closed hierarchy has two levels: the detail level (here named\n == [Employee]) is equivalent to the base hierarchy; the [Closure] level\n == relates each descendant to all its ancestors.\n <Dimension name=\"EmployeesClosure\" foreignKey=\"employee_id\">\n <Hierarchy hasAll=\"true\" allMemberName=\"All Employees\"\n primaryKey=\"employee_id\" primaryKeyTable=\"employee_closure\">\n <Join leftKey=\"supervisor_id\" rightKey=\"employee_id\">\n <Table name=\"employee_closure\"/>\n <Table name=\"employee\"/>\n </Join>\n <Level name=\"Closure\" type=\"Numeric\" uniqueMembers=\"false\"\n table=\"employee_closure\" column=\"supervisor_id\"/>\n <Level name=\"Employee\" type=\"Numeric\" uniqueMembers=\"true\"\n table=\"employee_closure\" column=\"employee_id\"/>\n </Hierarchy>\n </Dimension>\n -->\n <Measure name=\"Org Salary\" column=\"salary_paid\" aggregator=\"sum\"\n formatString=\"Currency\"/>\n <Measure name=\"Count\" column=\"employee_id\" aggregator=\"count\"\n formatString=\"#,#\"/>\n <Measure name=\"Number of Employees\" column=\"employee_id\"\n aggregator=\"distinct-count\" formatString=\"#,#\"/>\n <CalculatedMember name=\"Employee Salary\" dimension=\"Measures\"\n formatString=\"Currency\"\n formula=\"([Employees].currentmember.datamember, [Measures].[Org Salary])\"/>\n <CalculatedMember name=\"Avg Salary\" dimension=\"Measures\"\n formatString=\"Currency\"\n formula=\"[Measures].[Org Salary]/[Measures].[Number of Employees]\"/>\n</Cube>\n<!-- Cube with one ragged hierarchy (otherwise the same as the \"Sales\"\n cube). -->\n<Cube name=\"Sales Ragged\">\n <Table name=\"sales_fact_1997\"/>\n <Dimension name=\"Store\" foreignKey=\"store_id\">\n <Hierarchy hasAll=\"true\" primaryKey=\"store_id\">\n <Table name=\"store_ragged\"/>\n <Level name=\"Store Country\" column=\"store_country\" uniqueMembers=\"true\"\n hideMemberIf=\"Never\"/>\n <Level name=\"Store State\" column=\"store_state\" uniqueMembers=\"true\"\n hideMemberIf=\"IfParentsName\"/>\n <Level name=\"Store City\" column=\"store_city\" uniqueMembers=\"false\"\n hideMemberIf=\"IfBlankName\"/>\n <Level name=\"Store Name\" column=\"store_name\" uniqueMembers=\"true\"\n hideMemberIf=\"Never\">\n <Property name=\"Store Type\" column=\"store_type\"/>\n <Property name=\"Store Manager\" column=\"store_manager\"/>\n <Property name=\"Store Sqft\" column=\"store_sqft\" type=\"Numeric\"/>\n <Property name=\"Grocery Sqft\" column=\"grocery_sqft\" type=\"Numeric\"/>\n <Property name=\"Frozen Sqft\" column=\"frozen_sqft\" type=\"Numeric\"/>\n <Property name=\"Meat Sqft\" column=\"meat_sqft\" type=\"Numeric\"/>\n <Property name=\"Has coffee bar\" column=\"coffee_bar\" type=\"Boolean\"/>\n <Property name=\"Street address\" column=\"store_street_address\" type=\"String\"/>\n </Level>\n </Hierarchy>\n </Dimension>\n <DimensionUsage name=\"Store Size in SQFT\" source=\"Store Size in SQFT\"\n foreignKey=\"store_id\"/>\n <DimensionUsage name=\"Store Type\" source=\"Store Type\" foreignKey=\"store_id\"/>\n <DimensionUsage name=\"Time\" source=\"Time\" foreignKey=\"time_id\"/>\n <DimensionUsage name=\"Product\" source=\"Product\" foreignKey=\"product_id\"/>\n <Dimension name=\"Promotion Media\" foreignKey=\"promotion_id\">\n <Hierarchy hasAll=\"true\" allMemberName=\"All Media\" primaryKey=\"promotion_id\">\n <Table name=\"promotion\"/>\n <Level name=\"Media Type\" column=\"media_type\" uniqueMembers=\"true\"/>\n </Hierarchy>\n </Dimension>\n <Dimension name=\"Promotions\" foreignKey=\"promotion_id\">\n <Hierarchy hasAll=\"true\" allMemberName=\"All Promotions\" primaryKey=\"promotion_id\">\n <Table name=\"promotion\"/>\n <Level name=\"Promotion Name\" column=\"promotion_name\" uniqueMembers=\"true\"/>\n </Hierarchy>\n </Dimension>\n <Dimension name=\"Customers\" foreignKey=\"customer_id\">\n <Hierarchy hasAll=\"true\" allMemberName=\"All Customers\" primaryKey=\"customer_id\">\n <Table name=\"customer\"/>\n <Level name=\"Country\" column=\"country\" uniqueMembers=\"true\"/>\n <Level name=\"State Province\" column=\"state_province\" uniqueMembers=\"true\"/>\n <Level name=\"City\" column=\"city\" uniqueMembers=\"false\"/>\n <Level name=\"Name\" uniqueMembers=\"true\">\n <KeyExpression>\n <SQL dialect=\"oracle\">\n\"fname\" || \' \' || \"lname\"\n </SQL>\n <SQL dialect=\"access\">\nfname, \' \', lname\n </SQL>\n <SQL dialect=\"postgres\">\n\"fname\" || \' \' || \"lname\"\n </SQL>\n <SQL dialect=\"mysql\">\nCONCAT(`customer`.`fname`, \' \', `customer`.`lname`)\n </SQL>\n <SQL dialect=\"mssql\">\nfname, \' \', lname\n </SQL>\n <SQL dialect=\"generic\">\n\"lname\"\n </SQL>\n </KeyExpression>\n <Property name=\"Gender\" column=\"gender\"/>\n <Property name=\"Marital Status\" column=\"marital_status\"/>\n <Property name=\"Education\" column=\"education\"/>\n <Property name=\"Yearly Income\" column=\"yearly_income\"/>\n </Level>\n </Hierarchy>\n </Dimension>\n <Dimension name=\"Education Level\" foreignKey=\"customer_id\">\n <Hierarchy hasAll=\"true\" primaryKey=\"customer_id\">\n <Table name=\"customer\"/>\n <Level name=\"Education Level\" column=\"education\" uniqueMembers=\"true\"/>\n </Hierarchy>\n </Dimension>\n <Dimension name=\"Gender\" foreignKey=\"customer_id\">\n <Hierarchy hasAll=\"true\" allMemberName=\"All Gender\" primaryKey=\"customer_id\">\n <Table name=\"customer\"/>\n <Level name=\"Gender\" column=\"gender\" uniqueMembers=\"true\"/>\n </Hierarchy>\n </Dimension>\n <Dimension name=\"Marital Status\" foreignKey=\"customer_id\">\n <Hierarchy hasAll=\"true\" allMemberName=\"All Marital Status\" primaryKey=\"customer_id\">\n <Table name=\"customer\"/>\n <Level name=\"Marital Status\" column=\"marital_status\" uniqueMembers=\"true\"/>\n </Hierarchy>\n </Dimension>\n <Dimension name=\"Yearly Income\" foreignKey=\"customer_id\">\n <Hierarchy hasAll=\"true\" primaryKey=\"customer_id\">\n <Table name=\"customer\"/>\n <Level name=\"Yearly Income\" column=\"yearly_income\" uniqueMembers=\"true\"/>\n </Hierarchy>\n </Dimension>\n <Measure name=\"Unit Sales\" column=\"unit_sales\" aggregator=\"sum\"\n formatString=\"Standard\"/>\n <Measure name=\"Store Cost\" column=\"store_cost\" aggregator=\"sum\"\n formatString=\"#,###.00\"/>\n <Measure name=\"Store Sales\" column=\"store_sales\" aggregator=\"sum\"\n formatString=\"#,###.00\"/>\n <Measure name=\"Sales Count\" column=\"product_id\" aggregator=\"count\"\n formatString=\"#,###\"/>\n <Measure name=\"Customer Count\" column=\"customer_id\" aggregator=\"distinct-count\"\n formatString=\"#,###\"/>\n</Cube>\n<VirtualCube name=\"Warehouse and Sales\">\n <VirtualCubeDimension cubeName=\"Sales\" name=\"Customers\"/>\n <VirtualCubeDimension cubeName=\"Sales\" name=\"Education Level\"/>\n <VirtualCubeDimension cubeName=\"Sales\" name=\"Gender\"/>\n <VirtualCubeDimension cubeName=\"Sales\" name=\"Marital Status\"/>\n <VirtualCubeDimension name=\"Product\"/>\n <VirtualCubeDimension cubeName=\"Sales\" name=\"Promotion Media\"/>\n <VirtualCubeDimension cubeName=\"Sales\" name=\"Promotions\"/>\n <VirtualCubeDimension name=\"Store\"/>\n <VirtualCubeDimension name=\"Time\"/>\n <VirtualCubeDimension cubeName=\"Sales\" name=\"Yearly Income\"/>\n <VirtualCubeDimension cubeName=\"Warehouse\" name=\"Warehouse\"/>\n <VirtualCubeMeasure cubeName=\"Sales\" name=\"[Measures].[Sales Count]\"/>\n <VirtualCubeMeasure cubeName=\"Sales\" name=\"[Measures].[Store Cost]\"/>\n <VirtualCubeMeasure cubeName=\"Sales\" name=\"[Measures].[Store Sales]\"/>\n <VirtualCubeMeasure cubeName=\"Sales\" name=\"[Measures].[Unit Sales]\"/>\n <VirtualCubeMeasure cubeName=\"Warehouse\" name=\"[Measures].[Store Invoice]\"/>\n <VirtualCubeMeasure cubeName=\"Warehouse\" name=\"[Measures].[Supply Time]\"/>\n <VirtualCubeMeasure cubeName=\"Warehouse\" name=\"[Measures].[Units Ordered]\"/>\n <VirtualCubeMeasure cubeName=\"Warehouse\" name=\"[Measures].[Units Shipped]\"/>\n <VirtualCubeMeasure cubeName=\"Warehouse\" name=\"[Measures].[Warehouse Cost]\"/>\n <VirtualCubeMeasure cubeName=\"Warehouse\" name=\"[Measures].[Warehouse Profit]\"/>\n <VirtualCubeMeasure cubeName=\"Warehouse\" name=\"[Measures].[Warehouse Sales]\"/>\n <!--\n <VirtualCubeMeasure cubeName=\"Sales\" name=\"[Measures].[Store Sales Net]\"/>\n -->\n</VirtualCube>\n<!-- A California manager can only see customers and stores in California.\n They cannot drill down on Gender. -->\n<Role name=\"California manager\">\n <SchemaGrant access=\"none\">\n <CubeGrant cube=\"Sales\" access=\"all\">\n <HierarchyGrant hierarchy=\"[Store]\" access=\"custom\"\n topLevel=\"[Store].[Store Country]\">\n <MemberGrant member=\"[Store].[USA].[CA]\" access=\"all\"/>\n <MemberGrant member=\"[Store].[USA].[CA].[Los Angeles]\" access=\"none\"/>\n </HierarchyGrant>\n <HierarchyGrant hierarchy=\"[Customers]\" access=\"custom\"\n topLevel=\"[Customers].[State Province]\" bottomLevel=\"[Customers].[City]\">\n <MemberGrant member=\"[Customers].[USA].[CA]\" access=\"all\"/>\n <MemberGrant member=\"[Customers].[USA].[CA].[Los Angeles]\" access=\"none\"/>\n </HierarchyGrant>\n <HierarchyGrant hierarchy=\"[Gender]\" access=\"none\"/>\n </CubeGrant>\n </SchemaGrant>\n</Role>\n\n<Role name=\"No HR Cube\">\n <SchemaGrant access=\"all\">\n <CubeGrant cube=\"HR\" access=\"none\"/>\n </SchemaGrant>\n</Role>\n</Schema>"
  • mondrian.test.DynamicSchemaProcessorTest 
    Modifier and Type Constant Field Value
    public static final String FRAGMENT_ONE "<?xml version=\"1.0\"?>\n<Schema name=\""
    public static final String FRAGMENT_TWO "\">\n<Cube name=\"Sales\">\n <Table name=\"sales_fact_1997\"> <AggExclude name=\"agg_pl_01_sales_fact_1997\" /> <AggExclude name=\"agg_ll_01_sales_fact_1997\" /> <AggExclude name=\"agg_lc_100_sales_fact_1997\" /> <AggExclude name=\"agg_lc_06_sales_fact_1997\" /> <AggExclude name=\"agg_l_04_sales_fact_1997\" /> <AggExclude name=\"agg_l_03_sales_fact_1997\" /> <AggExclude name=\"agg_g_ms_pcat_sales_fact_1997\" /> <AggExclude name=\"agg_c_10_sales_fact_1997\" /></Table> <Dimension name=\"Fake\"><Hierarchy hasAll=\"true\"> <Level name=\"blah\" column=\"store_id\"/> </Hierarchy></Dimension> <Measure name=\"c\" column=\"store_id\" aggregator=\"count\"/></Cube>\n</Schema>\n"
    public static final String TEMPLATE_SCHEMA "<?xml version=\"1.0\"?>\n<Schema name=\"REPLACEME\">\n<Cube name=\"Sales\">\n <Table name=\"sales_fact_1997\"> <AggExclude name=\"agg_pl_01_sales_fact_1997\" /> <AggExclude name=\"agg_ll_01_sales_fact_1997\" /> <AggExclude name=\"agg_lc_100_sales_fact_1997\" /> <AggExclude name=\"agg_lc_06_sales_fact_1997\" /> <AggExclude name=\"agg_l_04_sales_fact_1997\" /> <AggExclude name=\"agg_l_03_sales_fact_1997\" /> <AggExclude name=\"agg_g_ms_pcat_sales_fact_1997\" /> <AggExclude name=\"agg_c_10_sales_fact_1997\" /></Table> <Dimension name=\"Fake\"><Hierarchy hasAll=\"true\"> <Level name=\"blah\" column=\"store_id\"/> </Hierarchy></Dimension> <Measure name=\"c\" column=\"store_id\" aggregator=\"count\"/></Cube>\n</Schema>\n"
  • mondrian.test.I18nTest 
    Modifier and Type Constant Field Value
    public static final char EA 233
    public static final char Euro 8364
    public static final char Nbsp 160
    public static final char UC 251
  • mondrian.test.MondrianOlap4jTester 
    Modifier and Type Constant Field Value
    public static final String DRIVER_CLASS_NAME "mondrian.olap4j.MondrianOlap4jDriver"
    public static final String DRIVER_URL_PREFIX "jdbc:mondrian:"
  • mondrian.test.MondrianTestRunner 
    Modifier and Type Constant Field Value
    public static final int EXCEPTION_EXIT 2
    public static final int FAILURE_EXIT 1
    public static final int SUCCESS_EXIT 0
  • mondrian.test.Ssas2005CompatibilityTest 
    Modifier and Type Constant Field Value
    public static final boolean ATTR_HIER_IMPL false
    public static final boolean AXIS_IMPL false
  • mondrian.test.StandAlone 
    Modifier and Type Constant Field Value
    public static final String ConnectionString "Provider=mondrian;Jdbc=jdbc:JSQLConnect://engdb04:1433/database=MondrianFoodmart/user=mondrian/password=password;Catalog=file:demo\\FoodMart.xml;JdbcDrivers=com.jnetdirect.jsql.JSQLDriver;"

mondrian.tui.*

mondrian.util.*

mondrian.xmla.*