Creating Simple MDX Expressions
MDX is a pseudoacronym for multidimensional expressions. MDX was created expressly for use with multidimensional OLAP data sources. MDX is used in two different ways within Microsoft SQL Server 2000 Analysis Services. First, it is a query language—the tool for retrieving reports from an OLAP cube. In other words, MDX is the tool used by client applications (such as the Microsoft Excel 2000 PivotTable report) to retrieve values. Second, MDX is an expression language—the tool used to calculate single values. For example, MDX is what you use to create calculated members in a cube or to create a dynamic default member. In this chapter, you’ll learn how to create MDX expressions based on single values. In Chapter 7 ...
Get Microsoft® SQL Server™ 2000 Analysis Services Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
