- Overview
- Package
- Class
- Tree
- Deprecated
- Index
- Help
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final String |
LEVEL_SEPARATOR |
"->" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
static final int |
CATALOG |
0 |
static final int |
COLUMN |
2 |
static final int |
TABLE |
1 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final int |
Array |
1 |
public static final int |
Constant |
64 |
public static final int |
Cube |
12 |
public static final int |
DateTime |
18 |
public static final int |
Dimension |
2 |
public static final int |
Empty |
17 |
public static final int |
Expression |
0 |
public static final int |
Hierarchy |
3 |
public static final int |
Integer |
15 |
public static final int |
Level |
4 |
public static final int |
Logical |
5 |
public static final int |
Mask |
31 |
public static final int |
Member |
6 |
public static final int |
Null |
16 |
public static final int |
Numeric |
7 |
public static final int |
Set |
8 |
public static final int |
String |
9 |
public static final int |
Symbol |
11 |
public static final int |
Tuple |
10 |
public static final int |
Unknown |
0 |
public static final int |
Value |
13 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final int |
CATALOG_NAME |
0 |
public static final int |
CUBE_NAME |
2 |
public static final int |
DIMENSION_UNIQUE_NAME |
3 |
public static final int |
HIERARCHY_UNIQUE_NAME |
4 |
public static final int |
LEVEL_NUMBER |
6 |
public static final int |
LEVEL_UNIQUE_NAME |
5 |
public static final int |
maxNofConstraintsForAdSchemaMember |
12 |
public static final int |
MDPROP_USERDEFINED0 |
19 |
public static final int |
MDTREEOP_CHILDREN |
1 |
public static final int |
MDTREEOP_SELF |
0 |
public static final int |
MEMBER_CAPTION |
9 |
public static final int |
MEMBER_NAME |
7 |
public static final int |
MEMBER_TYPE |
10 |
public static final int |
MEMBER_UNIQUE_NAME |
8 |
public static final int |
SCHEMA_NAME |
1 |
public static final int |
Tree_Operator |
11 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final String |
MEASURES_NAME |
"Measures" |
public static final String |
MEASURES_UNIQUE_NAME |
"[Measures]" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
protected static final String |
mondrianDotProperties |
"mondrian.properties" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final int |
_VALUE_EXPRESSION |
42 |
public static final int |
AMP_QUOTED_ID |
65 |
public static final int |
AND |
2 |
public static final int |
AS |
3 |
public static final int |
ASTERISK |
43 |
public static final int |
AXIS |
4 |
public static final int |
BANG |
44 |
public static final int |
CASE |
5 |
public static final int |
CAST |
6 |
public static final int |
CELL |
7 |
public static final int |
CHAPTERS |
8 |
public static final int |
COLON |
45 |
public static final int |
COLUMNS |
9 |
public static final int |
COMMA |
46 |
public static final int |
CONCAT |
47 |
public static final int |
DIMENSION |
10 |
public static final int |
DOT |
48 |
public static final int |
DRILLTHROUGH |
11 |
public static final int |
ELSE |
12 |
public static final int |
EMPTY |
13 |
public static final int |
END |
14 |
public static final int |
EOF |
0 |
public static final int |
EQ |
49 |
public static final int |
error |
1 |
public static final int |
EXPLAIN |
15 |
public static final int |
FIRSTROWSET |
16 |
public static final int |
FOR |
17 |
public static final int |
FORMULA_STRING |
67 |
public static final int |
FROM |
18 |
public static final int |
GE |
50 |
public static final int |
GT |
51 |
public static final int |
ID |
63 |
public static final int |
IN |
19 |
public static final int |
IS |
20 |
public static final int |
LBRACE |
52 |
public static final int |
LE |
53 |
public static final int |
LPAREN |
54 |
public static final int |
LT |
55 |
public static final int |
MATCHES |
21 |
public static final int |
MAXROWS |
22 |
public static final int |
MEMBER |
23 |
public static final int |
MINUS |
56 |
public static final int |
NE |
57 |
public static final int |
NON |
24 |
public static final int |
NOT |
25 |
public static final int |
NULL |
26 |
public static final int |
NUMBER |
62 |
public static final int |
ON |
27 |
public static final int |
OR |
28 |
public static final int |
PAGES |
29 |
public static final int |
PLAN |
30 |
public static final int |
PLUS |
58 |
public static final int |
PROPERTIES |
31 |
public static final int |
QUOTED_ID |
64 |
public static final int |
RBRACE |
59 |
public static final int |
RETURN |
32 |
public static final int |
ROWS |
33 |
public static final int |
RPAREN |
60 |
public static final int |
SECTIONS |
34 |
public static final int |
SELECT |
35 |
public static final int |
SET |
36 |
public static final int |
SOLIDUS |
61 |
public static final int |
STRING |
66 |
public static final int |
THEN |
37 |
public static final int |
UNKNOWN |
68 |
public static final int |
WHEN |
38 |
public static final int |
WHERE |
39 |
public static final int |
WITH |
41 |
public static final int |
XOR |
40 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final int |
ACTION_TYPE_ORDINAL |
54 |
public static final int |
AGGREGATION_TYPE_ORDINAL |
1 |
public static final int |
BACK_COLOR_ORDINAL |
30 |
public static final int |
CAPTION_ORDINAL |
3 |
public static final int |
CATALOG_NAME_ORDINAL |
10 |
public static final int |
CELL_EVALUATION_LIST_ORDINAL |
31 |
public static final int |
CELL_FORMATTER_ORDINAL |
29 |
public static final int |
CELL_FORMATTER_SCRIPT_LANGUAGE_ORDINAL |
51 |
public static final int |
CELL_FORMATTER_SCRIPT_ORDINAL |
52 |
public static final int |
CELL_ORDINAL_ORDINAL |
32 |
public static final int |
CHILDREN_CARDINALITY_ORDINAL |
23 |
public static final int |
CONTRIBUTING_CHILDREN_ORDINAL |
4 |
public static final int |
CUBE_NAME_ORDINAL |
12 |
public static final int |
DATATYPE_ORDINAL |
42 |
public static final int |
DEPTH_ORDINAL |
43 |
public static final int |
DESCRIPTION_ORDINAL |
27 |
public static final int |
DIMENSION_UNIQUE_NAME_ORDINAL |
13 |
public static final int |
DISPLAY_FOLDER_ORDINAL |
49 |
public static final int |
DISPLAY_INFO_ORDINAL |
44 |
public static final int |
DRILLTHROUGH_COUNT_ORDINAL |
55 |
public static final int |
FONT_FLAGS_ORDINAL |
36 |
public static final int |
FONT_NAME_ORDINAL |
34 |
public static final int |
FONT_SIZE_ORDINAL |
35 |
public static final int |
FORE_COLOR_ORDINAL |
33 |
public static final int |
FORMAT_EXP_ORDINAL |
53 |
public static final int |
FORMAT_EXP_PARSED_ORDINAL |
0 |
public static final int |
FORMAT_STRING_ORDINAL |
38 |
public static final int |
FORMATTED_VALUE_ORDINAL |
37 |
public static final int |
FORMULA_ORDINAL |
5 |
public static final int |
HIERARCHY_UNIQUE_NAME_ORDINAL |
14 |
public static final int |
KEY_ORDINAL |
46 |
public static final int |
LANGUAGE_ORDINAL |
50 |
public static final int |
LEVEL_NUMBER_ORDINAL |
16 |
public static final int |
LEVEL_UNIQUE_NAME_ORDINAL |
15 |
public static final int |
MEMBER_CAPTION_ORDINAL |
22 |
public static final int |
MEMBER_GUID_ORDINAL |
21 |
public static final int |
MEMBER_KEY_ORDINAL |
45 |
public static final int |
MEMBER_NAME_ORDINAL |
18 |
public static final int |
MEMBER_ORDINAL_ORDINAL |
17 |
public static final int |
MEMBER_SCOPE_ORDINAL |
6 |
public static final int |
MEMBER_TYPE_ORDINAL |
20 |
public static final int |
MEMBER_UNIQUE_NAME_ORDINAL |
19 |
public static final int |
NAME_ORDINAL |
2 |
public static final int |
NON_EMPTY_BEHAVIOR_ORDINAL |
39 |
public static final int |
PARENT_COUNT_ORDINAL |
26 |
public static final int |
PARENT_LEVEL_ORDINAL |
24 |
public static final int |
PARENT_UNIQUE_NAME_ORDINAL |
25 |
public static final int |
SCENARIO_ORDINAL |
48 |
public static final int |
SCHEMA_NAME_ORDINAL |
11 |
public static final int |
SOLVE_ORDER_ORDINAL |
40 |
public static final int |
VALUE_ORDINAL |
41 |
public static final int |
VISIBLE_ORDINAL |
28 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final boolean |
DEBUG |
false |
| Modifier and Type | Constant Field | Value |
|---|---|---|
static final String |
NAME |
"Cache" |
| 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 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public final int |
TOO_SMALL |
8 |
| 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 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
static final boolean |
debug |
false |
| Modifier and Type | Constant Field | Value |
|---|---|---|
static final int |
MAJOR_VERSION |
3 |
static final int |
MINOR_VERSION |
1100353 |
static final String |
NAME |
"Mondrian olap4j driver" |
static final String |
VERSION |
"3.11.0.0-353" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final int |
AMP_QUOTED_ID |
82 |
public static final int |
AMP_UNQUOTED_ID |
83 |
public static final int |
AND |
1 |
public static final int |
APPROX_NUMERIC_LITERAL |
74 |
public static final int |
AS |
2 |
public static final int |
ASTERISK |
54 |
public static final int |
AXIS |
3 |
public static final int |
BANG |
55 |
public static final int |
CASE |
4 |
public static final int |
CAST |
5 |
public static final int |
CELL |
6 |
public static final int |
CHAPTERS |
7 |
public static final int |
COLON |
56 |
public static final int |
COLUMNS |
8 |
public static final int |
COMMA |
57 |
public static final int |
CONCAT |
58 |
public static final int |
DECIMAL_NUMERIC_LITERAL |
75 |
public static final int |
DEFAULT |
0 |
public static final int |
DIGIT |
85 |
public static final int |
DIMENSION |
9 |
public static final int |
DOT |
59 |
public static final int |
DOUBLE_QUOTED_STRING |
78 |
public static final int |
DRILLTHROUGH |
10 |
public static final int |
ELSE |
11 |
public static final int |
EMPTY |
12 |
public static final int |
END |
13 |
public static final int |
EOF |
0 |
public static final int |
EQ |
60 |
public static final int |
EXPLAIN |
14 |
public static final int |
EXPONENT |
76 |
public static final int |
FIRSTROWSET |
15 |
public static final int |
FOR |
16 |
public static final int |
FORMAL_COMMENT |
51 |
public static final int |
FROM |
17 |
public static final int |
GE |
61 |
public static final int |
GT |
62 |
public static final int |
ID |
80 |
public static final int |
IN |
18 |
public static final int |
IN_FORMAL_COMMENT |
2 |
public static final int |
IN_MULTI_LINE_COMMENT |
3 |
public static final int |
IN_SINGLE_LINE_COMMENT |
1 |
public static final int |
IS |
19 |
public static final int |
LBRACE |
63 |
public static final int |
LE |
64 |
public static final int |
LETTER |
84 |
public static final int |
LPAREN |
65 |
public static final int |
LT |
66 |
public static final int |
MATCHES |
20 |
public static final int |
MAXROWS |
21 |
public static final int |
MEMBER |
22 |
public static final int |
MINUS |
67 |
public static final int |
MULTI_LINE_COMMENT |
52 |
public static final int |
NE |
68 |
public static final int |
NON |
23 |
public static final int |
NOT |
24 |
public static final int |
NULL |
25 |
public static final int |
ON |
26 |
public static final int |
OR |
27 |
public static final int |
PAGES |
28 |
public static final int |
PLAN |
29 |
public static final int |
PLUS |
69 |
public static final int |
PROPERTIES |
30 |
public static final int |
QUOTED_ID |
81 |
public static final int |
RBRACE |
70 |
public static final int |
RETURN |
31 |
public static final int |
ROWS |
32 |
public static final int |
RPAREN |
71 |
public static final int |
SECTIONS |
33 |
public static final int |
SELECT |
34 |
public static final int |
SET |
35 |
public static final int |
SINGLE_LINE_COMMENT |
50 |
public static final int |
SINGLE_QUOTED_STRING |
77 |
public static final int |
SOLIDUS |
72 |
public static final int |
THEN |
36 |
public static final int |
UNSIGNED_INTEGER_LITERAL |
73 |
public static final int |
WHEN |
37 |
public static final int |
WHERE |
38 |
public static final int |
WHITESPACE |
79 |
public static final int |
WITH |
40 |
public static final int |
XOR |
39 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final boolean |
staticFlag |
false |
| Modifier and Type | Constant Field | Value |
|---|---|---|
static final int |
INVALID_LEXICAL_STATE |
2 |
static final int |
LEXICAL_ERROR |
0 |
static final int |
LOOP_DETECTED |
3 |
static final int |
STATIC_LEXER_ERROR |
1 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final int |
DEFAULT_MSG_LIMIT |
10 |
| 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" |
| 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 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final String |
JdbcPropertyPrefix |
"jdbc." |
| Modifier and Type | Constant Field | Value |
|---|---|---|
static final int |
FLAG_ALL |
2 |
static final int |
FLAG_UNIQUE |
4 |
| 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 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final String |
sqlNullLiteral |
"null" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final double |
MOCK_CELL_VALUE |
123.123 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
protected static final int |
BAD_ID |
-1 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
protected static final int |
BAD_ID |
-1 |
| 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 |
| 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>" |
| 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>" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
static final String |
COPYRIGHT_YEAR |
"2015" |
static final int |
MAJOR_VERSION |
3 |
static final int |
MINOR_VERSION |
1100353 |
static final String |
NAME |
"mondrian" |
static final String |
VENDOR |
"Pentaho" |
static final String |
VERSION |
"3.11.0.0-353" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
static final String |
EmptyResult |
"Axis #0:\n{}\nAxis #1:\nAxis #2:\n" |
| 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=\""warehouse_sales"-"inventory_fact_1997"."warehouse_cost"\" 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>" |
| 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" |
| 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 |
| 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:" |
| 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 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final boolean |
ATTR_HIER_IMPL |
false |
public static final boolean |
AXIS_IMPL |
false |
| 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;" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final String |
ACTION_AFTER_TAG |
"ActionAfter:" |
public static final String |
ACTION_BEFORE_TAG |
"ActionBefore:" |
public static final String |
COLUMN_NAMES_TAG |
"ColumnNames:" |
public static final String |
COLUMN_TYPES_TAG |
"ColumnTypes:" |
public static final String |
CREATE_INDEX_TAG |
"CreateIndex" |
public static final String |
DROP_INDEX_TAG |
"DropIndex" |
public static final String |
FILE_NAME_TAG |
"FileName:" |
public static final String |
NOS_OF_ROWS_TAG |
"NosOfRows:" |
public static final String |
TABLE_NAME_TAG |
"TableName:" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final char |
BRACES_END |
125 |
public static final char |
BRACES_START |
123 |
public static final char |
BRACKET_END |
91 |
public static final char |
BRACKET_START |
91 |
public static final char |
CHEVRON_END |
62 |
public static final char |
CHEVRON_START |
60 |
public static final char |
DEFAULT_SEPARATOR |
44 |
public static final char |
DOUBLE_QUOTE |
34 |
public static final char |
PAREN_END |
41 |
public static final char |
PAREN_START |
40 |
public static final char |
SINGLE_QUOTE |
39 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final String |
BATCH_SIZE_PROP |
"mondrian.test.loader.batch.size" |
public static final String |
CREATE_TABLE_INDEX_PROP |
"mondrian.test.loader.create.table.index.suffix" |
public static final String |
CREATE_TABLE_INDEX_SUFFIX_DEFAULT |
"createindex.sql" |
public static final String |
CREATE_TABLE_PROP |
"mondrian.test.loader.create.table.suffix" |
public static final String |
CREATE_TABLE_SUFFIX_DEFAULT |
"create.sql" |
static final String |
dateFormatString |
"yyyy-MM-dd" |
public static final String |
DROP_TABLE_INDEX_PROP |
"mondrian.test.loader.drop.table.index.suffix" |
public static final String |
DROP_TABLE_INDEX_SUFFIX_DEFAULT |
"dropindex.sql" |
public static final String |
DROP_TABLE_PROP |
"mondrian.test.loader.drop.table.suffix" |
public static final String |
DROP_TABLE_ROWS_PROP |
"mondrian.test.loader.drop.table.rows.suffix" |
public static final String |
DROP_TABLE_ROWS_SUFFIX_DEFAULT |
"droprows.sql" |
public static final String |
DROP_TABLE_SUFFIX_DEFAULT |
"drop.sql" |
public static final String |
FORCE_PROP |
"mondrian.test.loader.force" |
public static final String |
JDBC_DRIVER_PROP |
"mondrian.test.loader.jdbc.driver" |
public static final String |
JDBC_PASSWORD_PROP |
"mondrian.test.loader.jdbc.password" |
public static final String |
JDBC_URL_PROP |
"mondrian.test.loader.jdbc.url" |
public static final String |
JDBC_USER_PROP |
"mondrian.test.loader.jdbc.user" |
public static final String |
LOAD_TABLE_ROWS_PROP |
"mondrian.test.loader.load.table.rows.suffix" |
public static final String |
LOAD_TABLE_ROWS_SUFFIX_DEFAULT |
"loadrows.sql" |
static final String |
oracleDateFormatString |
"YYYY-MM-DD" |
public static final String |
OUTPUT_DIRECTORY_PROP |
"mondrian.test.loader.output.directory" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final String |
DATE_FORMAT_HEADER |
"EEE, d MMM yyyy HH:mm:ss Z" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final String |
DATE_FORMAT_HEADER |
"EEE, d MMM yyyy HH:mm:ss Z" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final String |
PARAM_CALLBACKS |
"Callbacks" |
public static final String |
PARAM_CHAR_ENCODING |
"CharacterEncoding" |
public static final String |
PARAM_DATASOURCES_CONFIG |
"DataSourcesConfig" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final String |
CATALOG_NAME |
"FoodMart" |
public static final String |
DATASOURCE_DESCRIPTION |
"Mondrian FoodMart data source" |
public static final String |
DATASOURCE_INFO |
"Provider=Mondrian;DataSource=FoodMart;" |
public static final String |
DATASOURCE_NAME |
"FoodMart" |
public static final String |
ROW_SET_PREFIX |
"ROW" |
public static final String |
SOAP_PREFIX |
"SOAP-ENV" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final String |
DEFER_NODE_EXPANSION |
"http://apache.org/xml/features/dom/defer-node-expansion" |
public static final String |
FULL_SCHEMA_VALIDATION_FEATURE_ID |
"http://apache.org/xml/features/validation/schema-full-checking" |
public static final String |
NAMESPACES_FEATURE_ID |
"http://xml.org/sax/features/namespaces" |
public static final String |
SCHEMA_LOCATION |
"http://apache.org/xml/properties/schema/external-schemaLocation" |
public static final String |
SCHEMA_VALIDATION_FEATURE_ID |
"http://apache.org/xml/features/validation/schema" |
public static final String |
SOAP_PREFIX |
"SOAP-ENV" |
public static final String |
VALIDATION_FEATURE_ID |
"http://xml.org/sax/features/validation" |
public static final String |
XMLNS |
"xmlns" |
public static final String |
XSD_PREFIX |
"xsd" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final String |
ERROR_STRING |
"ERROR" |
public static final String |
FATAL_ERROR_STRING |
"FATAL" |
public static final short |
SEVERITY_ERROR |
2 |
public static final short |
SEVERITY_FATAL_ERROR |
3 |
public static final short |
SEVERITY_WARNING |
1 |
public static final String |
WARNING_STRING |
"WARNING" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final int |
DECODE |
0 |
public static final int |
DONT_BREAK_LINES |
8 |
public static final int |
ENCODE |
1 |
public static final int |
GZIP |
2 |
public static final int |
NO_OPTIONS |
0 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final boolean |
BugMondrian1001Fixed |
false |
public static final boolean |
BugMondrian207Fixed |
false |
public static final boolean |
BugMondrian229Fixed |
false |
public static final boolean |
BugMondrian313Fixed |
false |
public static final boolean |
BugMondrian314Fixed |
false |
public static final boolean |
BugMondrian328Fixed |
false |
public static final boolean |
BugMondrian361Fixed |
false |
public static final boolean |
BugMondrian441Fixed |
false |
public static final boolean |
BugMondrian446Fixed |
false |
public static final boolean |
BugMondrian486Fixed |
false |
public static final boolean |
BugMondrian495Fixed |
false |
public static final boolean |
BugMondrian503Fixed |
false |
public static final boolean |
BugMondrian555Fixed |
false |
public static final boolean |
BugMondrian584Fixed |
false |
public static final boolean |
BugMondrian641Fixed |
false |
public static final boolean |
BugMondrian648Fixed |
false |
public static final boolean |
BugMondrian687Fixed |
false |
public static final boolean |
BugMondrian747Fixed |
false |
public static final boolean |
BugMondrian759Fixed |
false |
public static final boolean |
BugMondrian785Fixed |
false |
public static final boolean |
BugSegregateRolapCubeMemberFixed |
false |
public static final boolean |
Checkin7641UseOptimizer |
false |
public static final boolean |
Ssas2005Compatible |
false |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final int |
MAX_LONG_DIGITS |
19 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final int |
CacheLimit |
1000 |
static final String |
currencyFormat_en |
"$#,##0.00" |
static final String |
currencySymbol_en |
"$" |
static final String |
dateSeparator_en |
"/" |
static final char |
decimalPlaceholder_en |
46 |
static final char |
intlCurrencySymbol |
164 |
static final int |
LEFT_OF_POINT |
1 |
static final int |
NOT_IN_A_NUMBER |
0 |
static final int |
RIGHT_OF_EXP |
3 |
static final int |
RIGHT_OF_POINT |
2 |
static final char |
thousandSeparator_en |
44 |
static final String |
timeSeparator_en |
":" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
static final int |
PERCENT_100 |
100 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
protected static final int |
DEFAULT_CAPACITY |
277 |
protected static final double |
DEFAULT_MAX_LOAD_FACTOR |
0.5 |
protected static final double |
DEFAULT_MIN_LOAD_FACTOR |
0.2 |
protected static final byte |
FREE |
0 |
protected static final byte |
FULL |
1 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final int |
largestPrime |
2147483647 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
static final int |
allDaysOfMonthBitmap |
-268435457 |
static final int |
allDaysOfWeekBitmap |
254 |
static final int |
allWeeksOfMonthBitmap |
63 |
public static final int |
LAST_DAY_OF_MONTH |
0 |
public static final int |
LAST_WEEK_OF_MONTH |
0 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final int |
weekdays |
124 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final String |
AuthenticationMode |
"AuthenticationMode" |
public static final String |
DataSourceDescription |
"DataSourceDescription" |
public static final String |
DataSourceInfo |
"DataSourceInfo" |
public static final String |
DataSourceName |
"DataSourceName" |
public static final String |
Definition |
"Definition" |
public static final String |
ProviderName |
"ProviderName" |
public static final String |
ProviderType |
"ProviderType" |
public static final String |
URL |
"URL" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final String |
AUTH_MODE_AUTHENTICATED |
"Authenticated" |
public static final String |
AUTH_MODE_INTEGRATED |
"Integrated" |
public static final String |
AUTH_MODE_UNAUTHENTICATED |
"Unauthenticated" |
public static final String |
PROVIDER_TYPE_DMP |
"DMP" |
public static final String |
PROVIDER_TYPE_MDP |
"MDP" |
public static final String |
PROVIDER_TYPE_TDP |
"TDP" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
static final String |
UUID_PATTERN |
"[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
static final boolean |
NOT_RESTRICTION |
false |
static final boolean |
ONE_MAX |
false |
static final boolean |
OPTIONAL |
true |
static final boolean |
REQUIRED |
false |
static final boolean |
RESTRICTION |
true |
static final boolean |
UNBOUNDED |
true |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final String |
MD_CUBTYPE_CUBE |
"CUBE" |
public static final String |
MD_CUBTYPE_VIRTUAL_CUBE |
"VIRTUAL CUBE" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final int |
MD_DIMTYPE_MEASURE |
2 |
public static final int |
MD_DIMTYPE_OTHER |
3 |
public static final int |
MD_DIMTYPE_TIME |
1 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final int |
MDLEVEL_TYPE_ALL |
1 |
public static final int |
MDLEVEL_TYPE_CALCULATED |
2 |
public static final int |
MDLEVEL_TYPE_REGULAR |
0 |
public static final int |
MDLEVEL_TYPE_RESERVED1 |
8 |
public static final int |
MDLEVEL_TYPE_TIME |
4 |
public static final int |
MDLEVEL_TYPE_TIME_DAYS |
516 |
public static final int |
MDLEVEL_TYPE_TIME_HALF_YEAR |
36 |
public static final int |
MDLEVEL_TYPE_TIME_HOURS |
772 |
public static final int |
MDLEVEL_TYPE_TIME_MINUTES |
1028 |
public static final int |
MDLEVEL_TYPE_TIME_MONTHS |
132 |
public static final int |
MDLEVEL_TYPE_TIME_QUARTERS |
68 |
public static final int |
MDLEVEL_TYPE_TIME_SECONDS |
2052 |
public static final int |
MDLEVEL_TYPE_TIME_UNDEFINED |
4100 |
public static final int |
MDLEVEL_TYPE_TIME_WEEKS |
260 |
public static final int |
MDLEVEL_TYPE_TIME_YEARS |
20 |
public static final int |
MDLEVEL_TYPE_UNKNOWN |
0 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final int |
MDMEASURE_AGGR_AVG |
5 |
public static final int |
MDMEASURE_AGGR_CALCULATED |
127 |
public static final int |
MDMEASURE_AGGR_COUNT |
2 |
public static final int |
MDMEASURE_AGGR_MAX |
4 |
public static final int |
MDMEASURE_AGGR_MIN |
3 |
public static final int |
MDMEASURE_AGGR_STD |
7 |
public static final int |
MDMEASURE_AGGR_SUM |
1 |
public static final int |
MDMEASURE_AGGR_UNKNOWN |
0 |
public static final int |
MDMEASURE_AGGR_VAR |
6 |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final String |
CATALOG |
"FoodMart" |
public static final String |
CATALOG_NAME_PROP |
"catalog.name" |
public static final String |
CATALOG_PROP |
"catalog" |
public static final String |
CUBE_NAME_PROP |
"cube.name" |
public static final String |
DATA_SOURCE_INFO |
"FoodMart" |
public static final String |
DATA_SOURCE_INFO_PROP |
"data.source.info" |
protected static final boolean |
DEBUG |
false |
public static final String |
FORMAT_MULTI_DIMENSIONAL |
"Multidimensional" |
public static final String |
FORMAT_PROP |
"format" |
protected static final String |
LAST_SCHEMA_UPDATE_DATE |
"xxxx-xx-xxTxx:xx:xx" |
public static final String |
LOCALE_PROP |
"locale" |
public static final String |
REQUEST_TYPE_PROP |
"request.type" |
public static final String |
ROLE_PROP |
"Role" |
public static final String |
SALES_CUBE |
"Sales" |
public static final String |
SESSION_ID_PROP |
"session.id" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final String |
CONTENT_PROP |
"content" |
public static final String |
FORMAT_TABLULAR |
"Tabular" |
public static final String |
RESTRICTION_NAME_PROP |
"restriction.name" |
public static final String |
RESTRICTION_VALUE_PROP |
"restriction.value" |
public static final String |
UNIQUE_NAME_ELEMENT |
"unique.name.element" |
public static final String |
UNIQUE_NAME_PROP |
"unique.name" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final String |
CHH_AUTHORIZATION_CODE |
"00CHHA02" |
public static final String |
CHH_AUTHORIZATION_FAULT_FS |
"Error in Callback processHttpHeader Authorization" |
public static final String |
CHH_CODE |
"00CHHA01" |
public static final String |
CHH_FAULT_FS |
"Error in Callback processHttpHeader" |
public static final String |
CLIENT_FAULT_FC |
"Client" |
public static final String |
CONTEXT_MIME_TYPE |
"language" |
public static final String |
CONTEXT_ROLE_NAME |
"role_name" |
public static final String |
CONTEXT_XMLA_PASSWORD |
"password" |
public static final String |
CONTEXT_XMLA_SESSION_ID |
"session_id" |
public static final String |
CONTEXT_XMLA_SESSION_STATE |
"SessionState" |
public static final String |
CONTEXT_XMLA_SESSION_STATE_BEGIN |
"SessionStateBegin" |
public static final String |
CONTEXT_XMLA_SESSION_STATE_END |
"SessionStateEnd" |
public static final String |
CONTEXT_XMLA_SESSION_STATE_WITHIN |
"SessionStateWithin" |
public static final String |
CONTEXT_XMLA_USERNAME |
"username" |
public static final String |
CPOSTA_CODE |
"00CPOSTA01" |
public static final String |
CPOSTA_FAULT_FS |
"Error in Callback PostAction" |
public static final String |
CPREA_CODE |
"00CPREA01" |
public static final String |
CPREA_FAULT_FS |
"Error in Callback PreAction" |
public static final String |
FAULT_ACTOR |
"Mondrian" |
public static final String |
FAULT_FC_PREFIX |
"Mondrian" |
public static final String |
FAULT_FS_PREFIX |
"The Mondrian XML: " |
public static final String |
FAULT_NS_PREFIX |
"XA" |
public static final String |
HSB_ACCESS_DENIED_CODE |
"00HSBC02" |
public static final String |
HSB_ACCESS_DENIED_FAULT_FS |
"XMLA connection with role must be authenticated" |
public static final String |
HSB_BAD_COMMAND_CODE |
"00HSBB07" |
public static final String |
HSB_BAD_COMMAND_FAULT_FS |
"XMLA SOAP bad Execute Command element" |
public static final String |
HSB_BAD_METHOD_CODE |
"00HSBB02" |
public static final String |
HSB_BAD_METHOD_FAULT_FS |
"XMLA SOAP bad method" |
public static final String |
HSB_BAD_METHOD_NS_CODE |
"00HSBB03" |
public static final String |
HSB_BAD_METHOD_NS_FAULT_FS |
"XMLA SOAP bad method namespace" |
public static final String |
HSB_BAD_NON_NULLABLE_COLUMN_CODE |
"00HSBB16" |
public static final String |
HSB_BAD_NON_NULLABLE_COLUMN_FAULT_FS |
"XMLA SOAP non-nullable column" |
public static final String |
HSB_BAD_PROPERTIES_CODE |
"00HSBB06" |
public static final String |
HSB_BAD_PROPERTIES_FAULT_FS |
"XMLA SOAP bad Discover or Execute Properties element" |
public static final String |
HSB_BAD_PROPERTIES_LIST_CODE |
"00HSBB09" |
public static final String |
HSB_BAD_PROPERTIES_LIST_FAULT_FS |
"XMLA SOAP bad Discover or Execute PropertyList element" |
public static final String |
HSB_BAD_REQUEST_TYPE_CODE |
"00HSBB04" |
public static final String |
HSB_BAD_REQUEST_TYPE_FAULT_FS |
"XMLA SOAP bad Discover RequestType element" |
public static final String |
HSB_BAD_RESTRICTION_LIST_CODE |
"00HSBB08" |
public static final String |
HSB_BAD_RESTRICTION_LIST_FAULT_FS |
"XMLA SOAP too many Discover RestrictionList element" |
public static final String |
HSB_BAD_RESTRICTIONS_CODE |
"00HSBB05" |
public static final String |
HSB_BAD_RESTRICTIONS_FAULT_FS |
"XMLA SOAP bad Discover Restrictions element" |
public static final String |
HSB_BAD_SOAP_BODY_CODE |
"00HSBA01" |
public static final String |
HSB_BAD_SOAP_BODY_FAULT_FS |
"SOAP Body not correctly formed" |
public static final String |
HSB_BAD_STATEMENT_CODE |
"00HSBB10" |
public static final String |
HSB_BAD_STATEMENT_FAULT_FS |
"XMLA SOAP bad Execute Statement element" |
public static final String |
HSB_CONNECTION_DATA_SOURCE_CODE |
"00HSBC01" |
public static final String |
HSB_CONNECTION_DATA_SOURCE_FAULT_FS |
"XMLA connection datasource not found" |
public static final String |
HSB_DISCOVER_FORMAT_CODE |
"00HSBE01" |
public static final String |
HSB_DISCOVER_FORMAT_FAULT_FS |
"XMLA Discover format error" |
public static final String |
HSB_DISCOVER_UNPARSE_CODE |
"00HSBE02" |
public static final String |
HSB_DISCOVER_UNPARSE_FAULT_FS |
"XMLA Discover unparse results error" |
public static final String |
HSB_DRILL_THROUGH_FORMAT_CODE |
"00HSBE02" |
public static final String |
HSB_DRILL_THROUGH_FORMAT_FAULT_FS |
"XMLA Drill Through format error" |
public static final String |
HSB_DRILL_THROUGH_NOT_ALLOWED_CODE |
"00HSBF01" |
public static final String |
HSB_DRILL_THROUGH_NOT_ALLOWED_FAULT_FS |
"XMLA Drill Through not allowed" |
public static final String |
HSB_DRILL_THROUGH_SQL_CODE |
"00HSBF02" |
public static final String |
HSB_DRILL_THROUGH_SQL_FAULT_FS |
"XMLA Drill Through SQL error" |
public static final String |
HSB_EXECUTE_QUERY_CODE |
"00HSBD02" |
public static final String |
HSB_EXECUTE_QUERY_FAULT_FS |
"XMLA MDX execute failed" |
public static final String |
HSB_EXECUTE_UNPARSE_CODE |
"00HSBE03" |
public static final String |
HSB_EXECUTE_UNPARSE_FAULT_FS |
"XMLA Execute unparse results error" |
public static final String |
HSB_PARSE_QUERY_CODE |
"00HSBD01" |
public static final String |
HSB_PARSE_QUERY_FAULT_FS |
"XMLA MDX parse failed" |
public static final String |
HSB_PROCESS_CODE |
"00HSBB01" |
public static final String |
HSB_PROCESS_FAULT_FS |
"XMLA SOAP Body processing error" |
public static final String |
HSB_UNKNOWN_CODE |
"00HSBU01" |
public static final String |
HSB_UNKNOWN_FAULT_FS |
"Unknown error handle soap body" |
public static final String |
HSH_BAD_SESSION_ID_CODE |
"00HSHB01" |
public static final String |
HSH_BAD_SESSION_ID_FAULT_FS |
"Bad Session Id, re-start session" |
public static final String |
HSH_MUST_UNDERSTAND_CODE |
"00HSHA01" |
public static final String |
HSH_MUST_UNDERSTAND_FAULT_FS |
"SOAP Header must understand element not recognized" |
public static final String |
HSH_UNKNOWN_CODE |
"00HSHU01" |
public static final String |
HSH_UNKNOWN_FAULT_FS |
"Unknown error handle soap header" |
public static final String |
MONDRIAN_NAMESPACE |
"http://mondrian.sourceforge.net" |
public static final String |
MSM_UNKNOWN_CODE |
"00MSMU01" |
public static final String |
MSM_UNKNOWN_FAULT_FS |
"Unknown error marshalling soap message" |
public static final String |
MUST_UNDERSTAND_FAULT_FC |
"MustUnderstand" |
public static final String |
NS_SOAP_ENC_1_1 |
"http://schemas.xmlsoap.org/soap/encoding/" |
public static final String |
NS_SOAP_ENC_1_2 |
"http://www.w3.org/2003/05/soap-encoding" |
public static final String |
NS_SOAP_ENV_1_1 |
"http://schemas.xmlsoap.org/soap/envelope/" |
public static final String |
NS_SOAP_ENV_1_2 |
"http://www.w3.org/2003/05/soap-envelope" |
public static final String |
NS_SOAP_SECEXT |
"http://schemas.xmlsoap.org/ws/2002/04/secext" |
public static final String |
NS_SQL |
"urn:schemas-microsoft-com:xml-sql" |
public static final String |
NS_XMLA |
"urn:schemas-microsoft-com:xml-analysis" |
public static final String |
NS_XMLA_EMPTY |
"urn:schemas-microsoft-com:xml-analysis:empty" |
public static final String |
NS_XMLA_EX |
"urn:schemas-microsoft-com:xml-analysis:exception" |
public static final String |
NS_XMLA_MDDATASET |
"urn:schemas-microsoft-com:xml-analysis:mddataset" |
public static final String |
NS_XMLA_ROWSET |
"urn:schemas-microsoft-com:xml-analysis:rowset" |
public static final String |
NS_XSD |
"http://www.w3.org/2001/XMLSchema" |
public static final String |
NS_XSI |
"http://www.w3.org/2001/XMLSchema-instance" |
public static final String |
SERVER_FAULT_FC |
"Server" |
public static final String |
SOAP_MUST_UNDERSTAND_ATTR |
"mustUnderstand" |
public static final String |
SOAP_PREFIX |
"SOAP-ENV" |
public static final String |
UNKNOWN_ERROR_CODE |
"00UE001" |
public static final String |
UNKNOWN_ERROR_FAULT_FS |
"Internal Error" |
public static final String |
USM_DOM_FACTORY_CODE |
"00USMB01" |
public static final String |
USM_DOM_FACTORY_FAULT_FS |
"DocumentBuilder cannot be created which satisfies the configuration requested" |
public static final String |
USM_DOM_PARSE_CODE |
"00USMC02" |
public static final String |
USM_DOM_PARSE_FAULT_FS |
"DOM parse errors occur" |
public static final String |
USM_DOM_PARSE_IO_CODE |
"00USMC01" |
public static final String |
USM_DOM_PARSE_IO_FAULT_FS |
"DOM parse IO errors occur" |
public static final String |
USM_REQUEST_INPUT_CODE |
"00USMA02" |
public static final String |
USM_REQUEST_INPUT_FAULT_FS |
"Request input Exception occurred" |
public static final String |
USM_REQUEST_STATE_CODE |
"00USMA01" |
public static final String |
USM_REQUEST_STATE_FAULT_FS |
"Request input method invoked at illegal time" |
public static final String |
USM_UNKNOWN_CODE |
"00USMU01" |
public static final String |
USM_UNKNOWN_FAULT_FS |
"Unknown error unmarshalling soap message" |
public static final String |
VERSION_MISSMATCH_FAULT_FC |
"VersionMismatch" |
public static final String |
XMLA_BEGIN_SESSION |
"BeginSession" |
public static final String |
XMLA_END_SESSION |
"EndSession" |
public static final String |
XMLA_SECURITY |
"Security" |
public static final String |
XMLA_SESSION |
"Session" |
public static final String |
XMLA_SESSION_ID |
"SessionId" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final String |
JDBC_LOCALE |
"locale" |
public static final String |
XSD_BOOLEAN |
"xsd:boolean" |
public static final String |
XSD_BYTE |
"xsd:byte" |
public static final byte |
XSD_BYTE_MAX_INCLUSIVE |
127 |
public static final byte |
XSD_BYTE_MIN_INCLUSIVE |
-128 |
public static final String |
XSD_DECIMAL |
"xsd:decimal" |
public static final String |
XSD_DOUBLE |
"xsd:double" |
public static final String |
XSD_FLOAT |
"xsd:float" |
public static final String |
XSD_INT |
"xsd:int" |
public static final int |
XSD_INT_MAX_INCLUSIVE |
2147483647 |
public static final int |
XSD_INT_MIN_INCLUSIVE |
-2147483648 |
public static final String |
XSD_INTEGER |
"xsd:integer" |
public static final String |
XSD_LONG |
"xsd:long" |
public static final long |
XSD_LONG_MAX_INCLUSIVE |
9223372036854775807L |
public static final long |
XSD_LONG_MIN_INCLUSIVE |
-9223372036854775808L |
public static final String |
XSD_SHORT |
"xsd:short" |
public static final short |
XSD_SHORT_MAX_INCLUSIVE |
32767 |
public static final short |
XSD_SHORT_MIN_INCLUSIVE |
-32768 |
public static final String |
XSD_STRING |
"xsd:string" |
public static final String |
XSD_UNSIGNED_INT |
"xsd:unsignedInt" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final String |
AUTHORIZATION |
"Authorization" |
public static final String |
EXPECT |
"Expect" |
public static final String |
EXPECT_100_CONTINUE |
"100-continue" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final String |
PARAM_CALLBACKS |
"Callbacks" |
public static final String |
PARAM_CHAR_ENCODING |
"CharacterEncoding" |
public static final String |
PARAM_DATASOURCES_CONFIG |
"DataSourcesConfig" |
public static final String |
PARAM_OPTIONAL_DATASOURCE_CONFIG |
"OptionalDataSourceConfig" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final String |
DEFAULT_DATASOURCE_FILE |
"datasources.xml" |
| Modifier and Type | Constant Field | Value |
|---|---|---|
public static final String |
CATALOG_NAME |
"FoodMart" |
public static final String |
DATASOURCE_DESCRIPTION |
"Mondrian FoodMart Test data source" |
public static final String |
DATASOURCE_INFO |
"Provider=Mondrian;DataSource=FoodMart;" |
public static final String |
DATASOURCE_NAME |
"FoodMart" |