Module 12: Working with Virtual Cubes

Tham khảo tài liệu module 12: working with virtual cubes, 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 12: Working with Virtual Cubes Module 12: Working with Virtual CubesContentsOverview 1Understanding Virtual Cubes 2Obtaining Logical Results 4Building a Virtual Cube 5Lab A: Creating Virtual Cubes 10Creating Calculated Members 14Lab B: Adding Calculated Members to aVirtual Cube 16Review 19Information 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 intendedto represent any real individual, company, product, or event, unless otherwise noted. Complyingwith all applicable copyright laws is the responsibility of the user. No part of this document maybe reproduced or transmitted in any form or by any means, electronic or mechanical, for anypurpose, without the express written permission of Microsoft Corporation. If, however, your onlymeans of access is electronic, permission to print one copy is hereby granted.Microsoft may have patents, patent applications, trademarks, copyrights, or other intellectualproperty rights covering subject matter in this document. Except as expressly provided in anywritten license agreement from Microsoft, the furnishing of this document does not give you anylicense to these patents, trademarks, copyrights, or other intellectual property. 2000 Microsoft Corporation. All rights reserved.Microsoft, BackOffice, MS-DOS, Windows, Windows NT, areeither registered trademarks or trademarks of Microsoft Corporation in the U.S.A. and/or othercountries.The names of companies, products, people, characters, and/or data mentioned herein are fictitiousand are in no way intended to represent any real individual, company, product, or event, unlessotherwise noted.Other product and company names mentioned herein may be the trademarks of their respectiveowners.BETA MATERIALS FOR MICROSOFT CERTIFIED TRAINER PREPARATION PURPOSES ONLY Module 12: Working with Virtual Cubes iiiInstructor NotesPresentation: A virtual cube is an online analytical processing (OLAP) cube that combines or25 Minutes extracts data from one or more source cubes. These cubes are called virtual because they consume no disk storage, other than metadata. In this module,Labs: students learn when to use virtual cubes and the mechanics of how to build20 Minutes them in Microsoft® SQL Server™ 2000 Analysis Services. After completing this module, students will be able to: Understand when to use virtual cubes and know their benefits. ! Know the rules for constructing meaningful virtual cubes. ! Build virtual cubes by using the Virtual Cube Wizard. ! Define calculated members in virtual cubes by using the Calculated Member ! Builder.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 Microsoft PowerPoint® file 2074A_12.ppt. Preparation Tasks To prepare for this module, you should: Read all of the student materials for this module. ! Read the instructor notes and margin notes. ! 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 ONLYiv Module 12: Working with Virtual CubesOther Activities Difficult Questions Below are difficult questions that students may ask you during the delivery of this module and answers to the questions. There materials delve into subjects that are within the scope of the module but are not specifically addressed in the content of the student notes. 1. How does the enabling or disabling of levels in the source cube affect the enabling or disabling of levels in the virtual cube? Enabling or disabling levels in the source cube does not affect the enabling or disabling of levels in the virtual cube. Levels in the source cube are completely separate from levels in the virtual cube, so that, when users are using a virtual cube, they can access members for querying or for creating calculations down to the lowest level in the dimension, regardless of level enabling or disabling in the source cube. 2. Can you add a virtual dimension to a virtual cube without also adding the dimension on which the virtual dimension depends? No. When you add a virtual dimension to a virtual cube, the regular dimension is added to the virtual cube automatically. 3. Can you base virtual cubes on linked cubes? Yes. ...