tailieunhanh - Module 3: Using MDX Expressions

In this module, students will learn how to create very simple multidimensional expressions (MDX). These are expressions that use constant values or expressions that display the names of members. Students will also learn how to work with members in a dimension and how to use MDX member functions to navigate from one member to another. | MICROSOFT TRAINING and CERTIFICATION Official Curriculum aw ions odule 3 Using MDX Contents Overview Using MDX Expressions Lab A Using Expressions from Constants Displaying Member Information Displaying Family Tree Relatives Working with Member Properties Lab B Displaying Cube Metadata Using Conditional Expressions Lab C Using Conditional Expressions Review 1 2 12 17 29 38 46 55 64 68 Microsoft 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 ActiveX Excel PowerPoint SQL Server and Visual Basic for Applications are either registered trademarks or trademarks of Microsoft Corporation in the . 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 .