Instant MDX Queries for SQL Server 2012 [Instant]


This title is available as an eBook only
Instant MDX Queries for SQL Server 2012 [Instant]
eBook: $19.99
Formats: PDF, PacktLib, ePub and Mobi formats
$16.99
save 15%!
Print & eBook also available on:
Learn in an Instant - Short, Fast, Focused
Overview
Table of Contents
Author
Support
Sample Chapters
  • 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

Book Details

Language : English
eBook : 54 pages
Release Date : August 2013
ISBN : 1782178066
ISBN 13 : 9781782178064
Author(s) : Nicholas Emond
Topics and Technologies : All Books, Big Data and Business Intelligence, Instant, Microsoft Servers, Enterprise

Table of Contents

Instant MDX Queries for SQL Server 2012
  • Instant MDX Queries for SQL Server 2012
    • So, what is MDX for SQL Server 2012?
    • Installation
      • Step 1 – identify which edition to use
        • The Developer edition
        • The Evaluation edition
        • 32-bit or 64-bit
      • Step 2 – review the requirements
      • Step 3 – downloading the SQL Server 2012 trial edition
      • Step 4 – installing the SQL Server 2012
      • Step 5 – installing the Data Warehouse
      • Step 6 – installing the multidimensional models
      • And that's it
    • Quick start – writing your first MDX query
      • Step 1 – open the SQL Server Management Studio and connect to the cube
      • Step 2 – SELECT
        • Axes
        • Tuples
        • Sets
      • Step 3 – FROM
      • Step 4 – WHERE
      • Step 5 – comments
      • Step 6 – your first MDX query
    • Top 4 features you'll want to know about
      • Using functions
        • Basic keywords and functions
        • It's all in the family
        • Can you spare the time?
      • Using Calculated Members and Named Sets
        • Calculated Members
        • Named Sets
      • Calculations
        • The calculation tab
        • Add a new Calculated Member
        • Add a new Named Set
      • Writing for SSRS
        • Create a Report Project
        • Create a new report
        • Create a data source
        • Create a dataset
        • Create a table
        • The Months parameter
      • DMVs
    • People and places you should get to know
      • Official Sites
      • Articles and Tutorials
      • Blogs
      • Twitter

Nicholas Emond

Nicholas Emond has been working in Information Technologies for the last eleven years. His past jobs were as a programmer with VB.NET, administrator of a corporate SharePoint intranet and business intelligence developer when he started to use the Microsoft BI stack since SQL Server 2005. Currently, he is a business intelligence consultant working in Montreal, Canada. Nicholas has certifications in Microsoft SQL Server and Microsoft SharePoint and he is a Competent Communicator from Toastmasters International. He likes to read books on computing and personal growth. MDX Queries for SQL Server 2012 Starter is the first book written by Nicholas Emond, and it won't be his last.
Sorry, we don't have any reviews for this title yet.

Submit Errata

Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

Sorry, there are currently no downloads available for this title.

Frequently bought together

Instant MDX Queries for SQL Server 2012 [Instant] +    Getting Started with Talend Open Studio for Data Integration =
50% Off
the second eBook
Price for both: £20.45

Buy both these recommended eBooks together and get 50% off the cheapest eBook.

What you will learn from this book

  • 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

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.

Approach

Get to grips with a new technology, understand what it is and what it can do for you, and then get to work with the most important features and tasks. This short, focused guide is a great way to get stated with writing MDX queries. New developers can use this book as a reference for how to use functions and the syntax of a query as well as how to use Calculated Members and Named Sets.

Who this book is for

This book is great for new developers who want to learn the MDX query language from scratch and install SQL Server 2012 with Analysis Services.

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software