1. Within the Module 18 database, right-click the Cubes folder, point to New Cube, and then click Wizard.
2. Click Next to skip the welcome screen.
3. Click inventory_fact_1998 and then click Next.
4. Double-click units_ordered, units_shipped, warehouse_sales, warehouse_cost, supply_time, and then click Next.
5. Click the New Dimension button, click Next, click Snowflake Schema, click Next, double-click product and product_class, and then click Next twice.
6. Double-click product_family, product_department, product_category, product_subcategory, brand_name, product_name, and then click Next three times.
7. Type Product in the Dimension name box, and then click Finish.
8. Click the New Dimension button, click Next, click Star Schema, click Next, click time_by_day, and then click Next.
9. Click Time dimension, click Next, click Year, Quarter, Month in the Select time levels list, and then click Next twice.
10. Type Time in the Dimension name box, and then click Finish.
11. Click the New Dimension button, click Next, click Snowflake Schema, click Next, double-click warehouse and warehouse_class, and then click Next twice.
12. Double-click warehouse_country, description, warehouse_state, warehouse_name, and then click Next three times.
13. Type Warehouse in the Dimension name box, and then click Finish.
14. Click the New Dimension button, click Next, click Star Schema, click Next, click store, and then click Next twice.
15. Double-click store_country, store_state, store_city, store_name, and then click Next three times.
16. Type Store in the Dimension name box, and then click Finish.
17. Click the New Dimension button, click Next, click Star Schema, click Next, click store, and then click Next.
18. Click Time dimension, click Next, click Year, Month in the Select time levels list, and then click Next twice.
19. Type First Opened Year in the Dimension name box, deselect the Share this dimension with other cubes checkbox, and then click Finish.
20. Click Next, click Yes to count the fact table records, type Warehouse in the Cube name box, and then click Finish.
21. Expand the First Opened Year dimension, delete the Month level, and then rename the Year level First Opened Year.
22. Click the Supply Time measure, click the Basic tab of the properties pane, rename Supply Time to Maximum Supply Time, and then change the Aggregate Function to Max.
23. From the Tools menu click Process Cube, click Yes, click No, click OK, and then click Close after the cube finishes processing.