|
|
 |
Microsoft SQL Server 2000
Implementing Business Logic with MDX in Microsoft SQL Server 2000 (2093)
|
|
|
Who Should Attend
| Suitable for for developers of database client applications, including Internet and N-tiered application clients, SQL Server database developers who need to query, insert, update, or delete data from a database by using XML, and for SQL Server database administrators who need to publish SQL data as XML. |
Prerequisites
| Completion of course (2074) Designing and Implementing OLAP Solutions Using Microsoft SQL Server 2000 or equivalent knowledge |
Course Objectives
| This course provides the knowledge and and skills necessary to use multidimensional expressions (MDX) to add calculated members and other dynamically calculated values to a SQL Server 2000 Analysis Services cube by using SQL Server 2000. Students willo learn to ad 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 and use functions to aggregate values from a set of members.
|
|
|
| Participants will also learn how to 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 and apply MDX in common financial applications. |
Course Content
| 1. OLAP Review
|
| 2. MDX Foundations
|
| 3. Using MDX Expressions
|
| 4. Retrieving Values from a Cube
|
| 5. Creating Simple MDX Queries
|
| 6. Creating and Manipulating Sets
|
| 7. Using Aggregation Functions
|
| 8. Case Study - Implementing Budget Allocations
|
| 9. Using Calculated Cells |
|
|
|
|
Top