Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008 (Database & ERP - OMG)

3.71 avg rating
( 17 ratings by Goodreads )
 
9780071713368: Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008 (Database & ERP - OMG)

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

"synopsis" may belong to another edition of this title.

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 has been involved in multi-dimensional database design, cubes, data mining, DMX, and MDX for 10 years. Recently, Art worked with several major retail and banking corporations to implement BI solutions using Microsoft SQL Server, SSAS, SSIS, SSRS, and Excel 2007/2010. His website is www.MrCube.net.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Tennick, Art
Published by McGraw-Hill Education
ISBN 10: 0071713360 ISBN 13: 9780071713368
New PAPERBACK Quantity Available: 3
Seller
Gonia Books
(Pleasant View, TN, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education. PAPERBACK. Book Condition: New. 0071713360. Bookseller Inventory # RJ-PBO-41165-MC

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 12.18
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

2.

Art Tennick
Published by McGraw-Hill Education (2010)
ISBN 10: 0071713360 ISBN 13: 9780071713368
New Paperback Quantity Available: 1
Seller
Irish Booksellers
(Rumford, ME, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education, 2010. Paperback. Book Condition: New. book. Bookseller Inventory # 0071713360

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 23.90
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds
International Edition
International Edition

3.

TENNICK
ISBN 10: 0071713360 ISBN 13: 9780071713368
New Soft cover Quantity Available: > 20
International Edition
Seller
University Bookstore
(DELHI, DELHI, India)
Rating
[?]

Book Description 2010. Soft cover. Book Condition: New. This book is BRAND NEW Soft cover International edition with black and white printing. ISBN number & cover page may be different but contents identical to the US edition word by word. Book is in English language. Bookseller Inventory # UN-TM-IN-166

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 13.18
Convert Currency

Add to Basket

Shipping: US$ 11.18
From India to U.S.A.
Destination, Rates & Speeds

4.

Arthur Tennick
ISBN 10: 0071713360 ISBN 13: 9780071713368
New Quantity Available: 1
Seller
Castle Rock
(Pittsford, NY, U.S.A.)
Rating
[?]

Book Description Book Condition: Brand New. Book Condition: Brand New. Bookseller Inventory # 97800717133681.0

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 28.92
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

5.

Art Tennick
Published by McGraw-Hill Education - Europe, United States (2010)
ISBN 10: 0071713360 ISBN 13: 9780071713368
New Paperback Quantity Available: 1
Seller
The Book Depository US
(London, United Kingdom)
Rating
[?]

Book Description McGraw-Hill Education - Europe, United States, 2010. Paperback. Book Condition: New. 238 x 192 mm. Language: English . Brand New Book. 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.You can: 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 across 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); and deliver MDX query results to end users. Bookseller Inventory # AA39780071713368

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 35.64
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

6.

Tennick, Art
ISBN 10: 0071713360 ISBN 13: 9780071713368
New Quantity Available: > 20
Seller
Pbshop
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description 2010. PAP. Book Condition: New. New Book.Shipped from US within 10 to 14 business days. Established seller since 2000. Bookseller Inventory # IB-9780071713368

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 31.89
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

7.

Art Tennick
Published by McGraw-Hill Education - Europe, United States (2010)
ISBN 10: 0071713360 ISBN 13: 9780071713368
New Paperback Quantity Available: 1
Seller
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description McGraw-Hill Education - Europe, United States, 2010. Paperback. Book Condition: New. 238 x 192 mm. Language: English . Brand New Book. 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.You can: 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 across 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); and deliver MDX query results to end users. Bookseller Inventory # AA39780071713368

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 36.89
Convert Currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, Rates & Speeds

8.

Tennick, Art
ISBN 10: 0071713360 ISBN 13: 9780071713368
New Paperback Quantity Available: > 20
Seller
BargainBookStores
(Grand Rapids, MI, U.S.A.)
Rating
[?]

Book Description Paperback. Book Condition: New. Bookseller Inventory # 814101

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 33.97
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

9.

Tennick, Art
Published by McGraw-Hill Education (2010)
ISBN 10: 0071713360 ISBN 13: 9780071713368
New Quantity Available: 6
Seller
Books2Anywhere
(Fairford, GLOS, United Kingdom)
Rating
[?]

Book Description McGraw-Hill Education, 2010. PAP. Book Condition: New. New Book. Shipped from UK in 4 to 14 days. Established seller since 2000. Bookseller Inventory # CM-9780071713368

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 28.77
Convert Currency

Add to Basket

Shipping: US$ 11.45
From United Kingdom to U.S.A.
Destination, Rates & Speeds

10.

Art Tennick
Published by McGraw-Hill Osborne Media (2010)
ISBN 10: 0071713360 ISBN 13: 9780071713368
New Paperback Quantity Available: 1
Seller
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Osborne Media, 2010. Paperback. Book Condition: New. 1. Bookseller Inventory # DADAX0071713360

More Information About This Seller | Ask Bookseller a Question

Buy New
US$ 36.67
Convert Currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, Rates & Speeds

There are more copies of this book

View all search results for this book