Book description
Learn how to write MDX queries from SQL Server Analysis Services 2012 cubes quickly and easily
- Learn something new in an Instant! A short, fast, focused guide delivering immediate results
- Write queries, use functions, and utilize what you write in cubes and reports
- Write Calculated Members and Named Sets
- Use SSAS DMVs to document your cube
In Detail
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
-
Instant MDX Queries for SQL Server 2012
- Instant MDX Queries for SQL Server 2012
- Credits
- About the Author
- About the Reviewers
- www.packtpub.com
- packtlib.packtpub.com
-
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
Product information
- Title: Instant MDX Queries for SQL Server 2012
- Author(s):
- Release date: August 2013
- Publisher(s): Packt Publishing
- ISBN: 9781782178064
You might also like
book
Software Engineering at Google
Today, software engineers need to know not only how to program effectively but also how to …
book
Practical Tableau
Whether you have some experience with Tableau software or are just getting started, this manual goes …
book
Effective Java
The Definitive Guide to Java Platform Best Practices–Updated for Java 7, 8, and 9 Java has …
video
Python Fundamentals
51+ hours of video instruction. Overview The professional programmer’s Deitel® video guide to Python development with …