| 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 | 
130025 | 
static final String | 
NAME | 
"Mondrian olap4j driver" | 
static final String | 
VERSION | 
"3.13.0.0-25" | 
| Modifier and Type | Constant Field | Value | 
|---|---|---|
public static final int | 
AMP_QUOTED_ID | 
83 | 
public static final int | 
AMP_UNQUOTED_ID | 
84 | 
public static final int | 
AND | 
1 | 
public static final int | 
APPROX_NUMERIC_LITERAL | 
75 | 
public static final int | 
AS | 
2 | 
public static final int | 
ASTERISK | 
55 | 
public static final int | 
AXIS | 
3 | 
public static final int | 
BANG | 
56 | 
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 | 
57 | 
public static final int | 
COLUMNS | 
8 | 
public static final int | 
COMMA | 
58 | 
public static final int | 
CONCAT | 
59 | 
public static final int | 
DECIMAL_NUMERIC_LITERAL | 
76 | 
public static final int | 
DEFAULT | 
0 | 
public static final int | 
DIGIT | 
86 | 
public static final int | 
DIMENSION | 
9 | 
public static final int | 
DOT | 
60 | 
public static final int | 
DOUBLE_QUOTED_STRING | 
79 | 
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 | 
61 | 
public static final int | 
EXISTING | 
41 | 
public static final int | 
EXPLAIN | 
14 | 
public static final int | 
EXPONENT | 
77 | 
public static final int | 
FIRSTROWSET | 
15 | 
public static final int | 
FOR | 
16 | 
public static final int | 
FORMAL_COMMENT | 
52 | 
public static final int | 
FROM | 
17 | 
public static final int | 
GE | 
62 | 
public static final int | 
GT | 
63 | 
public static final int | 
ID | 
81 | 
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 | 
64 | 
public static final int | 
LE | 
65 | 
public static final int | 
LETTER | 
85 | 
public static final int | 
LPAREN | 
66 | 
public static final int | 
LT | 
67 | 
public static final int | 
MATCHES | 
20 | 
public static final int | 
MAXROWS | 
21 | 
public static final int | 
MEMBER | 
22 | 
public static final int | 
MINUS | 
68 | 
public static final int | 
MULTI_LINE_COMMENT | 
53 | 
public static final int | 
NE | 
69 | 
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 | 
70 | 
public static final int | 
PROPERTIES | 
30 | 
public static final int | 
QUOTED_ID | 
82 | 
public static final int | 
RBRACE | 
71 | 
public static final int | 
RETURN | 
31 | 
public static final int | 
ROWS | 
32 | 
public static final int | 
RPAREN | 
72 | 
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 | 
51 | 
public static final int | 
SINGLE_QUOTED_STRING | 
78 | 
public static final int | 
SOLIDUS | 
73 | 
public static final int | 
THEN | 
36 | 
public static final int | 
UNSIGNED_INTEGER_LITERAL | 
74 | 
public static final int | 
WHEN | 
37 | 
public static final int | 
WHERE | 
38 | 
public static final int | 
WHITESPACE | 
80 | 
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 | 
|---|---|---|
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" | 
| 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 | 
|---|---|---|
static final String | 
CUBE | 
"<Cube name=\"mondrian2225\" visible=\"true\" cache=\"true\" enabled=\"true\">  <Table name=\"mondrian2225_fact\">    <AggName name=\"mondrian2225_agg\" ignorecase=\"true\">      <AggFactCount column=\"fact_count\"/>      <AggMeasure column=\"fact_Measure\" name=\"[Measures].[Measure]\"/>      <AggLevel column=\"dim_code\" name=\"[Product Code].[Code]\" collapsed=\"true\"/>    </AggName>  </Table>  <Dimension type=\"StandardDimension\" visible=\"true\" foreignKey=\"customer_id\" highCardinality=\"false\" name=\"Customer\">    <Hierarchy name=\"Customer\" visible=\"true\" hasAll=\"true\" primaryKey=\"customer_id\">      <Table name=\"mondrian2225_customer\"/>        <Level name=\"First Name\" visible=\"true\" column=\"customer_name\" type=\"String\" uniqueMembers=\"false\" levelType=\"Regular\" hideMemberIf=\"Never\"/>    </Hierarchy>  </Dimension>  <Dimension type=\"StandardDimension\" visible=\"true\" foreignKey=\"product_ID\" highCardinality=\"false\" name=\"Product Code\">    <Hierarchy name=\"Product Code\" visible=\"true\" hasAll=\"true\" primaryKey=\"product_id\">      <Table name=\"mondrian2225_dim\"/>      <Level name=\"Code\" visible=\"true\" column=\"product_code\" type=\"String\" uniqueMembers=\"false\" levelType=\"Regular\" hideMemberIf=\"Never\"/>    </Hierarchy>  </Dimension>  <Measure name=\"Measure\" column=\"fact\" aggregator=\"sum\" visible=\"true\"/></Cube>" | 
static final String | 
ROLE | 
"<Role name=\"Test\">  <SchemaGrant access=\"none\">    <CubeGrant cube=\"mondrian2225\" access=\"all\">      <HierarchyGrant hierarchy=\"[Customer.Customer]\" topLevel=\"[Customer.Customer].[First Name]\" access=\"custom\">        <MemberGrant member=\"[Customer.Customer].[NonExistingName]\" access=\"all\"/>      </HierarchyGrant>    </CubeGrant>  </SchemaGrant></Role>" | 
| 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 | 
"2016" | 
static final int | 
MAJOR_VERSION | 
3 | 
static final int | 
MINOR_VERSION | 
130025 | 
static final String | 
NAME | 
"mondrian" | 
static final String | 
VENDOR | 
"Pentaho" | 
static final String | 
VERSION | 
"3.13.0.0-25" | 
| 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 | 
BugMondrian2440Fixed | 
false | 
public static final boolean | 
BugMondrian2452Fixed | 
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" |