Xem mẫu

Module 7: Case Study—Creating the Store Expense Cube Contents Overview 1 Building the Store Expense Cube 2 Lab A: Building the Store Expense Cube 7 Updating the Store Expense Cube 12 Lab B: Modifying the Store Expense Cube 13 Review 20 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 7: Case Study—Creating the Store Expense Cube iii Instructor Notes Presentation: 30 Minutes Labs: 60 Minutes In this module, students apply concepts they have learned in modules 1 through 6 in course 2074A, Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000. Students will use various cube and dimension techniques to build an online analytical processing (OLAP) cube for store expenses by using Microsoftfi 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 then must 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. !✂Update dimensions and add new dimensions to a cube. Materials and Preparation This section provides the required materials and preparation tasks that are needed to teach this module. Required Materials To teach this module, you need the following materials: !✂Microsoft PowerPointfi file 2074A_07.ppt Preparation Tasks To prepare for this module, you should: !✂Read all of the student materials. !✂Read the instructor notes and margin notes. !✂Complete all of the demonstrations. !✂Practice the lecture presentation and demonstrations. !✂Complete the labs. !✂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 7: Case Study—Creating the Store Expense Cube Demonstration: Reviewing Lab A Demonstration: 10 Minutes 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 are 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, find and click the file C:\Moc\2074A\Labfiles\L07\Answers\Module 07A.CAB, click Open, and then click Restore. 2. Expand the Module 07A database, double-click the Data Sources folder, right-click the Module 07 data source, and then click Edit. 3. Verify that localhost is selected in step 1 and that Module 07 is selected in step 3. Click OK. ! To view the Store Expense cube 1. Expand the Cubes folder, right-click Store Expense, and then click Edit. 2. Point out that the cube contains the dimensions shown in the following table. Dimension Scenario Time Store Store Manager Account Department Dimension type Shared Private Shared Private Shared Shared 3. Mention that the in real-world OLAP databases, Time dimensions usually are defined as shared dimensions used within multiple cubes. The lab contains a private Time dimension to challenge students by presenting a different method for creating a Time dimension. 4. Highlight the fact that the cube contains one measure—Amount. 5. Drill down on each dimension and verify that students have the correct number of levels in each dimension and that the levels are in the correct order. 6. Drill down on the Account dimension and verify that students have the correct members in the correct order. 7. Save the Store Expense cube and close the Cube Editor. BETA MATERIALS FOR MICROSOFT CERTIFIED TRAINER PREPARATION PURPOSES ONLY Module 7: Case Study—Creating the Store Expense Cube v Demonstration: Reviewing Lab B Demonstration: 10 Minutes In this demonstration, you will view and discuss the solutions of lab B. The following demonstration procedures provide information that will not fit in the margin notes or are 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, find and click the file C:\Moc\2074A\Labfiles\L07\Answers\Module 07B.CAB, click Open, and then click Restore. 2. Expand the Module 07B database, double-click the Data Sources folder, right-click the Module 07 data source, and then click Edit. 3. Verify that localhost is selected in step 1 and that Module 07 is selected in step 3. Click OK. ! To view the Store Expense cube 1. Expand the Cubes folder, right-click Store Expense, and then click Edit. 2. Point out that the cube contains the dimensions shown in the following table. Dimension Scenario Time Store Store Manager Account Department Store Type Dimension type Shared Private Shared Private Shared Shared Virtual 3. Browse the cube, and notice the Scenario dimension. The Scenario dimension does not contain the All Scenario member. 4. Notice the Time dimension. It does not contain the All Time member. 5. Pivot the Store dimension to the row area in the browser. 6. Double-click the Store Country level heading, double-click the Store State level heading, and notice that the Mexico state is hidden. 7. Drill down to the Store Name level and notice the names of the stores. They contain both the city name and the store name. 8. Browse the Store Manager dimension, and notice the First Letter level that groups the store managers by the first letter of their names. 9. In the Store Manager dimension, notice that no null member names exist at the First Letter level. All null member names are hidden. BETA MATERIALS FOR MICROSOFT CERTIFIED TRAINER PREPARATION PURPOSES ONLY ... - tailieumienphi.vn
nguon tai.lieu . vn