MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook

80 recipes for enriching your Business Intelligence solutions with high-performance MDX calculations and flexible MDX queries with Microsoft SQL Server 2008 R2 Analysis Services with this book and eBook

MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook

Tomislav Piasevoli

80 recipes for enriching your Business Intelligence solutions with high-performance MDX calculations and flexible MDX queries with Microsoft SQL Server 2008 R2 Analysis Services with this book and eBook
Mapt Subscription
FREE
$29.99/m after trial
eBook
$10.00
RRP $29.99
Save 66%
Print + eBook
$49.99
RRP $49.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 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
$10.00
$49.99
$29.99 p/m after trial
RRP $29.99
RRP $49.99
Subscription
eBook
Print + eBook
Start 14 Day Trial

Frequently bought together


MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook Book Cover
MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook
$ 29.99
$ 10.00
Microsoft SQL Server 2008 R2 Administration Cookbook Book Cover
Microsoft SQL Server 2008 R2 Administration Cookbook
$ 32.99
$ 10.00
Buy 2 for $20.00
Save $42.98
Add to Cart

Book Details

ISBN 139781849681308
Paperback480 pages

Book Description

Microsoft SQL Server is an enterprise database platform that contains a multitude of technologies, Analysis Services being one of them. SQL Server Analysis Services (SSAS) provides OLAP and data mining capabilities and allows users to analyze multidimensional data stored in cubes using the MDX query language.

This cookbook contains over 80 practical, task-based recipes that show how Microsoft SQL Server 2008 R2 Analysis Services solutions can be taken further by enriching them with high-performance MDX calculations and flexible MDX queries.

Packed with immediately usable, real-world recipes, the book starts with elementary techniques that lay the foundation for designing further MDX calculations and queries. Here you will find topics such as iterations on a set, Boolean logic, and dissecting and optimizing MDX calculations.

In the first half of the book you will learn how to efficiently work with time, strings, metadata, calculated members and sets in general, and how to implement MDX solutions that are appropriate in a particular context: a time-aware calculation, a concise report, a calculation relative to another. You will also learn how to implement various types of conditional formatting, how to perform typical MDX calculations like ranks, percentages and averages, and year-to-date calculations.

The book then deep dives into topics such as enhancing cube design with utility dimensions, context-aware calculations, and other advanced topics. In this part you will learn how a utility dimension can be of great help, for example when you want to calculate histograms or implement time-based calculations. The advanced topics also cover parent-child hierchies, recursion, random values, and complex sorts.

Table of Contents

What You Will Learn

  • Create time-aware calculations (relative to the current date)
  • Create context-aware calculations (relative to members on axes)
  • Implement business-related calculations like forecasting, allocation of values and ABC analysis
  • Calculate various percentages, averages, and ranks
  • Work with related members (on the same and other dimensions)
  • Combine MDX with utility dimensions
  • Implement error handling
  • Implement 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 139781849681308
Paperback480 pages
Read More

Read More Reviews

Recommended for You

Microsoft SQL Server 2008 R2 Administration Cookbook Book Cover
Microsoft SQL Server 2008 R2 Administration Cookbook
$ 32.99
$ 10.00
SQL Server 2012 with PowerShell V3 Cookbook Book Cover
SQL Server 2012 with PowerShell V3 Cookbook
$ 35.99
$ 10.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.00
Instant RubyMotion App Development Book Cover
Instant RubyMotion App Development
$ 14.99
$ 10.00
Drupal: Creating Blogs, Forums, Portals, and Community Websites Book Cover
Drupal: Creating Blogs, Forums, Portals, and Community Websites
$ 23.99
$ 10.00
IBM Cognos Business Intelligence 10.1 Dashboarding Cookbook Book Cover
IBM Cognos Business Intelligence 10.1 Dashboarding Cookbook
$ 29.99
$ 10.00