Rem *****
Rem DROP MV'S before start advisor
Rem *****
DROP MATERIALIZED VIEW all_cust_sales_mv;
DROP MATERIALIZED VIEW costs_mv;
DROP MATERIALIZED VIEW costs_pm_mv;
DROP MATERIALIZED VIEW cust_sales_mv;
DROP MATERIALIZED VIEW some_cust_sales_mv;
DROP MATERIALIZED VIEW cust_id_sales_aggr;
DROP MATERIALIZED VIEW sales_cube_mv;
DROP MATERIALIZED VIEW sales_gby_mv;

Rem *****
Rem Remove some dimensions due to time required to recommend mv's
Rem *****
DROP DIMENSION channels_dim;
DROP DIMENSION promotions_dim;
DROP DIMENSION products_dim;