1. Within the Module 07 database, right-click the Cubes folder, point to New Cube, and then click Wizard.
2. Click Next to skip the welcome screen.
3. Click expense_fact and then click Next.
4. Double-click amount and then click Next.
5. Click the New Dimension button and then click Next.
6. Click Star Schema, click Next, click scenario, and then click Next.
7. Double-click category_description, click Next three times, type Scenario in the Dimension name box, and then click Finish.
8. Click the New Dimension button, click Next, click Star Schema, click Next, click expense_fact, 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, deselect the Share this dimension with other cubes check box, and then click Finish.
11. Click the New Dimension button, click Next, click Star Schema, click Next, click store, and then click Next twice.
12. Double-click store_country, store_state, store_city, store_name, and then click Next three times.
13. Type Store 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_manager and then click Next three times.
16. Type Store Manager in the Dimension name box, deselect the Share this dimension with other cubes check box, and then click Finish.
17. Click the New Dimension button, click Next, click Parent-Child, click Next, click account, and then click Next.
18. Click account_id for the Member key list, click account_parent for the Parent key list, click account_description for the Member name list, and then click Next twice.
19. Type Account in the Dimension name box, and then click Finish.
20. Click the New Dimension button, click Next, click Snowflake Schema, click Next, double-click position and department, and then click Next twice.
21. Double-click area, department_description, position_description, and then click Next three times.
22. Type Department in the Dimension name box, and then click Finish.
23. Click Next, click Yes to count the fact table records, type Store Expense in the Cube name box, and then click Finish.
24. From the Tools menu click Process Cube, click No, click OK, and click Close after the cube finishes processing.