MDX with SSAS 2012 Cookbook

In this book you'll find 90 clearly written recipes to help developers advance their skills with the demanding but powerful language MDX and SQL Server Analysis Services. All leading to greatly improved business intelligence solutions.

MDX with SSAS 2012 Cookbook

Sherry Li, Tomislav Piasevoli

2 customer reviews
In this book you'll find 90 clearly written recipes to help developers advance their skills with the demanding but powerful language MDX and SQL Server Analysis Services. All leading to greatly improved business intelligence solutions.
Mapt Subscription
FREE
$30.00/m after trial
eBook
$25.20
RRP $35.99
Save 29%
Print + eBook
$59.99
RRP $59.99
What do I get with a Mapt subscription?
  • Unlimited access to all Packt’s 6,000+ eBooks and Videos
  • 100+ new titles a month, learning paths, assessments & code files
  • 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 subscription 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 subscription 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 subscription reader
$0.00
$25.20
$59.99
$29.99 p/m after trial
RRP $35.99
RRP $59.99
Subscription
eBook
Print + eBook
Start 14 Day Trial

Frequently bought together


MDX with SSAS 2012 Cookbook Book Cover
MDX with SSAS 2012 Cookbook
$ 35.99
$ 25.20
Expert Cube Development with SSAS Multidimensional Models Book Cover
Expert Cube Development with SSAS Multidimensional Models
$ 29.99
$ 21.00
Buy 2 for $35.00
Save $30.98
Add to Cart

Book Details

ISBN 139781849689601
Paperback420 pages

Book Description

MDX is the BI industry standard for multidimensional calculations and queries. Proficiency with this language is essential for the realization of your Analysis Services’ full potential. MDX is an elegant and powerful language, and also has a steep learning curve.

SQL Server 2012 Analysis Services has introduced a new BISM tabular model and a new formula language, Data Analysis Expressions (DAX). However, for the multi-dimensional model, MDX is still the only query and expression language. For many product developers and report developers, MDX is the preferred language for both the tabular model and multi-dimensional model.

MDX with SSAS 2012 Cookbook is a must-have book for anyone who wants to be proficient in the MDX language and to enhance their business intelligence solutions.

MDX with SSAS 2012 Cookbook is packed with immediately usable, practical solutions. It starts with elementary techniques that lay the foundation for designing advanced MDX calculations and queries. The discussions after each solution will provide you with a solid foundation and best practices. It covers a broad range of real-world topics and solutions and provides you with learning materials to become proficient in the language.

This book will guide you through the hands-on and practical MDX solutions, best practices, and many intricacies that hide within the MDX calculations and queries.

We will start by working with sets, creating time-aware, context-aware calculations, and business analytics solutions, through to the techniques of enhancing the cube design when MDX is not enough. We will then move on to capturing MDX generated by SSAS front-ends and using SSAS stored procedures, and we will explore the whole range of MDX solutions for real-world BI projects.

Table of Contents

What You Will Learn

  • Create time-aware calculations that are relative to the current date
  • Construct context-aware calculations that are relative to members on axes
  • Implement business-related calculations such as forecasting, allocation of values, and ABC analysis
  • Combine MDX with utility dimensions
  • Implement error handling
  • Apply AND, OR, NOT logic
  • Conditionally format your MDX calculations
  • Optimize, dissect, and debug MDX calculations and queries
  • Capture MDX generated by SSAS front-ends
  • Register SSAS-related assemblies and use stored procedures in them

Authors

Table of Contents

Book Details

ISBN 139781849689601
Paperback420 pages
Read More
From 2 reviews

Read More Reviews

Recommended for You

Expert Cube Development with SSAS Multidimensional Models Book Cover
Expert Cube Development with SSAS Multidimensional Models
$ 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
Learning SQL Server Reporting Services 2012 Book Cover
Learning SQL Server Reporting Services 2012
$ 32.99
$ 23.10
Raspberry Pi Networking Cookbook Book Cover
Raspberry Pi Networking Cookbook
$ 20.99
$ 14.70
Learning SQL Server Reporting Services 2012 Book Cover
Learning SQL Server Reporting Services 2012
$ 32.99
$ 23.10
Instant Windows 8 C++ Application Development How-to Book Cover
Instant Windows 8 C++ Application Development How-to
$ 12.99
$ 9.10