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.
When used with the MDX query language, SQL Server Analysis Services allows developers to build full-scale database applications to support such business functions as budgeting, forecasting, and market analysis.
Shows readers how to build data warehouses and multi-dimensional databases, query databases, and use Analysis Services and other components of SQL Server to provide end-to-end solutions
In this module, students will learn how to create simple multidimensional
expression (MDX) query statements that generate a report. Students will learn
the terminology that is used to create a query, and then they will be introduced
to an interface that can be used to process a query and create a report. Finally,
students will learn about different types of simple query statements and how to
Multiple values retrieved from a set can be summarizedor aggregatedinto
a single value that can be used in a calculated member. Some of the most useful
analytical formulas created by using multidimensional expressions (MDX)
come from aggregating sets of values. In this module, students learn how to use
aggregation functions to create formulas.
This module provides students an overview of multidimensional expressions
(MDX), foundations in object and member naming conventions, instructions on
how to use the Calculated Member Builder interface, and a review of the
characteristics of calculated members.
In this module, students learn how to work with calculated cells in Microsoft®
SQL Server 2000 Analysis Services. Calculated cells are a method of
applying multidimensional expressions (MDX) in an extremely sophisticated
fashion within a cube. In addition, the module reviews how calculated cells
differ from calculated members and custom member formulas.
Part I Getting Started with Analysis Services
1 Understanding Business Intelligence and Data Warehousing
2 Understanding OLAP and Analysis Services
3 Building Your First Cube
Part II Design Fundamentals
4 Designing Dimensions
5 Designing Measure Groups and Measures
6 Working with a Finance Measure Group