Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008
List Price:
$70.00
- Availability: Confirm prior to ordering
- Branding: minimum 50 pieces (add’l costs below)
- Check Freight Rates (branded products only)
Branding Options (v), Availability & Lead Times
- 1-Color Imprint: $2.00 ea.
- Promo-Page Insert: $2.50 ea. (full-color printed, single-sided page)
- Belly-Band Wrap: $2.50 ea. (full-color printed)
- Set-Up Charge: $45 per decoration
- Availability: Product availability changes daily, so please confirm your quantity is available prior to placing an order.
- Branded Products: allow 10 business days from proof approval for production. Branding options may be limited or unavailable based on product design or cover artwork.
- Unbranded Products: allow 3-5 business days for shipping. All Unbranded items receive FREE ground shipping in the US. Inquire for international shipping.
- RETURNS/CANCELLATIONS: All orders, branded or unbranded, are NON-CANCELLABLE and NON-RETURNABLE once a purchase order has been received.
Product Details
Author:
Art Tennick
Format:
Paperback
Publisher:
McGraw Hill LLC (June 14, 2010)
Audience:
General/trade
ISBN-13:
9780071713368
ISBN-10:
0071713360
Weight:
17.92oz
Dimensions:
7.4" x 9.1" x 0.61"
Case Pack:
24
File:
McGrawHill-MH_ONIX_V30_US_onix30_all(26_05_26)-20260526.xml
Folder:
McGrawHill
As low as:
$53.90
List Price:
$70.00
Publisher Identifier:
P-MCGRAW
Discount Code:
A
Pages:
304
Pub Discount:
55
Imprint:
McGraw Hill
Overview
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
