Skip to Main Content
Microsoft® SQL Server® 2008 Analysis Services Step by Step
book

Microsoft® SQL Server® 2008 Analysis Services Step by Step

by Scott Cameron
April 2009
Beginner content levelBeginner
448 pages
14h 1m
English
Microsoft Press
Content preview from Microsoft® SQL Server® 2008 Analysis Services Step by Step

Creating MDX Queries

An MDX query is different from an MDX expression. An expression is a formula that calculates a single value. A query is a command that can retrieve many values from a cube, usually to create a report. The cube browser in the Cube Designer, like other reporting and data visualization applications used with Analysis Services, allows you to drag and drop dimensions and measures and generates MDX queries behind the scenes to retrieve values from a cube. You can use these tools to create reports without writing any MDX queries of your own. So why should you learn how to create an MDX query? Learning MDX will allow you to take advantage of some of the more advanced features of Analysis Services to create exactly the dataset you ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® SQL Server™ 2008 Analysis Services Unleashed

Microsoft® SQL Server™ 2008 Analysis Services Unleashed

Irina Gorbach, Alexander Berger, Edward Melomed
Microsoft® SQL Server™ 2005 Analysis Services Step by Step

Microsoft® SQL Server™ 2005 Analysis Services Step by Step

Reed Jacobsen, Stacia Misner, Hitachi Consulting

Publisher Resources

ISBN: 9780735626201Supplemental ContentCatalog PageErrata