UDMLCode
DECLARE DATABASE "Paint" AS "Paint" UPGRADE ID 161 TYPE XMLDirect
FEATURES (
'LEFT_OUTER_JOIN_SUPPORTED' = 'No',
'RIGHT_OUTER_JOIN_SUPPORTED' = 'No',
'FULL_OUTER_JOIN_SUPPORTED' = 'No',
'NESTED_OUTER_JOIN_SUPPORTED' = 'No',
'UNION_SUPPORTED' = 'No',
'UNION_ALL_SUPPORTED' = 'No',
'COUNT_SUPPORTED' = 'No',
'COUNT_DISTINCT_SUPPORTED' = 'No',
'COUNT_STAR_SUPPORTED' = 'No',
'SUM_SUPPORTED' = 'No',
'AVG_SUPPORTED' = 'No',
'MIN_SUPPORTED' = 'No',
'MAX_SUPPORTED' = 'No',
'FIRST_SUPPORTED' = 'No',
'LAST_SUPPORTED' = 'No',
'RANK_SUPPORTED' = 'No',
'PERCENTILE_SUPPORTED' = 'No',
'MOVING_AVG_SUPPORTED' = 'No',
'TOPN_SUPPORTED' = 'No',
'BOTTOMN_SUPPORTED' = 'No',
'GROUP_BY_SUPPORTED' = 'No',
'GROUP_BY_EXPR_SUPPORTED' = 'No',
'HAVING_SUPPORTED' = 'No',
'PARAMETERS_IN_HAVING_CLAUSE_SUPPORTED' = 'No',
'ORDERBY_SUPPORTED' = 'No',
'EXPRESSIONS_IN_ORDERBY_SUPPORTED' = 'No',
'ORDER_BY_COLUMNS_IN_SELECT_SUPPORTED' = 'No',
'NULL_VALUES_SORT_FIRST' = 'No',
'DISTINCT_SUPPORTED' = 'No',
'CASE_LOOK_UP_SUPPORTED' = 'No',
'CASE_IF_SUPPORTED' = 'No',
'DATE_LITERAL_SUPPORTED' = 'No',
'TIME_LITERAL_SUPPORTED' = 'No',
'DATE_TIME_LITERAL_SUPPORTED' = 'No',
'INTERVAL_LITERAL_SUPPORTED' = 'No',
'CURDATE_SUPPORTED' = 'No',
'CURTIME_SUPPORTED' = 'No',
'NOW_SUPPORTED' = 'No',
'CALENDAR_EXTRACT_DAY_SUPPORTED' = 'No',
'CALENDAR_EXTRACT_DAY_OF_QUARTER_SUPPORTED' = 'No',
'CALENDAR_EXTRACT_DAY_OF_YEAR_SUPPORTED' = 'No',
'CALENDAR_EXTRACT_HOUR_SUPPORTED' = 'No',
'CALENDAR_EXTRACT_MINUTE_SUPPORTED' = 'No',
'CALENDAR_EXTRACT_MONTH_SUPPORTED' = 'No',
'CALENDAR_EXTRACT_MONTH_OF_QUARTER_SUPPORTED' = 'No',
'CALENDAR_EXTRACT_QUARTER_OF_YEAR_SUPPORTED' = 'No',
'CALENDAR_EXTRACT_SECOND_SUPPORTED' = 'No',
'CALENDAR_EXTRACT_WEEK_OF_QUARTER_SUPPORTED' = 'No',
'CALENDAR_EXTRACT_WEEK_OF_YEAR_SUPPORTED' = 'No',
'CALENDAR_EXTRACT_YEAR_SUPPORTED' = 'No',
'CALENDAR_EXTRACT_WEEK_OF_MONTH_SUPPORTED' = 'No',
'CALENDAR_EXTRACT_SHORT_NAME_OF_MONTH_SUPPORTED' = 'No',
'CALENDAR_EXTRACT_DAY_OF_WEEK_SUPPORTED' = 'No',
'CALENDAR_EXTRACT_SHORT_NAME_OF_DAY_SUPPORTED' = 'No',
'FISCAL_EXTRACT_DAY_SUPPORTED' = 'No',
'FISCAL_EXTRACT_DAY_OF_QUARTER_SUPPORTED' = 'No',
'FISCAL_EXTRACT_DAY_OF_YEAR_SUPPORTED' = 'No',
'FISCAL_EXTRACT_HOUR_SUPPORTED' = 'No',
'FISCAL_EXTRACT_MINUTE_SUPPORTED' = 'No',
'FISCAL_EXTRACT_MONTH_SUPPORTED' = 'No',
'FISCAL_EXTRACT_MONTH_OF_QUARTER_SUPPORTED' = 'No',
'FISCAL_EXTRACT_QUARTER_OF_YEAR_SUPPORTED' = 'No',
'FISCAL_EXTRACT_SECOND_SUPPORTED' = 'No',
'FISCAL_EXTRACT_WEEK_OF_QUARTER_SUPPORTED' = 'No',
'FISCAL_EXTRACT_WEEK_OF_YEAR_SUPPORTED' = 'No',
'FISCAL_EXTRACT_YEAR_SUPPORTED' = 'No',
'FISCAL_EXTRACT_WEEK_OF_MONTH_SUPPORTED' = 'No',
'FISCAL_EXTRACT_SHORT_NAME_OF_MONTH_SUPPORTED' = 'No',
'FISCAL_EXTRACT_DAY_OF_WEEK_SUPPORTED' = 'No',
'FISCAL_EXTRACT_SHORT_NAME_OF_DAY_SUPPORTED' = 'No',
'TIMESTAMP_ADD_SUPPORTED' = 'No',
'TIMESTAMP_DIFF_SUPPORTED' = 'No',
'CHAR_LENGTH_SUPPORTED' = 'No',
'BIT_LENGTH_SUPPORTED' = 'No',
'OCTET_LENGTH_SUPPORTED' = 'No',
'POSITION_SUPPORTED' = 'No',
'LOCATE_SUPPORTED' = 'No',
'ASCII_SUPPORTED' = 'No',
'LENGTH_SUPPORTED' = 'No',
'EXP_SUPPORTED' = 'No',
'POWER_SUPPORTED' = 'No',
'SQRT_SUPPORTED' = 'No',
'CEILING_SUPPORTED' = 'No',
'FLOOR_SUPPORTED' = 'No',
'ROUND_SUPPORTED' = 'No',
'TRUNCATE_SUPPORTED' = 'No',
'SIGN_SUPPORTED' = 'No',
'ABS_SUPPORTED' = 'No',
'MOD_SUPPORTED' = 'No',
'MODF_SUPPORTED' = 'No',
'RAND_SUPPORTED' = 'No',
'LOG_SUPPORTED' = 'No',
'LOG10_SUPPORTED' = 'No',
'PI_SUPPORTED' = 'No',
'DEGREES_SUPPORTED' = 'No',
'RADIANS_SUPPORTED' = 'No',
'SIN_SUPPORTED' = 'No',
'COS_SUPPORTED' = 'No',
'TAN_SUPPORTED' = 'No',
'COT_SUPPORTED' = 'No',
'ASIN_SUPPORTED' = 'No',
'ACOS_SUPPORTED' = 'No',
'ATAN_SUPPORTED' = 'No',
'ATAN2_SUPPORTED' = 'No',
'SINH_SUPPORTED' = 'No',
'COSH_SUPPORTED' = 'No',
'TANH_SUPPORTED' = 'No',
'TRIM_SUPPORTED' = 'No',
'LTRIM_SUPPORTED' = 'No',
'RTRIM_SUPPORTED' = 'No',
'UPPER_SUPPORTED' = 'No',
'LOWER_SUPPORTED' = 'No',
'CONCAT_SUPPORTED' = 'No',
'SUBSTRING_SUPPORTED' = 'No',
'REPLACE_SUPPORTED' = 'No',
'INSERT_SUPPORTED' = 'No',
'LEFT_SUPPORTED' = 'No',
'RIGHT_SUPPORTED' = 'No',
'SPACE_SUPPORTED' = 'No',
'REPEAT_SUPPORTED' = 'No',
'CHAR_SUPPORTED' = 'No',
'CONCAT_NULL_RETURNS_NULL' = 'No',
'DATABASE_SUPPORTED' = 'No',
'IFNULL_SUPPORTED' = 'No',
'USER_SUPPORTED' = 'No',
'CONVERT_SUPPORTED' = 'No',
'NULL_SUPPORTED' = 'No',
'BETWEEN_SUPPORTED' = 'No',
'LIKE_SUPPORTED' = 'No',
'LIKE_ESCAPE_CLAUSE_SUPPORTED' = 'No',
'IN_SUPPORTED' = 'No',
'MULTIPLE_STATEMENTS_PER_CONNECTION_SUPPORTED' = 'No',
'CAST_SUPPORTED' = 'No',
'ODBC_API_CONFORMANCE_NONE_SUPPORTED' = 'No',
'ODBC_API_CONFORMANCE_LEVEL1_SUPPORTED' = 'No',
'ODBC_API_CONFORMANCE_LEVEL2 _SUPPORTED' = 'No',
'ODBC_SQL_CONFORMANCE_MINIMUM_SUPPORTED' = 'No',
'ODBC_SQL_CONFORMANCE_CORE_SUPPORTED' = 'No',
'SQL_ODBC_CONFORMANCE_EXTENDED_SUPPORTED' = 'No',
'DERIVED_TABLES_SUPPORTED' = 'No',
'CORRELATION_NAME_SUPPORTED' = 'No',
'PREDICATE_SCALAR_SUBQUERY_SUPPORTED' = 'No',
'VALUE_SUBQUERY_SUPPORTED' = 'No',
'CORRELATED_SUBQUERY_SUPPORTED' = 'No',
'COMPARISON_SUBQUERY_SUPPORTED' = 'No',
'EXISTS_SUBQUERY_SUPPORTED' = 'No',
'IN_SUBQUERY_SUPPORTED' = 'No',
'QUANTIFIED_SUBQUERY_SUPPORTED' = 'No',
'PERF_PREFER_IN_LISTS' = 'No',
'SQL89_COLUMN_ALIAS_CONFORMANCE_SUPPORTED' = 'No',
'ADD_SUPPORTED' = 'No',
'SUBTRACT_SUPPORTED' = 'No',
'MULTIPLY_SUPPORTED' = 'No',
'DIVIDE_SUPPORTED' = 'No',
'UNARY_MINUS_SUPPORTED' = 'No',
'PARAMETER_SUPPORTED' = 'No',
'STRING_LITERAL_SUPPORTED' = 'No',
'INTEGER_LITERAL_SUPPORTED' = 'No',
'FLOAT_LITERAL_SUPPORTED' = 'No',
'EQUALITY_SUPPORTED' = 'No',
'LESS_THAN_SUPPORTED' = 'No',
'GREATER_THAN_SUPPORTED' = 'No',
'LESS_EQUAL_THAN_SUPPORTED' = 'No',
'GREATER_EQUAL_THAN_SUPPORTED' = 'No',
'NOT_EQUAL_SUPPORTED' = 'No',
'AND_SUPPORTED' = 'No',
'OR_SUPPORTED' = 'No',
'NOT_SUPPORTED' = 'No',
'NTILE_SUPPORTED' = 'No',
'MEDIAN_SUPPORTED' = 'No',
'STDDEV_SAMP_SUPPORTED' = 'No',
'STDDEV_SAMP_DISTINCT_SUPPORTED' = 'No',
'STDDEV_POP_SUPPORTED' = 'No',
'STDDEV_POP_DISTINCT_SUPPORTED' = 'No',
'CALENDAR_EXTRACT_LONG_NAME_OF_MONTH_SUPPORTED' = 'No',
'CALENDAR_EXTRACT_LONG_NAME_OF_DAY_SUPPORTED' = 'No',
'FISCAL_EXTRACT_LONG_NAME_OF_MONTH_SUPPORTED' = 'No',
'FISCAL_EXTRACT_LONG_NAME_OF_DAY_SUPPORTED' = 'No',
'EXCEPT_SUPPORTED' = 'No',
'EXCEPT_ALL_SUPPORTED' = 'No',
'INTERSECT_SUPPORTED' = 'No',
'INTERSECT_ALL_SUPPORTED' = 'No',
'RUNNING_SUM_SUPPORTED' = 'No',
'RUNNING_COUNT_SUPPORTED' = 'No',
'RUNNING_MAX_SUPPORTED' = 'No',
'RUNNING_MIN_SUPPORTED' = 'No',
'MOVING_SUM_SUPPORTED' = 'No',
'NULLIF_SUPPORTED' = 'No',
'CREATE_AS_SELECT_SUPPORTED' = 'No',
'INSERT_SELECT_SUPPORTED' = 'No',
'SUBTOTALLING_SUPPORTED' = 'No',
'ROWNUM_SUPPORTED' = 'No',
'CREATE_VIEW_SUPPORTED' = 'No',
'WITH_CLAUSE_SUPPORTED' = 'No',
'PERF_PREFER_MINIMAL_WITH_USAGE' = 'No',
'PERF_PREFER_INTERNAL_STITCH_JOIN' = 'No',
'MAX_BINARY_LITERAL_LEN' = '0',
'MAX_CHAR_LITERAL_LEN' = '0',
'MAX_COLUMN_NAME_LEN' = '0',
'MAX_COLUMNS_IN_GROUP_BY' = '0',
'MAX_COLUMNS_IN_ORDER_BY' = '0',
'MAX_COLUMNS_IN_SELECT' = '0',
'MAX_STATEMENT_LEN' = '0',
'MAX_TABLES_IN_SELECT' = '1',
'CONVERT_BIG_INT_BITMASK' = '0X0',
'CONVERT_BINARY_BITMASK' = '0X0',
'CONVERT_BIT_BITMASK' = '0X0',
'CONVERT_CHAR_BITMASK' = '0X0',
'CONVERT_DATE_BITMASK' = '0X0',
'CONVERT_DECIMAL_BITMASK' = '0X0',
'CONVERT_DOUBLE_BITMASK' = '0X0',
'CONVERT_FLOAT_BITMASK' = '0X0',
'CONVERT_INTEGER_BITMASK' = '0X0',
'CONVERT_LONG_VAR_BINARY_BITMASK' = '0X0',
'CONVERT_LONG_VAR_CHAR_BITMASK' = '0X0',
'CONVERT_NUMERIC_BITMASK' = '0X0',
'CONVERT_REAL_BITMASK' = '0X0',
'CONVERT_SMALL_INT_BITMASK' = '0X0',
'CONVERT_TIME_BITMASK' = '0X0',
'CONVERT_TIMESTAMP_BITMASK' = '0X0',
'CONVERT_TINY_INT_BITMASK' = '0X0',
'CONVERT_VAR_BINARY_BITMASK' = '0X0',
'CONVERT_VAR_CHAR_BITMASK' = '0X0',
'FRACTIONAL_SECOND_PRECISION' = '0X0',
'MAX_ENTRIES_PER_IN_LIST' = '0X0',
'MAX_PARAMETERS_PER_DRIVE_JOIN' = '0X0',
'MAX_QUERIES_PER_DRIVE_JOIN' = '0X0',
'MAX_PARAMETERS_PER_BULK_OPERATION' = '0X0',
'MAX_NESTED_LEVEL' = '0X0',
'DATA_SOURCE_NAME' = '',
'DATABASE_NAME' = '',
'DBMS_NAME' = '',
'DBMS_VER' = '',
'DRIVER_NAME' = '',
'DRIVER_ODBC_VER' = '',
'USER_NAME' = '',
'SEARCH_PATTERN_ESCAPE' = '',
'IDENTIFIER_QUOTE_CHAR' = '"',
'DATE_FORMAT' = 'yyyy/mm/dd',
'TIME_FORMAT' = 'hh:mi:ss mss',
'DATETIME_FORMAT' = 'yyyy/mm/dd hh:mi:ss mss',
'SORT_ORDER_LOCALE' = 'english-usa',
'COMMENT_START' = '',
'COMMENT_END' = '' )
CONNECTION POOLS (
"Paint"."XML_Paint" )
PRIVILEGES ( READ);
DECLARE CONNECTION POOL "Paint"."XML_Paint" AS "XML_Paint" UPGRADE ID 163
DATA SOURCE {VALUEOF(BI_EE_HOME)/server/Sample/paint}
TIME OUT 900
MAX CONNECTIONS 8
TYPE 'Default'
USER ''
PASSWORD 'D7EDED84BC624A917F5B462A4DCA05CDCE256EEEEEDC97D5AC4D07C3A079829F'
SHARED LOGIN
CLOSE AFTER QUERY
CONNECTIONS TO SAME URI 1
OUTPUT TYPE XML
PARAMETERS NOT SUPPORTED
BULK INSERT BUFFER SIZE 0 TRANSACTION BOUNDARY 0
TEMP TABLE PREFIX {} OWNER {}
PRIVILEGES ( READ);
DECLARE TABLE "Paint"..."Fact" AS "Fact" UPGRADE ID 554 HAVING
(
"Paint"..."Fact"."MktKey" AS "MktKey" UPGRADE ID 556 EXTERNAL "//Table/FACT/MktKey" TYPE "INT" PRECISION 0 SCALE 0 NULLABLE COUNT 59.000000 LAST UPDATED '2000-08-30 02:44:36'
PRIVILEGES ( READ),
"Paint"..."Fact"."ProdKey" AS "ProdKey" UPGRADE ID 558 EXTERNAL "//Table/FACT/ProdKey" TYPE "INT" PRECISION 0 SCALE 0 NULLABLE LAST UPDATED '2001-01-01 00:00:00'
PRIVILEGES ( READ),
"Paint"..."Fact"."PerKey" AS "PerKey" UPGRADE ID 560 EXTERNAL "//Table/FACT/PerKey" TYPE "INT" PRECISION 0 SCALE 0 NULLABLE LAST UPDATED '2001-01-01 00:00:00'
PRIVILEGES ( READ),
"Paint"..."Fact"."Units" AS "Units" UPGRADE ID 562 EXTERNAL "//Table/FACT/Units" TYPE "INT" PRECISION 0 SCALE 0 NULLABLE COUNT 30165.000000 LAST UPDATED '2000-05-24 11:55:25'
PRIVILEGES ( READ),
"Paint"..."Fact"."Dollars" AS "Dollars" UPGRADE ID 564 EXTERNAL "//Table/FACT/Dollars" TYPE "DOUBLE" PRECISION 0 SCALE 0 NULLABLE COUNT 53875.000000 LAST UPDATED '2000-05-24 11:55:19'
PRIVILEGES ( READ)
) DIAGRAM POSITION (855, 213) ROW COUNT 256437.000000 LAST UPDATED '2000-05-25 00:18:27' URI 'VALUEOF(BI_EE_HOME)/server/Sample/paint/Fact.xml'
PRIVILEGES ( READ);
DECLARE TABLE KEY "Paint"..."Fact"."FactKey" AS "FactKey" UPGRADE ID 566 HAVING
(
"Paint"..."Fact"."MktKey",
"Paint"..."Fact"."ProdKey",
"Paint"..."Fact"."PerKey" )
PRIVILEGES ( READ);
DECLARE TABLE "Paint"..."Market" AS "Market" UPGRADE ID 574 HAVING
(
"Paint"..."Market"."MktKey" AS "MktKey" UPGRADE ID 576 EXTERNAL "//Table/MARKET/MktKey" TYPE "INT" PRECISION 0 SCALE 0 NULLABLE COUNT 74.000000 LAST UPDATED '2000-06-21 01:30:25'
PRIVILEGES ( READ),
"Paint"..."Market"."MktDesc" AS "MktDesc" UPGRADE ID 578 EXTERNAL "//Table/MARKET/MktDesc" TYPE "VARCHAR" PRECISION 50 SCALE 0 NULLABLE COUNT 74.000000 LAST UPDATED '2000-06-21 01:30:26'
PRIVILEGES ( READ),
"Paint"..."Market"."Seq" AS "Seq" UPGRADE ID 580 EXTERNAL "//Table/MARKET/Seq" TYPE "INT" PRECISION 0 SCALE 0 NULLABLE COUNT 74.000000 LAST UPDATED '2000-06-21 01:30:26'
PRIVILEGES ( READ),
"Paint"..."Market"."LevelX" AS "LevelX" UPGRADE ID 582 EXTERNAL "//Table/MARKET/LevelX" TYPE "VARCHAR" PRECISION 20 SCALE 0 NULLABLE COUNT 4.000000 LAST UPDATED '2000-06-21 01:30:26'
PRIVILEGES ( READ),
"Paint"..."Market"."MkShortId" AS "MkShortId" UPGRADE ID 584 EXTERNAL "//Table/MARKET/MkShortId" TYPE "VARCHAR" PRECISION 20 SCALE 0 NULLABLE COUNT 74.000000 LAST UPDATED '2000-06-21 01:30:26'
PRIVILEGES ( READ),
"Paint"..."Market"."District" AS "District" UPGRADE ID 586 EXTERNAL "//Table/MARKET/District" TYPE "VARCHAR" PRECISION 40 SCALE 0 NULLABLE COUNT 20.000000 LAST UPDATED '2000-06-21 01:30:27'
PRIVILEGES ( READ),
"Paint"..."Market"."region" AS "region" UPGRADE ID 588 EXTERNAL "//Table/MARKET/region" TYPE "VARCHAR" PRECISION 20 SCALE 0 NULLABLE COUNT 5.000000 LAST UPDATED '2000-06-21 01:30:27'
PRIVILEGES ( READ)
) DIAGRAM POSITION (557, 46) ROW COUNT 74.000000 LAST UPDATED '2000-06-21 01:30:14' URI 'VALUEOF(BI_EE_HOME)/server/Sample/paint/Market.xml'
PRIVILEGES ( READ);
DECLARE TABLE KEY "Paint"..."Market"."Market_Key" AS "Market_Key" UPGRADE ID 590 HAVING
(
"Paint"..."Market"."MktKey" )
PRIVILEGES ( READ);
DECLARE TABLE "Paint"..."Month Ago fact" AS "Month Ago fact" UPGRADE ID 592 HAVING
(
"Paint"..."Month Ago fact"."MktKey" AS "MktKey" UPGRADE ID 594 EXTERNAL "//Table/FACT/MktKey" TYPE "INT" PRECISION 0 SCALE 0 NULLABLE COUNT 59.000000 LAST UPDATED '2000-08-30 02:44:36' SOURCE "Paint"..."Fact"."MktKey"
PRIVILEGES ( READ),
"Paint"..."Month Ago fact"."ProdKey" AS "ProdKey" UPGRADE ID 596 EXTERNAL "//Table/FACT/ProdKey" TYPE "INT" PRECISION 0 SCALE 0 NULLABLE LAST UPDATED '2001-01-01 00:00:00' SOURCE "Paint"..."Fact"."ProdKey"
PRIVILEGES ( READ),
"Paint"..."Month Ago fact"."PerKey" AS "PerKey" UPGRADE ID 598 EXTERNAL "//Table/FACT/PerKey" TYPE "INT" PRECISION 0 SCALE 0 NULLABLE LAST UPDATED '2001-01-01 00:00:00' SOURCE "Paint"..."Fact"."PerKey"
PRIVILEGES ( READ),
"Paint"..."Month Ago fact"."Units" AS "Units" UPGRADE ID 600 EXTERNAL "//Table/FACT/Units" TYPE "INT" PRECISION 0 SCALE 0 NULLABLE COUNT 30165.000000 LAST UPDATED '2000-05-24 11:55:25' SOURCE "Paint"..."Fact"."Units"
PRIVILEGES ( READ),
"Paint"..."Month Ago fact"."Dollars" AS "Dollars" UPGRADE ID 602 EXTERNAL "//Table/FACT/Dollars" TYPE "DOUBLE" PRECISION 0 SCALE 0 NULLABLE COUNT 53875.000000 LAST UPDATED '2000-05-24 11:55:19' SOURCE "Paint"..."Fact"."Dollars"
PRIVILEGES ( READ)
) POLL FREQUENCY 0 DIAGRAM POSITION (942, 121) ROW COUNT 256437.000000 LAST UPDATED '2000-05-25 00:18:27' SOURCE "Paint"..""."Fact"
DESCRIPTION {Generated by Time Series Wizard}
PRIVILEGES ( READ);
DECLARE TABLE KEY "Paint"..."Month Ago fact"."FactKey" AS "FactKey" UPGRADE ID 604 HAVING
(
"Paint"..."Month Ago fact"."MktKey",
"Paint"..."Month Ago fact"."ProdKey",
"Paint"..."Month Ago fact"."PerKey" )
DESCRIPTION {Generated by Time Series Wizard}
PRIVILEGES ( READ);
DECLARE TABLE "Paint"..."Month Year Ago fact" AS "Month Year Ago fact" UPGRADE ID 610 HAVING
(
"Paint"..."Month Year Ago fact"."MktKey" AS "MktKey" UPGRADE ID 612 EXTERNAL "//Table/FACT/MktKey" TYPE "INT" PRECISION 0 SCALE 0 NULLABLE COUNT 59.000000 LAST UPDATED '2000-08-30 02:44:36' SOURCE "Paint"..."Fact"."MktKey"
PRIVILEGES ( READ),
"Paint"..."Month Year Ago fact"."ProdKey" AS "ProdKey" UPGRADE ID 614 EXTERNAL "//Table/FACT/ProdKey" TYPE "INT" PRECISION 0 SCALE 0 NULLABLE LAST UPDATED '2001-01-01 00:00:00' SOURCE "Paint"..."Fact"."ProdKey"
PRIVILEGES ( READ),
"Paint"..."Month Year Ago fact"."PerKey" AS "PerKey" UPGRADE ID 616 EXTERNAL "//Table/FACT/PerKey" TYPE "INT" PRECISION 0 SCALE 0 NULLABLE LAST UPDATED '2001-01-01 00:00:00' SOURCE "Paint"..."Fact"."PerKey"
PRIVILEGES ( READ),
"Paint"..."Month Year Ago fact"."Units" AS "Units" UPGRADE ID 618 EXTERNAL "//Table/FACT/Units" TYPE "INT" PRECISION 0 SCALE 0 NULLABLE COUNT 30165.000000 LAST UPDATED '2000-05-24 11:55:25' SOURCE "Paint"..."Fact"."Units"
PRIVILEGES ( READ),
"Paint"..."Month Year Ago fact"."Dollars" AS "Dollars" UPGRADE ID 620 EXTERNAL "//Table/FACT/Dollars" TYPE "DOUBLE" PRECISION 0 SCALE 0 NULLABLE COUNT 53875.000000 LAST UPDATED '2000-05-24 11:55:19' SOURCE "Paint"..."Fact"."Dollars"
PRIVILEGES ( READ)
) POLL FREQUENCY 0 DIAGRAM POSITION (1033, 305) ROW COUNT 256437.000000 LAST UPDATED '2000-05-25 00:18:27' SOURCE "Paint"..""."Fact"
DESCRIPTION {Generated by Time Series Wizard}
PRIVILEGES ( READ);
DECLARE TABLE KEY "Paint"..."Month Year Ago fact"."FactKey" AS "FactKey" UPGRADE ID 622 HAVING
(
"Paint"..."Month Year Ago fact"."MktKey",
"Paint"..."Month Year Ago fact"."ProdKey",
"Paint"..."Month Year Ago fact"."PerKey" )
DESCRIPTION {Generated by Time Series Wizard}
PRIVILEGES ( READ);
DECLARE TABLE "Paint"..."Period" AS "Period" UPGRADE ID 628 HAVING
(
"Paint"..."Period"."PerKey" AS "PerKey" UPGRADE ID 630 EXTERNAL "//Table/PERIOD/PerKey" TYPE "INT" PRECISION 0 SCALE 0 NULLABLE COUNT 130.000000 LAST UPDATED '2000-08-16 05:04:47'
PRIVILEGES ( READ),
"Paint"..."Period"."PerDesc" AS "PerDesc" UPGRADE ID 632 EXTERNAL "//Table/PERIOD/PerDesc" TYPE "VARCHAR" PRECISION 20 SCALE 0 NULLABLE LAST UPDATED '2001-01-01 00:00:00'
PRIVILEGES ( READ),
"Paint"..."Period"."Month" AS "Month" UPGRADE ID 634 EXTERNAL "//Table/PERIOD/Month" TYPE "DATE" PRECISION 0 SCALE 0 NULLABLE LAST UPDATED '2001-01-01 00:00:00'
PRIVILEGES ( READ),
"Paint"..."Period"."Year" AS "Year" UPGRADE ID 636 EXTERNAL "//Table/PERIOD/Year" TYPE "VARCHAR" PRECISION 255 SCALE 0 NULLABLE LAST UPDATED '2001-01-01 00:00:00'
PRIVILEGES ( READ),
"Paint"..."Period"."LevelX" AS "LevelX" UPGRADE ID 638 EXTERNAL "//Table/PERIOD/LevelX" TYPE "VARCHAR" PRECISION 10 SCALE 0 NULLABLE LAST UPDATED '2001-01-01 00:00:00'
PRIVILEGES ( READ),
"Paint"..."Period"."Period_N" AS "Period_N" UPGRADE ID 640 EXTERNAL "//Table/PERIOD/Period_N" TYPE "VARCHAR" PRECISION 10 SCALE 0 NULLABLE LAST UPDATED '2001-01-01 00:00:00'
PRIVILEGES ( READ),
"Paint"..."Period"."Seq" AS "Seq" UPGRADE ID 642 EXTERNAL "//Table/PERIOD/Seq" TYPE "INT" PRECISION 0 SCALE 0 NULLABLE LAST UPDATED '2001-01-01 00:00:00'
PRIVILEGES ( READ),
"Paint"..."Period"."ShortDesc" AS "ShortDesc" UPGRADE ID 644 EXTERNAL "//Table/PERIOD/ShortDesc" TYPE "VARCHAR" PRECISION 10 SCALE 0 NULLABLE LAST UPDATED '2001-01-01 00:00:00'
PRIVILEGES ( READ),
"Paint"..."Period"."Current Period" AS "Current Period" UPGRADE ID 646 EXTERNAL "//Table/PERIOD/CurrentPeriod" TYPE "VARCHAR" PRECISION 1 SCALE 0 NULLABLE LAST UPDATED '2001-01-01 00:00:00'
PRIVILEGES ( READ),
"Paint"..."Period"."Yago" AS "Yago" UPGRADE ID 648 EXTERNAL "//Table/PERIOD/Yago" TYPE "DOUBLE" PRECISION 0 SCALE 0 NULLABLE LAST UPDATED '2001-01-01 00:00:00'
PRIVILEGES ( READ),
"Paint"..."Period"."Mago" AS "Mago" UPGRADE ID 650 EXTERNAL "//Table/PERIOD/Mago" TYPE "DOUBLE" PRECISION 0 SCALE 0 NULLABLE LAST UPDATED '2001-01-01 00:00:00'
PRIVILEGES ( READ),
"Paint"..."Period"."WEago" AS "WEago" UPGRADE ID 652 EXTERNAL "//Table/PERIOD/WEago" TYPE "DOUBLE" PRECISION 0 SCALE 0 NULLABLE LAST UPDATED '2001-01-01 00:00:00'
PRIVILEGES ( READ)
) DIAGRAM POSITION (1125, 412) ROW COUNT 130.000000 LAST UPDATED '2000-08-17 12:59:49' URI 'VALUEOF(BI_EE_HOME)/server/Sample/paint/Period.xml'
PRIVILEGES ( READ);
DECLARE TABLE KEY "Paint"..."Period"."Period_Key" AS "Period_Key" UPGRADE ID 654 HAVING
(
"Paint"..."Period"."PerKey" )
PRIVILEGES ( READ);
DECLARE TABLE KEY "Paint"..."Period"."Period_Key#1" AS "Period_Key#1" UPGRADE ID 705 HAVING
(
"Paint"..."Period"."Mago" )
PRIVILEGES ( READ);
DECLARE TABLE KEY "Paint"..."Period"."Period_Key#2" AS "Period_Key#2" UPGRADE ID 711 HAVING
(
"Paint"..."Period"."Yago" )
PRIVILEGES ( READ);
DECLARE TABLE "Paint"..."Product" AS "Product" UPGRADE ID 656 HAVING
(
"Paint"..."Product"."ProdKey" AS "ProdKey" UPGRADE ID 658 EXTERNAL "//Table/PRODUCT/ProdKey" TYPE "INT" PRECISION 0 SCALE 0 NULLABLE COUNT 46.000000 LAST UPDATED '2000-05-24 11:54:05'
PRIVILEGES ( READ),
"Paint"..."Product"."ProdDesc" AS "ProdDesc" UPGRADE ID 660 EXTERNAL "//Table/PRODUCT/ProdDesc" TYPE "VARCHAR" PRECISION 50 SCALE 0 NULLABLE LAST UPDATED '2001-01-01 00:00:00'
PRIVILEGES ( READ),
"Paint"..."Product"."LevelX" AS "LevelX" UPGRADE ID 662 EXTERNAL "//Table/PRODUCT/LevelX" TYPE "VARCHAR" PRECISION 20 SCALE 0 NULLABLE LAST UPDATED '2001-01-01 00:00:00'
PRIVILEGES ( READ),
"Paint"..."Product"."Color" AS "Color" UPGRADE ID 664 EXTERNAL "//Table/PRODUCT/Color" TYPE "VARCHAR" PRECISION 50 SCALE 0 NULLABLE LAST UPDATED '2001-01-01 00:00:00'
PRIVILEGES ( READ),
"Paint"..."Product"."Finish" AS "Finish" UPGRADE ID 666 EXTERNAL "//Table/PRODUCT/Finish" TYPE "VARCHAR" PRECISION 20 SCALE 0 NULLABLE LAST UPDATED '2001-01-01 00:00:00'
PRIVILEGES ( READ),
"Paint"..."Product"."Type" AS "Type" UPGRADE ID 668 EXTERNAL "//Table/PRODUCT/Type" TYPE "VARCHAR" PRECISION 20 SCALE 0 NULLABLE LAST UPDATED '2001-01-01 00:00:00'
PRIVILEGES ( READ),
"Paint"..."Product"."SizeX" AS "SizeX" UPGRADE ID 670 EXTERNAL "//Table/PRODUCT/SizeX" TYPE "VARCHAR" PRECISION 20 SCALE 0 NULLABLE LAST UPDATED '2001-01-01 00:00:00'
PRIVILEGES ( READ),
"Paint"..."Product"."Seq" AS "Seq" UPGRADE ID 672 EXTERNAL "//Table/PRODUCT/Seq" TYPE "VARCHAR" PRECISION 20 SCALE 0 NULLABLE LAST UPDATED '2001-01-01 00:00:00'
PRIVILEGES ( READ),
"Paint"..."Product"."Brand" AS "Brand" UPGRADE ID 674 EXTERNAL "//Table/PRODUCT/Brand" TYPE "VARCHAR" PRECISION 25 SCALE 0 NULLABLE LAST UPDATED '2001-01-01 00:00:00'
PRIVILEGES ( READ)
) DIAGRAM POSITION (191, 436) ROW COUNT 91.000000 LAST UPDATED '2000-08-14 09:12:14' URI 'VALUEOF(BI_EE_HOME)/server/Sample/paint/Product.xml'
PRIVILEGES ( READ);
DECLARE TABLE KEY "Paint"..."Product"."Product_Key" AS "Product_Key" UPGRADE ID 676 HAVING
(
"Paint"..."Product"."ProdKey" )
PRIVILEGES ( READ);
DECLARE TABLE "Paint"..."Year Ago fact" AS "Year Ago fact" UPGRADE ID 678 HAVING
(
"Paint"..."Year Ago fact"."MktKey" AS "MktKey" UPGRADE ID 680 EXTERNAL "//Table/FACT/MktKey" TYPE "INT" PRECISION 0 SCALE 0 NULLABLE COUNT 59.000000 LAST UPDATED '2000-08-30 02:44:36' SOURCE "Paint"..."Fact"."MktKey"
PRIVILEGES ( READ),
"Paint"..."Year Ago fact"."ProdKey" AS "ProdKey" UPGRADE ID 682 EXTERNAL "//Table/FACT/ProdKey" TYPE "INT" PRECISION 0 SCALE 0 NULLABLE LAST UPDATED '2001-01-01 00:00:00' SOURCE "Paint"..."Fact"."ProdKey"
PRIVILEGES ( READ),
"Paint"..."Year Ago fact"."PerKey" AS "PerKey" UPGRADE ID 684 EXTERNAL "//Table/FACT/PerKey" TYPE "INT" PRECISION 0 SCALE 0 NULLABLE LAST UPDATED '2001-01-01 00:00:00' SOURCE "Paint"..."Fact"."PerKey"
PRIVILEGES ( READ),
"Paint"..."Year Ago fact"."Units" AS "Units" UPGRADE ID 686 EXTERNAL "//Table/FACT/Units" TYPE "INT" PRECISION 0 SCALE 0 NULLABLE COUNT 30165.000000 LAST UPDATED '2000-05-24 11:55:25' SOURCE "Paint"..."Fact"."Units"
PRIVILEGES ( READ),
"Paint"..."Year Ago fact"."Dollars" AS "Dollars" UPGRADE ID 688 EXTERNAL "//Table/FACT/Dollars" TYPE "DOUBLE" PRECISION 0 SCALE 0 NULLABLE COUNT 53875.000000 LAST UPDATED '2000-05-24 11:55:19' SOURCE "Paint"..."Fact"."Dollars"
PRIVILEGES ( READ)
) POLL FREQUENCY 0 DIAGRAM POSITION (480, 301) ROW COUNT 256437.000000 LAST UPDATED '2000-05-25 00:18:27' SOURCE "Paint"..""."Fact"
DESCRIPTION {Generated by Time Series Wizard}
PRIVILEGES ( READ);
DECLARE TABLE KEY "Paint"..."Year Ago fact"."FactKey" AS "FactKey" UPGRADE ID 690 HAVING
(
"Paint"..."Year Ago fact"."MktKey",
"Paint"..."Year Ago fact"."ProdKey",
"Paint"..."Year Ago fact"."PerKey" )
DESCRIPTION {Generated by Time Series Wizard}
PRIVILEGES ( READ);