2093 - Implementing Business Logic with MDX in Microsoft SQL Server 2000
Prerequisites:
Course Description: Objectives: Understand and use multidimensional terminology Add calculated members to a cube Use MDX member functions to navigate within a hierarchy Use MDX time functions to compare values over time Use MDX set functions in a query statement Use functions to manipulate sets of members Use functions to aggregate values from a set of members Apply MDX to make a cube change dynamically Calculate formulas for specific blocks of cells Control the order of calculations within a cube Apply MDX in common customer and sales applications Apply MDX in common financial applications Lesson 1: OLAP Review OLAP Databases OLAP Definitions Warehouse Data Flow Lesson 2: MDX Foundations The Role of MDX MDX Member Names Using the Calculated Member Builder Working with Calculated Members Lesson 3: Using MDX Expressions |