gv1@gv1-laptop:~$ cd /mondrian gv1@gv1-laptop:/mondrian$ ld ld: no input files gv1@gv1-laptop:/mondrian$ ls demo lib mondrian-3.2.0.13661-src.zip VERSION.txt doc LICENSE.html README.txt gv1@gv1-laptop:/mondrian$ cd lib/ gv1@gv1-laptop:/mondrian/lib$ ls aggregates.dtd eigenbase-xom.jar mondrian.war datasourcesconfig.dtd mondrian.dtd olap4j-jdk14.jar eigenbase-properties.jar mondrian.jar postgresql-8.4-701.jdbc4.jar eigenbase-resgen.jar mondrian-jdk14.jar retroweaver-rt.jar gv1@gv1-laptop:/mondrian/lib$ cd .. gv1@gv1-laptop:/mondrian$ sudo aptitude search log4 [sudo] password for gv1: p liblog-log4perl-perl - A Perl port of the widely popular log4j lo p liblog4ada-dbg - An Ada library for flexible logging (debug p liblog4ada-doc - An Ada library for flexible logging (docum p liblog4ada0 - An Ada library for flexible logging (runti p liblog4ada1-dev - An Ada library for flexible logging (devel p liblog4c-dev - C library for flexible logging (developmen p liblog4c-doc - C library for flexible logging (documentat p liblog4c3 - C library for flexible logging (runtime) p liblog4cpp-doc - A C++ library for flexible logging (docume p liblog4cpp5 - C++ library for flexible logging (runtime) p liblog4cpp5-dev - C++ library for flexible logging (developm p liblog4cxx10 - A logging library for C++ p liblog4cxx10-dev - A logging library for C++ (development fil p liblog4cxx10-doc - Documentation for log4cxx i A liblog4j1.2-java - Logging library for java p liblog4j1.2-java-doc - Documentation for liblog4j1.2-java p liblog4j1.2-java-gcj - Logging library for java (native code) p liblog4net-cil-dev - highly configurable logging API for the CL p liblog4net1.2-cil - highly configurable logging API for the CL p liblog4r-ruby - A logging library for Ruby p liblog4r-ruby1.8 - A logging library for Ruby p libmoosex-log-log4perl-perl - logging role for Moose based on Log::Log4p p libtest-log4perl-perl - test module for checking Log::Log4perl cod gv1@gv1-laptop:/mondrian$ dpkg -L liblog4j1.2-java|grep jar /usr/share/java/log4j-1.2-1.2.15.jar /usr/share/java/log4j-1.2.jar /usr/share/maven-repo/log4j/log4j/1.2.15/log4j-1.2.15.jar /usr/share/maven-repo/log4j/log4j/1.2.x/log4j-1.2.x.jar gv1@gv1-laptop:/mondrian$ dpkg -L libcommons-logging-java|grep logging.jar /usr/share/java/commons-logging.jar gv1@gv1-laptop:/mondrian$ sudo ln -sf /usr/share/java/log4j-1.2.jar /mondrian/lib/log4j.jar gv1@gv1-laptop:/mondrian$ sudo ln -sf /usr/share/java/commons-logging.jar /mondrian/lib/commons-logging.jar gv1@gv1-laptop:/mondrian$ ls -al /mondrian/lib/ total 56340 drwxr-xr-x 2 gv1 gv1 4096 2010-09-21 16:17 . drwxr-xr-x 5 gv1 gv1 4096 2010-06-01 16:30 .. -rw-r--r-- 1 gv1 gv1 8042 2010-06-01 16:27 aggregates.dtd lrwxrwxrwx 1 root root 35 2010-09-21 16:17 commons-logging.jar -> /usr/share/java/commons-logging.jar -rw-r--r-- 1 gv1 gv1 1070 2010-06-01 16:27 datasourcesconfig.dtd -rw-r--r-- 1 root root 13655 2010-09-21 16:14 eigenbase-properties.jar -rw-r--r-- 1 root root 60559 2010-09-21 16:15 eigenbase-resgen.jar -rw-r--r-- 1 root root 95028 2010-09-21 16:15 eigenbase-xom.jar lrwxrwxrwx 1 root root 29 2010-09-21 16:17 log4j.jar -> /usr/share/java/log4j-1.2.jar -rw-r--r-- 1 gv1 gv1 14790 2010-06-01 16:27 mondrian.dtd -rw-r--r-- 1 gv1 gv1 2823019 2010-06-01 16:28 mondrian.jar -rw-r--r-- 1 gv1 gv1 2954486 2010-06-01 16:29 mondrian-jdk14.jar -rw-r--r-- 1 gv1 gv1 50528056 2010-06-01 16:28 mondrian.war -rw-r--r-- 1 gv1 gv1 469574 2010-06-01 16:30 olap4j-jdk14.jar -rw-r--r-- 1 root root 510170 2010-09-21 16:15 postgresql-8.4-701.jdbc4.jar -rw-r--r-- 1 gv1 gv1 181671 2009-01-14 19:19 retroweaver-rt.jar gv1@gv1-laptop:/mondrian$ sudo updatedb gv1@gv1-laptop:/mondrian$ java -cp "/mondrian/lib/mondrian.jar:/mondrian/lib/log4j.jar:/mondrian/lib/commons-logging.jar:/mondrian/lib/eigenbase-xom.jar:/mondrian/lib/eigenbase-resgen.jar:/mondrian/lib/eigenbase-properties.jar:/mondrian/lib/postgresql-8.4-701.jdbc4.jar" \ > mondrian.test.loader.MondrianFoodMartLoader \ > -verbose -tables -data -indexes \ > -jdbcDrivers=org.postgresql.Driver \ > -outputJdbcURL="jdbc:postgresql://localhost/foodmart" \ > -outputJdbcUser="postgres" \ > -outputJdbcPassword="postgres" \ > -inputFile=/mondrian/demo/FoodMartCreateData.sql^C gv1@gv1-laptop:/mondrian$ java -cp "/mondrian/lib/mondrian.jar:/mondrian/lib/log4j.jar:/mondrian/lib/commons-logging.jar:/mondrian/lib/eigenbase-xom.jar:/mondrian/lib/eigenbase-resgen.jar:/mondrian/lib/eigenbase-properties.jar:/mondrian/lib/postgresql-8.4-701.jdbc4.jar" \ > mondrian.test.loader.MondrianFoodMartLoader \ > -verbose -tables -data -indexes \ > -jdbcDrivers=org.postgresql.Driver \ > -outputJdbcURL="jdbc:postgresql://localhost/foodmart" \ > -outputJdbcUser="postgres" \ > -outputJdbcPassword="postgres" \ > -inputFile=/mondrian/demo/FoodMartCreateData.sql log4j:WARN No appenders could be found for logger (mondrian.olap.MondrianProperties). log4j:WARN Please initialize the log4j system properly. Parameters: -verbose -tables -data -indexes -jdbcDrivers=org.postgresql.Driver -outputJdbcURL=jdbc:postgresql://localhost/foodmart -outputJdbcUser=postgres -outputJdbcPassword=postgres -inputFile=/mondrian/demo/FoodMartCreateData.sql Output connection is PostgreSQL, version: 8.4.4 Mondrian Dialect is PostgreSQL, detected database product: POSTGRESQL DROP TABLE "sales_fact_1997" Drop of sales_fact_1997 failed. Ignored CREATE TABLE "sales_fact_1997"( "product_id" INTEGER NOT NULL, "time_id" INTEGER NOT NULL, "customer_id" INTEGER NOT NULL, "promotion_id" INTEGER NOT NULL, "store_id" INTEGER NOT NULL, "store_sales" DECIMAL(10,4) NOT NULL, "store_cost" DECIMAL(10,4) NOT NULL, "unit_sales" DECIMAL(10,4) NOT NULL) DROP TABLE "sales_fact_1998" Drop of sales_fact_1998 failed. Ignored CREATE TABLE "sales_fact_1998"( "product_id" INTEGER NOT NULL, "time_id" INTEGER NOT NULL, "customer_id" INTEGER NOT NULL, "promotion_id" INTEGER NOT NULL, "store_id" INTEGER NOT NULL, "store_sales" DECIMAL(10,4) NOT NULL, "store_cost" DECIMAL(10,4) NOT NULL, "unit_sales" DECIMAL(10,4) NOT NULL) DROP TABLE "sales_fact_dec_1998" Drop of sales_fact_dec_1998 failed. Ignored CREATE TABLE "sales_fact_dec_1998"( "product_id" INTEGER NOT NULL, "time_id" INTEGER NOT NULL, "customer_id" INTEGER NOT NULL, "promotion_id" INTEGER NOT NULL, "store_id" INTEGER NOT NULL, "store_sales" DECIMAL(10,4) NOT NULL, "store_cost" DECIMAL(10,4) NOT NULL, "unit_sales" DECIMAL(10,4) NOT NULL) DROP TABLE "inventory_fact_1997" Drop of inventory_fact_1997 failed. Ignored CREATE TABLE "inventory_fact_1997"( "product_id" INTEGER NOT NULL, "time_id" INTEGER, "warehouse_id" INTEGER, "store_id" INTEGER, "units_ordered" INTEGER, "units_shipped" INTEGER, "warehouse_sales" DECIMAL(10,4), "warehouse_cost" DECIMAL(10,4), "supply_time" SMALLINT, "store_invoice" DECIMAL(10,4)) DROP TABLE "inventory_fact_1998" Drop of inventory_fact_1998 failed. Ignored CREATE TABLE "inventory_fact_1998"( "product_id" INTEGER NOT NULL, "time_id" INTEGER, "warehouse_id" INTEGER, "store_id" INTEGER, "units_ordered" INTEGER, "units_shipped" INTEGER, "warehouse_sales" DECIMAL(10,4), "warehouse_cost" DECIMAL(10,4), "supply_time" SMALLINT, "store_invoice" DECIMAL(10,4)) DROP TABLE "agg_pl_01_sales_fact_1997" Drop of agg_pl_01_sales_fact_1997 failed. Ignored CREATE TABLE "agg_pl_01_sales_fact_1997"( "product_id" INTEGER NOT NULL, "time_id" INTEGER NOT NULL, "customer_id" INTEGER NOT NULL, "store_sales_sum" DECIMAL(10,4) NOT NULL, "store_cost_sum" DECIMAL(10,4) NOT NULL, "unit_sales_sum" DECIMAL(10,4) NOT NULL, "fact_count" INTEGER NOT NULL) DROP TABLE "agg_ll_01_sales_fact_1997" Drop of agg_ll_01_sales_fact_1997 failed. Ignored CREATE TABLE "agg_ll_01_sales_fact_1997"( "product_id" INTEGER NOT NULL, "time_id" INTEGER NOT NULL, "customer_id" INTEGER NOT NULL, "store_sales" DECIMAL(10,4) NOT NULL, "store_cost" DECIMAL(10,4) NOT NULL, "unit_sales" DECIMAL(10,4) NOT NULL, "fact_count" INTEGER NOT NULL) DROP TABLE "agg_l_03_sales_fact_1997" Drop of agg_l_03_sales_fact_1997 failed. Ignored CREATE TABLE "agg_l_03_sales_fact_1997"( "time_id" INTEGER NOT NULL, "customer_id" INTEGER NOT NULL, "store_sales" DECIMAL(10,4) NOT NULL, "store_cost" DECIMAL(10,4) NOT NULL, "unit_sales" DECIMAL(10,4) NOT NULL, "fact_count" INTEGER NOT NULL) DROP TABLE "agg_l_04_sales_fact_1997" Drop of agg_l_04_sales_fact_1997 failed. Ignored CREATE TABLE "agg_l_04_sales_fact_1997"( "time_id" INTEGER NOT NULL, "store_sales" DECIMAL(10,4) NOT NULL, "store_cost" DECIMAL(10,4) NOT NULL, "unit_sales" DECIMAL(10,4) NOT NULL, "customer_count" INTEGER NOT NULL, "fact_count" INTEGER NOT NULL) DROP TABLE "agg_l_05_sales_fact_1997" Drop of agg_l_05_sales_fact_1997 failed. Ignored CREATE TABLE "agg_l_05_sales_fact_1997"( "product_id" INTEGER NOT NULL, "customer_id" INTEGER NOT NULL, "promotion_id" INTEGER NOT NULL, "store_id" INTEGER NOT NULL, "store_sales" DECIMAL(10,4) NOT NULL, "store_cost" DECIMAL(10,4) NOT NULL, "unit_sales" DECIMAL(10,4) NOT NULL, "fact_count" INTEGER NOT NULL) DROP TABLE "agg_c_10_sales_fact_1997" Drop of agg_c_10_sales_fact_1997 failed. Ignored CREATE TABLE "agg_c_10_sales_fact_1997"( "month_of_year" SMALLINT NOT NULL, "quarter" VARCHAR(30) NOT NULL, "the_year" SMALLINT NOT NULL, "store_sales" DECIMAL(10,4) NOT NULL, "store_cost" DECIMAL(10,4) NOT NULL, "unit_sales" DECIMAL(10,4) NOT NULL, "customer_count" INTEGER NOT NULL, "fact_count" INTEGER NOT NULL) DROP TABLE "agg_c_14_sales_fact_1997" Drop of agg_c_14_sales_fact_1997 failed. Ignored CREATE TABLE "agg_c_14_sales_fact_1997"( "product_id" INTEGER NOT NULL, "customer_id" INTEGER NOT NULL, "store_id" INTEGER NOT NULL, "promotion_id" INTEGER NOT NULL, "month_of_year" SMALLINT NOT NULL, "quarter" VARCHAR(30) NOT NULL, "the_year" SMALLINT NOT NULL, "store_sales" DECIMAL(10,4) NOT NULL, "store_cost" DECIMAL(10,4) NOT NULL, "unit_sales" DECIMAL(10,4) NOT NULL, "fact_count" INTEGER NOT NULL) DROP TABLE "agg_lc_100_sales_fact_1997" Drop of agg_lc_100_sales_fact_1997 failed. Ignored CREATE TABLE "agg_lc_100_sales_fact_1997"( "product_id" INTEGER NOT NULL, "customer_id" INTEGER NOT NULL, "quarter" VARCHAR(30) NOT NULL, "the_year" SMALLINT NOT NULL, "store_sales" DECIMAL(10,4) NOT NULL, "store_cost" DECIMAL(10,4) NOT NULL, "unit_sales" DECIMAL(10,4) NOT NULL, "fact_count" INTEGER NOT NULL) DROP TABLE "agg_c_special_sales_fact_1997" Drop of agg_c_special_sales_fact_1997 failed. Ignored CREATE TABLE "agg_c_special_sales_fact_1997"( "product_id" INTEGER NOT NULL, "promotion_id" INTEGER NOT NULL, "customer_id" INTEGER NOT NULL, "store_id" INTEGER NOT NULL, "time_month" SMALLINT NOT NULL, "time_quarter" VARCHAR(30) NOT NULL, "time_year" SMALLINT NOT NULL, "store_sales_sum" DECIMAL(10,4) NOT NULL, "store_cost_sum" DECIMAL(10,4) NOT NULL, "unit_sales_sum" DECIMAL(10,4) NOT NULL, "fact_count" INTEGER NOT NULL) DROP TABLE "agg_g_ms_pcat_sales_fact_1997" Drop of agg_g_ms_pcat_sales_fact_1997 failed. Ignored CREATE TABLE "agg_g_ms_pcat_sales_fact_1997"( "gender" VARCHAR(30) NOT NULL, "marital_status" VARCHAR(30) NOT NULL, "product_family" VARCHAR(30), "product_department" VARCHAR(30), "product_category" VARCHAR(30), "month_of_year" SMALLINT NOT NULL, "quarter" VARCHAR(30) NOT NULL, "the_year" SMALLINT NOT NULL, "store_sales" DECIMAL(10,4) NOT NULL, "store_cost" DECIMAL(10,4) NOT NULL, "unit_sales" DECIMAL(10,4) NOT NULL, "customer_count" INTEGER NOT NULL, "fact_count" INTEGER NOT NULL) DROP TABLE "agg_lc_06_sales_fact_1997" Drop of agg_lc_06_sales_fact_1997 failed. Ignored CREATE TABLE "agg_lc_06_sales_fact_1997"( "time_id" INTEGER NOT NULL, "city" VARCHAR(30) NOT NULL, "state_province" VARCHAR(30) NOT NULL, "country" VARCHAR(30) NOT NULL, "store_sales" DECIMAL(10,4) NOT NULL, "store_cost" DECIMAL(10,4) NOT NULL, "unit_sales" DECIMAL(10,4) NOT NULL, "fact_count" INTEGER NOT NULL) DROP TABLE "currency" Drop of currency failed. Ignored CREATE TABLE "currency"( "currency_id" INTEGER NOT NULL, "date" DATE NOT NULL, "currency" VARCHAR(30) NOT NULL, "conversion_ratio" DECIMAL(10,4) NOT NULL) DROP TABLE "account" Drop of account failed. Ignored CREATE TABLE "account"( "account_id" INTEGER NOT NULL, "account_parent" INTEGER, "account_description" VARCHAR(30), "account_type" VARCHAR(30) NOT NULL, "account_rollup" VARCHAR(30) NOT NULL, "Custom_Members" VARCHAR(255)) DROP TABLE "category" Drop of category failed. Ignored CREATE TABLE "category"( "category_id" VARCHAR(30) NOT NULL, "category_parent" VARCHAR(30), "category_description" VARCHAR(30) NOT NULL, "category_rollup" VARCHAR(30)) DROP TABLE "customer" Drop of customer failed. Ignored CREATE TABLE "customer"( "customer_id" INTEGER NOT NULL, "account_num" BIGINT NOT NULL, "lname" VARCHAR(30) NOT NULL, "fname" VARCHAR(30) NOT NULL, "mi" VARCHAR(30), "address1" VARCHAR(30), "address2" VARCHAR(30), "address3" VARCHAR(30), "address4" VARCHAR(30), "city" VARCHAR(30), "state_province" VARCHAR(30), "postal_code" VARCHAR(30) NOT NULL, "country" VARCHAR(30) NOT NULL, "customer_region_id" INTEGER NOT NULL, "phone1" VARCHAR(30) NOT NULL, "phone2" VARCHAR(30) NOT NULL, "birthdate" DATE NOT NULL, "marital_status" VARCHAR(30) NOT NULL, "yearly_income" VARCHAR(30) NOT NULL, "gender" VARCHAR(30) NOT NULL, "total_children" SMALLINT NOT NULL, "num_children_at_home" SMALLINT NOT NULL, "education" VARCHAR(30) NOT NULL, "date_accnt_opened" DATE NOT NULL, "member_card" VARCHAR(30), "occupation" VARCHAR(30), "houseowner" VARCHAR(30), "num_cars_owned" INTEGER, "fullname" VARCHAR(60) NOT NULL) DROP TABLE "days" Drop of days failed. Ignored CREATE TABLE "days"( "day" INTEGER NOT NULL, "week_day" VARCHAR(30) NOT NULL) DROP TABLE "department" Drop of department failed. Ignored CREATE TABLE "department"( "department_id" INTEGER NOT NULL, "department_description" VARCHAR(30) NOT NULL) DROP TABLE "employee" Drop of employee failed. Ignored CREATE TABLE "employee"( "employee_id" INTEGER NOT NULL, "full_name" VARCHAR(30) NOT NULL, "first_name" VARCHAR(30) NOT NULL, "last_name" VARCHAR(30) NOT NULL, "position_id" INTEGER, "position_title" VARCHAR(30), "store_id" INTEGER NOT NULL, "department_id" INTEGER NOT NULL, "birth_date" DATE NOT NULL, "hire_date" TIMESTAMP, "end_date" TIMESTAMP, "salary" DECIMAL(10,4) NOT NULL, "supervisor_id" INTEGER, "education_level" VARCHAR(30) NOT NULL, "marital_status" VARCHAR(30) NOT NULL, "gender" VARCHAR(30) NOT NULL, "management_role" VARCHAR(30)) DROP TABLE "employee_closure" Drop of employee_closure failed. Ignored CREATE TABLE "employee_closure"( "employee_id" INTEGER NOT NULL, "supervisor_id" INTEGER NOT NULL, "distance" INTEGER) DROP TABLE "expense_fact" Drop of expense_fact failed. Ignored CREATE TABLE "expense_fact"( "store_id" INTEGER NOT NULL, "account_id" INTEGER NOT NULL, "exp_date" TIMESTAMP NOT NULL, "time_id" INTEGER NOT NULL, "category_id" VARCHAR(30) NOT NULL, "currency_id" INTEGER NOT NULL, "amount" DECIMAL(10,4) NOT NULL) DROP TABLE "position" Drop of position failed. Ignored CREATE TABLE "position"( "position_id" INTEGER NOT NULL, "position_title" VARCHAR(30) NOT NULL, "pay_type" VARCHAR(30) NOT NULL, "min_scale" DECIMAL(10,4) NOT NULL, "max_scale" DECIMAL(10,4) NOT NULL, "management_role" VARCHAR(30) NOT NULL) DROP TABLE "product" Drop of product failed. Ignored CREATE TABLE "product"( "product_class_id" INTEGER NOT NULL, "product_id" INTEGER NOT NULL, "brand_name" VARCHAR(60), "product_name" VARCHAR(60) NOT NULL, "SKU" BIGINT NOT NULL, "SRP" DECIMAL(10,4), "gross_weight" REAL, "net_weight" REAL, "recyclable_package" BOOLEAN, "low_fat" BOOLEAN, "units_per_case" SMALLINT, "cases_per_pallet" SMALLINT, "shelf_width" REAL, "shelf_height" REAL, "shelf_depth" REAL) DROP TABLE "product_class" Drop of product_class failed. Ignored CREATE TABLE "product_class"( "product_class_id" INTEGER NOT NULL, "product_subcategory" VARCHAR(30), "product_category" VARCHAR(30), "product_department" VARCHAR(30), "product_family" VARCHAR(30)) DROP TABLE "promotion" Drop of promotion failed. Ignored CREATE TABLE "promotion"( "promotion_id" INTEGER NOT NULL, "promotion_district_id" INTEGER, "promotion_name" VARCHAR(30), "media_type" VARCHAR(30), "cost" DECIMAL(10,4), "start_date" TIMESTAMP, "end_date" TIMESTAMP) DROP TABLE "region" Drop of region failed. Ignored CREATE TABLE "region"( "region_id" INTEGER NOT NULL, "sales_city" VARCHAR(30), "sales_state_province" VARCHAR(30), "sales_district" VARCHAR(30), "sales_region" VARCHAR(30), "sales_country" VARCHAR(30), "sales_district_id" INTEGER) DROP TABLE "reserve_employee" Drop of reserve_employee failed. Ignored CREATE TABLE "reserve_employee"( "employee_id" INTEGER NOT NULL, "full_name" VARCHAR(30) NOT NULL, "first_name" VARCHAR(30) NOT NULL, "last_name" VARCHAR(30) NOT NULL, "position_id" INTEGER, "position_title" VARCHAR(30), "store_id" INTEGER NOT NULL, "department_id" INTEGER NOT NULL, "birth_date" TIMESTAMP NOT NULL, "hire_date" TIMESTAMP, "end_date" TIMESTAMP, "salary" DECIMAL(10,4) NOT NULL, "supervisor_id" INTEGER, "education_level" VARCHAR(30) NOT NULL, "marital_status" VARCHAR(30) NOT NULL, "gender" VARCHAR(30) NOT NULL) DROP TABLE "salary" Drop of salary failed. Ignored CREATE TABLE "salary"( "pay_date" TIMESTAMP NOT NULL, "employee_id" INTEGER NOT NULL, "department_id" INTEGER NOT NULL, "currency_id" INTEGER NOT NULL, "salary_paid" DECIMAL(10,4) NOT NULL, "overtime_paid" DECIMAL(10,4) NOT NULL, "vacation_accrued" REAL NOT NULL, "vacation_used" REAL NOT NULL) DROP TABLE "store" Drop of store failed. Ignored CREATE TABLE "store"( "store_id" INTEGER NOT NULL, "store_type" VARCHAR(30), "region_id" INTEGER, "store_name" VARCHAR(30), "store_number" INTEGER, "store_street_address" VARCHAR(30), "store_city" VARCHAR(30), "store_state" VARCHAR(30), "store_postal_code" VARCHAR(30), "store_country" VARCHAR(30), "store_manager" VARCHAR(30), "store_phone" VARCHAR(30), "store_fax" VARCHAR(30), "first_opened_date" TIMESTAMP, "last_remodel_date" TIMESTAMP, "store_sqft" INTEGER, "grocery_sqft" INTEGER, "frozen_sqft" INTEGER, "meat_sqft" INTEGER, "coffee_bar" BOOLEAN, "video_store" BOOLEAN, "salad_bar" BOOLEAN, "prepared_food" BOOLEAN, "florist" BOOLEAN) DROP TABLE "store_ragged" Drop of store_ragged failed. Ignored CREATE TABLE "store_ragged"( "store_id" INTEGER NOT NULL, "store_type" VARCHAR(30), "region_id" INTEGER, "store_name" VARCHAR(30), "store_number" INTEGER, "store_street_address" VARCHAR(30), "store_city" VARCHAR(30), "store_state" VARCHAR(30), "store_postal_code" VARCHAR(30), "store_country" VARCHAR(30), "store_manager" VARCHAR(30), "store_phone" VARCHAR(30), "store_fax" VARCHAR(30), "first_opened_date" TIMESTAMP, "last_remodel_date" TIMESTAMP, "store_sqft" INTEGER, "grocery_sqft" INTEGER, "frozen_sqft" INTEGER, "meat_sqft" INTEGER, "coffee_bar" BOOLEAN, "video_store" BOOLEAN, "salad_bar" BOOLEAN, "prepared_food" BOOLEAN, "florist" BOOLEAN) DROP TABLE "time_by_day" Drop of time_by_day failed. Ignored CREATE TABLE "time_by_day"( "time_id" INTEGER NOT NULL, "the_date" TIMESTAMP, "the_day" VARCHAR(30), "the_month" VARCHAR(30), "the_year" SMALLINT, "day_of_month" SMALLINT, "week_of_year" INTEGER, "month_of_year" SMALLINT, "quarter" VARCHAR(30), "fiscal_period" VARCHAR(30)) DROP TABLE "warehouse" Drop of warehouse failed. Ignored CREATE TABLE "warehouse"( "warehouse_id" INTEGER NOT NULL, "warehouse_class_id" INTEGER, "stores_id" INTEGER, "warehouse_name" VARCHAR(60), "wa_address1" VARCHAR(30), "wa_address2" VARCHAR(30), "wa_address3" VARCHAR(30), "wa_address4" VARCHAR(30), "warehouse_city" VARCHAR(30), "warehouse_state_province" VARCHAR(30), "warehouse_postal_code" VARCHAR(30), "warehouse_country" VARCHAR(30), "warehouse_owner_name" VARCHAR(30), "warehouse_phone" VARCHAR(30), "warehouse_fax" VARCHAR(30)) DROP TABLE "warehouse_class" Drop of warehouse_class failed. Ignored CREATE TABLE "warehouse_class"( "warehouse_class_id" INTEGER NOT NULL, "description" VARCHAR(30)) Table days: loaded 7 rows. Table product: loaded 1560 rows. Table product_class: loaded 110 rows. Table inventory_fact_1998: loaded 7282 rows. Table position: loaded 18 rows. Table currency: loaded 72 rows. Table region: loaded 110 rows. Table store_ragged: loaded 25 rows. Table reserve_employee: loaded 143 rows. Table time_by_day: loaded 730 rows. Table expense_fact: loaded 2400 rows. Table department: loaded 12 rows. Table employee_closure: loaded 7179 rows. Table warehouse: loaded 24 rows. Table account: loaded 11 rows. Table category: loaded 4 rows. Table warehouse_class: loaded 6 rows. ^[[ATable customer: loaded 10281 rows. Table promotion: loaded 1864 rows. Table salary: loaded 21252 rows. Table store: loaded 25 rows. Table employee: loaded 1155 rows. Table sales_fact_1998: loaded 164558 rows. Table sales_fact_1997: loaded 86837 rows. Table inventory_fact_1997: loaded 4070 rows. Table sales_fact_dec_1998: loaded 18325 rows. CREATE UNIQUE INDEX "i_account_id" ON "account" ("account_id") CREATE INDEX "i_account_parent" ON "account" ("account_parent") CREATE UNIQUE INDEX "i_category_id" ON "category" ("category_id") CREATE INDEX "i_category_parent" ON "category" ("category_parent") CREATE UNIQUE INDEX "i_currency" ON "currency" ("currency_id", "date") CREATE INDEX "i_cust_acct_num" ON "customer" ("account_num") CREATE INDEX "i_customer_fname" ON "customer" ("fname") CREATE INDEX "i_customer_lname" ON "customer" ("lname") CREATE INDEX "i_cust_child_home" ON "customer" ("num_children_at_home") CREATE UNIQUE INDEX "i_customer_id" ON "customer" ("customer_id") CREATE INDEX "i_cust_postal_code" ON "customer" ("postal_code") CREATE INDEX "i_cust_region_id" ON "customer" ("customer_region_id") CREATE UNIQUE INDEX "i_department_id" ON "department" ("department_id") CREATE UNIQUE INDEX "i_employee_id" ON "employee" ("employee_id") CREATE INDEX "i_empl_dept_id" ON "employee" ("department_id") CREATE INDEX "i_empl_store_id" ON "employee" ("store_id") CREATE INDEX "i_empl_super_id" ON "employee" ("supervisor_id") CREATE UNIQUE INDEX "i_empl_closure" ON "employee_closure" ("supervisor_id", "employee_id") CREATE INDEX "i_empl_closure_emp" ON "employee_closure" ("employee_id") CREATE INDEX "i_expense_store_id" ON "expense_fact" ("store_id") CREATE INDEX "i_expense_acct_id" ON "expense_fact" ("account_id") CREATE INDEX "i_expense_time_id" ON "expense_fact" ("time_id") CREATE INDEX "i_inv_97_prod_id" ON "inventory_fact_1997" ("product_id") CREATE INDEX "i_inv_97_store_id" ON "inventory_fact_1997" ("store_id") CREATE INDEX "i_inv_97_time_id" ON "inventory_fact_1997" ("time_id") CREATE INDEX "i_inv_97_wrhse_id" ON "inventory_fact_1997" ("warehouse_id") CREATE INDEX "i_inv_98_prod_id" ON "inventory_fact_1998" ("product_id") CREATE INDEX "i_inv_98_store_id" ON "inventory_fact_1998" ("store_id") CREATE INDEX "i_inv_98_time_id" ON "inventory_fact_1998" ("time_id") CREATE INDEX "i_inv_98_wrhse_id" ON "inventory_fact_1998" ("warehouse_id") CREATE UNIQUE INDEX "i_position_id" ON "position" ("position_id") CREATE INDEX "i_prod_brand_name" ON "product" ("brand_name") CREATE UNIQUE INDEX "i_product_id" ON "product" ("product_id") CREATE INDEX "i_prod_class_id" ON "product" ("product_class_id") CREATE INDEX "i_product_name" ON "product" ("product_name") CREATE INDEX "i_product_SKU" ON "product" ("SKU") CREATE UNIQUE INDEX "i_promotion_id" ON "promotion" ("promotion_id") CREATE INDEX "i_promo_dist_id" ON "promotion" ("promotion_district_id") CREATE UNIQUE INDEX "i_rsrv_empl_id" ON "reserve_employee" ("employee_id") CREATE INDEX "i_rsrv_empl_dept" ON "reserve_employee" ("department_id") CREATE INDEX "i_rsrv_empl_store" ON "reserve_employee" ("store_id") CREATE INDEX "i_rsrv_empl_sup" ON "reserve_employee" ("supervisor_id") CREATE INDEX "i_salary_pay_date" ON "salary" ("pay_date") CREATE INDEX "i_salary_employee" ON "salary" ("employee_id") CREATE INDEX "i_sls_97_cust_id" ON "sales_fact_1997" ("customer_id") CREATE INDEX "i_sls_97_prod_id" ON "sales_fact_1997" ("product_id") CREATE INDEX "i_sls_97_promo_id" ON "sales_fact_1997" ("promotion_id") CREATE INDEX "i_sls_97_store_id" ON "sales_fact_1997" ("store_id") CREATE INDEX "i_sls_97_time_id" ON "sales_fact_1997" ("time_id") CREATE INDEX "i_sls_dec98_cust" ON "sales_fact_dec_1998" ("customer_id") CREATE INDEX "i_sls_dec98_prod" ON "sales_fact_dec_1998" ("product_id") CREATE INDEX "i_sls_dec98_promo" ON "sales_fact_dec_1998" ("promotion_id") CREATE INDEX "i_sls_dec98_store" ON "sales_fact_dec_1998" ("store_id") CREATE INDEX "i_sls_dec98_time" ON "sales_fact_dec_1998" ("time_id") CREATE INDEX "i_sls_98_cust_id" ON "sales_fact_1998" ("customer_id") CREATE INDEX "i_sls_1998_prod_id" ON "sales_fact_1998" ("product_id") CREATE INDEX "i_sls_1998_promo" ON "sales_fact_1998" ("promotion_id") CREATE INDEX "i_sls_1998_store" ON "sales_fact_1998" ("store_id") CREATE INDEX "i_sls_1998_time_id" ON "sales_fact_1998" ("time_id") CREATE UNIQUE INDEX "i_store_id" ON "store" ("store_id") CREATE INDEX "i_store_region_id" ON "store" ("region_id") CREATE UNIQUE INDEX "i_store_raggd_id" ON "store_ragged" ("store_id") CREATE INDEX "i_store_rggd_reg" ON "store_ragged" ("region_id") CREATE UNIQUE INDEX "i_time_id" ON "time_by_day" ("time_id") CREATE UNIQUE INDEX "i_time_day" ON "time_by_day" ("the_date") CREATE INDEX "i_time_year" ON "time_by_day" ("the_year") CREATE INDEX "i_time_quarter" ON "time_by_day" ("quarter") CREATE INDEX "i_time_month" ON "time_by_day" ("month_of_year") CREATE INDEX "i_sls97pl01cust" ON "agg_pl_01_sales_fact_1997" ("customer_id") CREATE INDEX "i_sls97pl01prod" ON "agg_pl_01_sales_fact_1997" ("product_id") CREATE INDEX "i_sls97pl01time" ON "agg_pl_01_sales_fact_1997" ("time_id") CREATE INDEX "i_sls97ll01cust" ON "agg_ll_01_sales_fact_1997" ("customer_id") CREATE INDEX "i_sls97ll01prod" ON "agg_ll_01_sales_fact_1997" ("product_id") CREATE INDEX "i_sls97ll01time" ON "agg_ll_01_sales_fact_1997" ("time_id") CREATE INDEX "i_sls97l05cust" ON "agg_l_05_sales_fact_1997" ("customer_id") CREATE INDEX "i_sls97l05prod" ON "agg_l_05_sales_fact_1997" ("product_id") CREATE INDEX "i_sls97l05promo" ON "agg_l_05_sales_fact_1997" ("promotion_id") CREATE INDEX "i_sls97l05store" ON "agg_l_05_sales_fact_1997" ("store_id") CREATE INDEX "i_sls97c14cust" ON "agg_c_14_sales_fact_1997" ("customer_id") CREATE INDEX "i_sls97c14prod" ON "agg_c_14_sales_fact_1997" ("product_id") CREATE INDEX "i_sls97c14promo" ON "agg_c_14_sales_fact_1997" ("promotion_id") CREATE INDEX "i_sls97c14store" ON "agg_c_14_sales_fact_1997" ("store_id") CREATE INDEX "i_sls97lc100cust" ON "agg_lc_100_sales_fact_1997" ("customer_id") CREATE INDEX "i_sls97lc100prod" ON "agg_lc_100_sales_fact_1997" ("product_id") CREATE INDEX "i_sls97speccust" ON "agg_c_special_sales_fact_1997" ("customer_id") CREATE INDEX "i_sls97specprod" ON "agg_c_special_sales_fact_1997" ("product_id") CREATE INDEX "i_sls97specpromo" ON "agg_c_special_sales_fact_1997" ("promotion_id") CREATE INDEX "i_sls97specstore" ON "agg_c_special_sales_fact_1997" ("store_id") CREATE INDEX "i_sls97gmp_gender" ON "agg_g_ms_pcat_sales_fact_1997" ("gender") CREATE INDEX "i_sls97gmp_ms" ON "agg_g_ms_pcat_sales_fact_1997" ("marital_status") CREATE INDEX "i_sls97gmp_pfam" ON "agg_g_ms_pcat_sales_fact_1997" ("product_family") CREATE INDEX "i_sls97gmp_pdept" ON "agg_g_ms_pcat_sales_fact_1997" ("product_department") CREATE INDEX "i_sls97gmp_pcat" ON "agg_g_ms_pcat_sales_fact_1997" ("product_category") CREATE INDEX "i_sls97gmp_tmonth" ON "agg_g_ms_pcat_sales_fact_1997" ("month_of_year") CREATE INDEX "i_sls97gmp_tquarter" ON "agg_g_ms_pcat_sales_fact_1997" ("quarter") CREATE INDEX "i_sls97gmp_tyear" ON "agg_g_ms_pcat_sales_fact_1997" ("the_year") INSERT INTO "agg_pl_01_sales_fact_1997" ( "product_id", "time_id", "customer_id", "store_sales_sum", "store_cost_sum", "unit_sales_sum", "fact_count" ) SELECT "product_id" AS "product_id", "time_id" AS "time_id", "customer_id" AS "customer_id", SUM("store_sales") AS "store_sales", SUM("store_cost") AS "store_cost", SUM("unit_sales") AS "unit_sales", COUNT(*) AS fact_count FROM "sales_fact_1997" GROUP BY "product_id", "time_id", "customer_id" INSERT INTO "agg_ll_01_sales_fact_1997" ( "product_id", "time_id", "customer_id", "store_sales", "store_cost", "unit_sales", "fact_count" ) SELECT "product_id" AS "product_id", "time_id" AS "time_id", "customer_id" AS "customer_id", SUM("store_sales") AS "store_sales", SUM("store_cost") AS "store_cost", SUM("unit_sales") AS "unit_sales", COUNT(*) AS "fact_count" FROM "sales_fact_1997" GROUP BY "product_id", "time_id", "customer_id" INSERT INTO "agg_l_03_sales_fact_1997" ( "customer_id", "time_id", "store_sales", "store_cost", "unit_sales", "fact_count" ) SELECT "customer_id", "time_id", SUM("store_sales") AS "store_sales", SUM("store_cost") AS "store_cost", SUM("unit_sales") AS "unit_sales", COUNT(*) AS "fact_count" FROM "sales_fact_1997" GROUP BY "customer_id", "time_id" INSERT INTO "agg_lc_06_sales_fact_1997" ( "time_id", "city", "state_province", "country", "store_sales", "store_cost", "unit_sales", "fact_count" ) SELECT "B"."time_id", "D"."city", "D"."state_province", "D"."country", SUM("B"."store_sales") AS "store_sales", SUM("B"."store_cost") AS "store_cost", SUM("B"."unit_sales") AS "unit_sales", COUNT(*) AS fact_count FROM "sales_fact_1997" "B", "customer" "D" WHERE "B"."customer_id" = "D"."customer_id" GROUP BY "B"."time_id", "D"."city", "D"."state_province", "D"."country" INSERT INTO "agg_l_04_sales_fact_1997" ( "time_id", "store_sales", "store_cost", "unit_sales", "customer_count", "fact_count" ) SELECT "time_id", SUM("store_sales") AS "store_sales", SUM("store_cost") AS "store_cost", SUM("unit_sales") AS "unit_sales", COUNT(DISTINCT "customer_id") AS "customer_count", COUNT(*) AS "fact_count" FROM "sales_fact_1997" GROUP BY "time_id" INSERT INTO "agg_c_10_sales_fact_1997" ( "month_of_year", "quarter", "the_year", "store_sales", "store_cost", "unit_sales", "customer_count", "fact_count" ) SELECT "D"."month_of_year", "D"."quarter", "D"."the_year", SUM("B"."store_sales") AS "store_sales", SUM("B"."store_cost") AS "store_cost", SUM("B"."unit_sales") AS "unit_sales", COUNT(DISTINCT "customer_id") AS "customer_count", COUNT(*) AS fact_count FROM "sales_fact_1997" "B", "time_by_day" "D" WHERE "B"."time_id" = "D"."time_id" GROUP BY "D"."month_of_year", "D"."quarter", "D"."the_year" INSERT INTO "agg_l_05_sales_fact_1997" ( "product_id", "customer_id", "promotion_id", "store_id", "store_sales", "store_cost", "unit_sales", "fact_count" ) SELECT "product_id", "customer_id", "promotion_id", "store_id", SUM("store_sales") AS "store_sales", SUM("store_cost") AS "store_cost", SUM("unit_sales") AS "unit_sales", COUNT(*) AS fact_count FROM "sales_fact_1997" GROUP BY "product_id", "customer_id", "promotion_id", "store_id" INSERT INTO "agg_c_14_sales_fact_1997" ( "product_id", "customer_id", "promotion_id", "store_id", "month_of_year", "quarter", "the_year", "store_sales", "store_cost", "unit_sales", "fact_count" ) SELECT "B"."product_id", "B"."customer_id", "B"."promotion_id", "B"."store_id", "D"."month_of_year", "D"."quarter", "D"."the_year", SUM("B"."store_sales") AS "store_sales", SUM("B"."store_cost") AS "store_cost", SUM("B"."unit_sales") AS "unit_sales", COUNT(*) AS fact_count FROM "sales_fact_1997" "B", "time_by_day" "D" WHERE "B"."time_id" = "D"."time_id" GROUP BY "B"."product_id", "B"."customer_id", "B"."promotion_id", "B"."store_id", "D"."month_of_year", "D"."quarter", "D"."the_year" INSERT INTO "agg_lc_100_sales_fact_1997" ( "product_id", "customer_id", "quarter", "the_year", "store_sales", "store_cost", "unit_sales", "fact_count" ) SELECT "B"."product_id", "B"."customer_id", "D"."quarter", "D"."the_year", SUM("B"."store_sales") AS "store_sales", SUM("B"."store_cost") AS "store_cost", SUM("B"."unit_sales") AS "unit_sales", COUNT(*) AS fact_count FROM "sales_fact_1997" "B", "time_by_day" "D" WHERE "B"."time_id" = "D"."time_id" GROUP BY "B"."product_id", "B"."customer_id", "D"."quarter", "D"."the_year" INSERT INTO "agg_c_special_sales_fact_1997" ( "product_id", "customer_id", "promotion_id", "store_id", "time_month", "time_quarter", "time_year", "store_sales_sum", "store_cost_sum", "unit_sales_sum", "fact_count" ) SELECT "B"."product_id", "B"."customer_id", "B"."promotion_id", "B"."store_id", "D"."month_of_year", "D"."quarter", "D"."the_year", SUM("B"."store_sales") AS "store_sales_sum", SUM("B"."store_cost") AS "store_cost_sum", SUM("B"."unit_sales") AS "unit_sales_sum", COUNT(*) AS "fact_count" FROM "sales_fact_1997" "B", "time_by_day" "D" WHERE "B"."time_id" = "D"."time_id" GROUP BY "B"."product_id", "B"."customer_id", "B"."promotion_id", "B"."store_id", "D"."month_of_year", "D"."quarter", "D"."the_year" INSERT INTO "agg_g_ms_pcat_sales_fact_1997" ( "gender", "marital_status", "product_family", "product_department", "product_category", "month_of_year", "quarter", "the_year", "store_sales", "store_cost", "unit_sales", "customer_count", "fact_count" ) SELECT "C"."gender", "C"."marital_status", "PC"."product_family", "PC"."product_department", "PC"."product_category", "T"."month_of_year", "T"."quarter", "T"."the_year", SUM("B"."store_sales") AS "store_sales", SUM("B"."store_cost") AS "store_cost", SUM("B"."unit_sales") AS "unit_sales", COUNT(DISTINCT "C"."customer_id") AS "customer_count", COUNT(*) AS "fact_count" FROM "sales_fact_1997" "B", "time_by_day" "T", "product" "P", "product_class" "PC", "customer" "C" WHERE "B"."time_id" = "T"."time_id" AND "B"."customer_id" = "C"."customer_id" AND "B"."product_id" = "P"."product_id" AND "P"."product_class_id" = "PC"."product_class_id" GROUP BY "C"."gender", "C"."marital_status", "PC"."product_family", "PC"."product_department", "PC"."product_category", "T"."month_of_year", "T"."quarter", "T"."the_year" Finished load at: Tue Sep 21 16:27:35 EDT 2010 gv1@gv1-laptop:/mondrian$