Tài liệu Module 18: Case Study Working with the Foodmart Database ppt

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

Module 18: Case

StudyóWorking with

the Foodmart Database

BETA MATERIALS FOR MICROSOFT CERTIFIED TRAINER PREPARATION PURPOSES ONLY

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, <plus other appropriate product

names or titles. Replace this example list with list of trademarks provided by copy editor.

Microsoft is listed first, followed by all other Microsoft trademarks in alphabetical order. > are

either registered trademarks or trademarks of Microsoft Corporation in the U.S.A. and/or other

countries.

<This is where mention of specific, contractually obligated to, third party trademarks, which are

added by the Copy Editor>

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.

Module 18: Case StudyóWorking with the Foodmart Database iii

BETA MATERIALS FOR MICROSOFT CERTIFIED TRAINER PREPARATION PURPOSES ONLY

Instructor Notes

In this module, students apply concepts they have learned in modules 1 through

17 in the course 2074A, Designing and Implementing OLAP Solutions Using

MicrosoftÆ SQL Serverô 2000. Students will use various cube and dimension

techniques to build cubes from the Foodmart 2000 database by using

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.

Presentation:

60 Minutes

Labs:

120 Minutes

iv Module 18: Case StudyóWorking with the Foodmart Database

BETA MATERIALS FOR MICROSOFT CERTIFIED TRAINER PREPARATION PURPOSES ONLY

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 following

table.

Dimension Dimension type

Product Shared

Time Shared

Warehouse Shared

Store Shared

First Opened Year Private

3. Highlight the fact that the cube contains the following measures:

• Units Ordered

• Units Shipped

• Warehouse Sales

• Warehouse Cost

• Maximum Supply Time

4. 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.

5. Drill down on the First Opened Year dimension and verify that students

have the correct expression in the Member Key Column and the Member

Name Column for the level.

Module 18: Case StudyóWorking with the Foodmart Database v

BETA MATERIALS FOR MICROSOFT CERTIFIED TRAINER PREPARATION PURPOSES ONLY

6. Click the Maximum Supply Time measure, and verify that students use the

Max Aggregate Function to define the measure.

7. Edit each of the three calculated members, and verify that students use the

correct expressions to define each calculated member.

8. Close the Cube Editor.

9. Expand the Warehouse cube, expand the Partitions folder, and verify that

students have two partitions defined in the cube: one partition for 1998

inventory data and one for 1997 inventory data.