Module 18: Case Study Working with the Foodmart Database

Tham khảo tài liệu 'module 18: case study working with the foodmart database', công nghệ thông tin, quản trị mạng phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả
Nội dung trích xuất từ tài liệu:
Module 18: Case Study Working with the Foodmart Database Module 18: Case Study—Working with the Foodmart Database Contents Overview 1 Building the Warehouse Cube 2 Lab A: Building the Warehouse Cube 8 Building the Sales Cube 16 Lab B: Building the Sales Cube 22 Building the Warehouse and Sales Virtual Cube 28 Lab C: Building the Warehouse and Sales Cube 33 Review 38 Information in this document is subject to change without notice. The names of companies, products, people, characters, and/or data mentioned herein are fictitious and are in no way intended to represent any real individual, company, product, or event, unless otherwise noted. Complying with all applicable copyright laws is the responsibility of the user. No part of this document may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Microsoft Corporation. If, however, your only means of access is electronic, permission to print one copy is hereby granted. Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document. Except as expressly provided in any written license agreement from Microsoft, the furnishing of this document does not give you any license to these patents, trademarks, copyrights, or other intellectual property.  2000 Microsoft Corporation. All rights reserved. Microsoft, BackOffice, MS-DOS, Windows, Windows NT, are either registered trademarks or trademarks of Microsoft Corporation in the U.S.A. and/or other countries. The names of companies, products, people, characters, and/or data mentioned herein are fictitious and are in no way intended to represent any real individual, company, product, or event, unless otherwise noted. Other product and company names mentioned herein may be the trademarks of their respective owners. BETA MATERIALS FOR MICROSOFT CERTIFIED TRAINER PREPARATION PURPOSES ONLY Module 18: Case Study—Working with the Foodmart Database iii Instructor Notes Presentation: In this module, students apply concepts they have learned in modules 1 through 60 Minutes 17 in the course 2074A, Designing and Implementing OLAP Solutions Using Microsoft® SQL Server™ 2000. Students will use various cube and dimension Labs: techniques to build cubes from the Foodmart 2000 database by using 120 Minutes Microsoft SQL Server 2000 Analysis Services. In the labs, students are given high-level procedures and must recall the specific steps and actions for creating various dimension and cube structures. Students create a preliminary cube, and must then make changes to the cube by applying dimension and level properties. After completing this module, students will be able to: Create a cube based on user requirements. ! Create another cube with different dimensions and measures. ! Build a virtual cube. ! Materials and Preparation This section lists the required materials and preparation tasks that you need to teach this module. Required Materials To teach this module, you need the following materials: Microsoft PowerPoint® file 2074A_18.ppt ! Preparation Tasks To prepare for this module, you should: Perform all the student labs. ! Read all the student materials. ! Read the instructor notes and margin notes. ! Practice integrating the demonstrations with the lecture. ! Review the Trainer Preparation presentation for this module on the Trainer ! Materials compact disc. Review any relevant white papers that are located on the Trainer Materials ! compact disc. BETA MATERIALS FOR MICROSOFT CERTIFIED TRAINER PREPARATION PURPOSES ONLY iv Module 18: Case Study—Working with the Foodmart Database Demonstration: Reviewing Lab A In this demonstration, you will view and discuss the solutions of lab A. The following demonstration procedures provide information that will not fit in the margin notes or is not appropriate for student notes. ! To restore a new database and define a data source 1. In Analysis Manager, right-click the server, click Restore Database, click the Look in list, click the file C:\Moc\2074A\Labfiles\L18\Answers\Module 18A.CAB, click Open, click the Restore button, and then click Close. 2. Expand the Module 18A database, double-click the Data Sources folder, right-click the FoodMart 2000 data source, and then click Edit. 3. Verify that FoodMart 2000 is selected in step 1. Click OK. ! To view the Warehouse cube 1. Expand the Cubes folder, right-click Warehouse, and then click Edit. 2. Point out that the cube contains the dimensions shown in the fol ...