Mega Dose
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    Original Essays | September 30, 2014

    Brian Doyle: IMG The Rude Burl of Our Masks



    One day when I was 12 years old and setting off on my newspaper route after school my mom said will you stop at the doctor's and pick up something... Continue »

    spacer
Qualifying orders ship free.
$54.00
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
25 Remote Warehouse Database- Data Warehousing

Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008

by

Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008 Cover

 

Synopses & Reviews

Publisher Comments:

More than 300 ready-to-use, powerful MDX queries

Practical MDX Queries shows how to use Multi-Dimensional Expressions (MDX) to extract business intelligence from multi-dimensional cubes within Microsoft's Business Intelligence stack. The books approach is solutions-based and hands-on, containing more than 300 downloadable MDX queries that can be immediately applied across a wide variety of business intelligence-related problems. It begins with fundamental principles and simple queries and rapidly progresses to complex and sophisticated queries. The book is structured as follows:

  • Query Overview: Introduction and description of query and its use
  • Syntax: Complete syntax
  • Result: Illustrates the data returned from the Analysis Services cube by the query

  • Analysis: Analysis of the results and tips for customization

The book emphasizes MDX for use within Microsoft SQL Server Analysis Services (SSAS)however, the techniques and queries can also be used across Excel, Excel Services in SharePoint, Reporting Services (SSRS), Integration Services (SSIS), Performance Point Server dashboards, Winforms and Webforms, and in a variety of third-party front-ends.

Practical MDX Queries covers

The Basics; Dimensions and Hierarchies; Slicing and Dicing; Sorting; KPIs; Empty Cells and Ranges; Calculations and Sets; Time Dimension; Time Dimension Calculations; Families and Navigation; Set Manipulation; Problems and Common Errors

Book News Annotation:

This hands-on guide shows how to use Multi-Dimensional Expressions (MDX) to extract business intelligence from multi-dimensional cubes. It contains 300 MDX queries that can be applied to business-intelligence problems. Each query is presented in a consistent format of syntax, result, and analysis. The book emphasizes MDX for use with SSAS within SSMS, but queries also apply to SSRS, SSIS, and MDX in SQL and DMX, in addition to WinForms, WebForms, and many third-party applications. A companion web site contains source code for all queries. Readers are required to have access to the SSAS Adventure Works DW 2008 database, and the SQL Sever AdventureWorksDW2008 database, available from a web site. Tennick in a business intelligence consultant Annotation ©2010 Book News, Inc., Portland, OR (booknews.com)

Synopsis:

300+ ready-to-use, powerful MDX queries

This hands-on guide shows you how to use Multi-Dimensional Expressions (MDX) to extract business intelligence from multi-dimensional cubes. Practical MDX Queries contains more than 300 downloadable MDX queries that can be applied across a wide variety of business intelligence-related problems. The use, syntax, and results of each query are described in detail. The book emphasizes MDX for use with SSAS within SSMS, but the techniques and queries also apply to SSRS, SSIS, MDX in SQL, MDX in DMX, MDX in XMLA, WinForms, WebForms, PerformancePoint Server, ProClarity, and many third-party applications.

  • Work with dimensions, hierarchies, levels, and members
  • Navigate both horizontally and vertically across dimensions and hierarchies
  • Sort the results of your queries
  • Access subsets of dimension members and measure values using the Where clause and Filter function
  • Use MDX query calculations
  • Extract and manipulate dates and times
  • Produce totals, subtotals, and changes cross time using aggregate and other functions
  • Create, visualize, and manipulate sets
  • Work with perspectives, subselects, and subcubes
  • Display and hide empty cells
  • Use, modify, format, and create Key Performance Indicators (KPIs)
  • Deliver MDX query results to end users

About the Author

Art Tennick has worked in relational database design and SQL queries for over 20 years, and in MDX queries for 10 years. He implemented BI solutions for major retail and banking corporations using Microsoft SQL Server, SSAS, SSIS, SSRS, and Excel 2007. He has written 16 books and more than 300 articles for computer magazines in the U.S., UK, and Ireland. His web site is MrCube.net.

Table of Contents

Chapter 1. The Basics

Chapter 2. Dimensions and Hierarchies; Chapter 3. Slicing and Dicing; Chapter 4. Sorting; Chapter 5. KPIs; Chapter 6. Empty Cells and Ranges; Chapter 7. Calculations and Sets; Chapter 8. Time Dimension; Chapter 9. Time Dimension Calculations; Chapter 10. Families and Navigation; Chapter 11. Set Manipulation; Chapter 12. Problems and Common Errors

Product Details

ISBN:
9780071713368
Author:
Tennick, Art
Publisher:
McGraw-Hill/Osborne Media
Author:
Tennick Art
Subject:
Database Management - Data Warehousing
Subject:
Business intelligence
Subject:
MDX (Computer program language)
Subject:
practical, mdx, queries, arthur tennick, basics, book, guide, how to, dimensions, hierarchies, slicing, dicing, sorting, KPIs, empty, cells, ranges, calculations, business intelligence, BI, sets, time, calculations, families, navigation, set, manipulation
Subject:
practical, mdx, queries, arthur tennick, basics, book, guide, how to, dimensions, hierarchies, slicing, dicing, sorting, KPIs, empty, cells, ranges, calculations, business intelligence, BI, sets, time, calculations, families, navigation, set, manipulation
Subject:
practical, mdx, queries, arthur tennick, basics, book, guide, how to, dimensions, hierarchies, slicing, dicing, sorting, KPIs, empty, cells, ranges, calculations, business intelligence, BI, sets, time, calculations, families, navigation, set, manipulation
Subject:
practical, mdx, queries, arthur tennick, basics, book, guide, how to, dimensions, hierarchies, slicing, dicing, sorting, KPIs, empty, cells, ranges, calculations, business intelligence, BI, sets, time, calculations, families, navigation, set, manipulation
Subject:
practical, mdx, queries, arthur tennick, basics, book, guide, how to, dimensions, hierarchies, slicing, dicing, sorting, KPIs, empty, cells, ranges, calculations, business intelligence, BI, sets, time, calculations, families, navigation, set, manipulation
Subject:
practical, mdx, queries, arthur tennick, basics, book, guide, how to, dimensions, hierarchies, slicing, dicing, sorting, KPIs, empty, cells, ranges, calculations, business intelligence, BI, sets, time, calculations, families, navigation, set, manipulation
Subject:
practical, mdx, queries, arthur tennick, basics, book, guide, how to, dimensions, hierarchies, slicing, dicing, sorting, KPIs, empty, cells, ranges, calculations, business intelligence, BI, sets, time, calculations, families, navigation, set, manipulation
Subject:
practical, mdx, queries, arthur tennick, basics, book, guide, how to, dimensions, hierarchies, slicing, dicing, sorting, KPIs, empty, cells, ranges, calculations, business intelligence, BI, sets, time, calculations, families, navigation, set, manipulation
Subject:
Database-Data Warehousing
Copyright:
Publication Date:
June 2010
Binding:
TRADE PAPER
Grade Level:
Professional and scholarly
Language:
English
Illustrations:
Y
Pages:
269
Dimensions:
9.06x7.24x.61 in. 1.11 lbs.

Related Subjects

Computers and Internet » Database » Applications
Computers and Internet » Database » Database Management
Computers and Internet » Database » Design
Computers and Internet » Database » SQL
History and Social Science » US History » Social and Economic History
Science and Mathematics » Electricity » General Electronics

Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008 New Trade Paper
0 stars - 0 reviews
$54.00 In Stock
Product details 269 pages McGraw-Hill/Osborne Media - English 9780071713368 Reviews:
"Synopsis" by ,

300+ ready-to-use, powerful MDX queries

This hands-on guide shows you how to use Multi-Dimensional Expressions (MDX) to extract business intelligence from multi-dimensional cubes. Practical MDX Queries contains more than 300 downloadable MDX queries that can be applied across a wide variety of business intelligence-related problems. The use, syntax, and results of each query are described in detail. The book emphasizes MDX for use with SSAS within SSMS, but the techniques and queries also apply to SSRS, SSIS, MDX in SQL, MDX in DMX, MDX in XMLA, WinForms, WebForms, PerformancePoint Server, ProClarity, and many third-party applications.

  • Work with dimensions, hierarchies, levels, and members
  • Navigate both horizontally and vertically across dimensions and hierarchies
  • Sort the results of your queries
  • Access subsets of dimension members and measure values using the Where clause and Filter function
  • Use MDX query calculations
  • Extract and manipulate dates and times
  • Produce totals, subtotals, and changes cross time using aggregate and other functions
  • Create, visualize, and manipulate sets
  • Work with perspectives, subselects, and subcubes
  • Display and hide empty cells
  • Use, modify, format, and create Key Performance Indicators (KPIs)
  • Deliver MDX query results to end users

spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.