LabB CreateStoreTypeDimension

1. Within the Module 07 database, expand the Shared Dimensions folder, right-click Store, and then click Edit.
2. In the dimension tree, expand the Store Name level, right-click the Member properties folder, click New Member Property, click store_type, and then click OK.
3. Save the Store dimension and close the Dimension Editor.
4. Right-click the Shared Dimensions folder, point to New Dimension, click Wizard, click Next, click Virtual Dimension, click Next, click Store, and then click Next.
5. Double-click Store Name.Store Type, and then click Next twice.
6. Type Store Type in the Dimension name box, click Finish, and then close the Dimension Editor.
7. In the Cubes folder, right-click the Store Expense cube, and then click Edit.
8. Right-click the Dimensions folder, click Existing Dimensions, double-click Store Type, and then click OK.

Wyszukiwarka