Instant MDX Queries for SQL Server 2012

Learn how to write MDX queries from SQL Server Analysis Services 2012 cubes quickly and easily
Preview in Mapt
Code Files

Instant MDX Queries for SQL Server 2012

Nicholas Emond

Learn how to write MDX queries from SQL Server Analysis Services 2012 cubes quickly and easily
Mapt Subscription
FREE
$29.99/m after trial
eBook
$14.00
RRP $19.99
Save 29%
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$14.00
$29.99p/m after trial
RRP $19.99
Subscription
eBook
Start 30 Day Trial

Frequently bought together


Instant MDX Queries for SQL Server 2012 Book Cover
Instant MDX Queries for SQL Server 2012
$ 19.99
$ 14.00
Instant Microsoft SQL Server Analysis Services 2012 Dimensions and Cube Book Cover
Instant Microsoft SQL Server Analysis Services 2012 Dimensions and Cube
$ 14.99
$ 10.50
Buy 2 for $24.50
Save $10.48
Add to Cart
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 

Book Details

ISBN 139781782178064
Paperback54 pages

Book Description

MDX is a query language that is used to retrieve data inside Microsoft SQL Server Analysis Services cubes. With MDX, you can display the elements of your cube like attributes and hierarchies from your dimensions, measures from your fact tables, calculations, and KPIs.

This book will help you to understand the MDX query language, write your own MDX queries to display data from your cubes in the way you want, and display the results in Management Studio or in a Reporting Services report.

Instant MDX Query for SQL Server 2012 starts by showing you how to write MDX queries and takes you all the way to integrating your MDX queries into SSRS and retrieving documentation data easily on your cubes.

After you have followed the steps to install SQL Server 2012 with Analysis Services, you will learn how to write MDX queries. Once you understand the basic syntax of a query, you will then learn how to use calculated measures and named sets to reuse your code. MDX functions will help you filter, order, and combine results. Once you have mastered how to write calculated measures and named sets, you will then learn how to add them into your cube to reuse them.Displaying the results in Management Studio won’t be enough, so you will also learn how to write MDX queries in Reporting Services reports.

Table of Contents

Chapter 1: Instant MDX Queries for SQL Server 2012
So, what is MDX for SQL Server 2012?
Installation
Quick start – writing your first MDX query
Top 4 features you'll want to know about
People and places you should get to know

What You Will Learn

  • Write a basic MDX query
  • Install SQL Server 2012 with Analysis Services
  • Use MDX functions
  • Define Calculated Members and Named Sets
  • Write Calculated Members and Named Sets in a cube to reuse them later
  • Write MDX in SSRS
  • Use DMVs to document your cube

Authors

Table of Contents

Chapter 1: Instant MDX Queries for SQL Server 2012
So, what is MDX for SQL Server 2012?
Installation
Quick start – writing your first MDX query
Top 4 features you'll want to know about
People and places you should get to know

Book Details

ISBN 139781782178064
Paperback54 pages
Read More

Read More Reviews

Recommended for You

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook Book Cover
Microsoft SQL Server 2012 Integration Services: An Expert Cookbook
$ 26.99
$ 18.90
PowerShell for SQL Server Essentials Book Cover
PowerShell for SQL Server Essentials
$ 17.99
$ 12.60
Mastering SQL Server 2014 Data Mining Book Cover
Mastering SQL Server 2014 Data Mining
$ 29.99
$ 21.00
SQL Server Analysis Services 2012 Cube Development Cookbook Book Cover
SQL Server Analysis Services 2012 Cube Development Cookbook
$ 35.99
$ 25.20
MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook Book Cover
MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook
$ 29.99
$ 21.00
Expert Cube Development with SSAS Multidimensional Models Book Cover
Expert Cube Development with SSAS Multidimensional Models
$ 29.99
$ 21.00