Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008

3.76 avg rating
( 21 ratings by Goodreads )
 
9780071713368: Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008
View all copies of this ISBN edition:
 
 

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

International Edition
International Edition

1.

Art Tennick
ISBN 10: 0071713360 ISBN 13: 9780071713368
New Softcover First Edition Quantity Available: 1
International Edition
Seller:
LowPriceBookDeals
(Wilmington, DE, U.S.A.)
Rating
[?]

Book Description Softcover. Condition: New. 1st edition.. Brand NEW, Paperback International Edition. Black & White or color, Cover and ISBN may be different but similar contents as US editions. Standard delivery takes 5-9 business days by USPS/DHL with tracking number. Choose expedited shipping for superfast delivery 3-5 business days by UPS/DHL/FEDEX. We also ship to PO Box addresses but by Standard delivery and shipping charges will be extra. International Edition Textbooks may bear a label -Not for sale in the U.S. or Canada- etc. printed only to discourage U.S. students from obtaining an affordable copy. Legal to use despite any disclaimer on cover as per US court. No access code or CD included unless specified. In some instances, the international textbooks may have different exercises at the end of the chapters. Printed in English. We may ship the books from multiple warehouses across the globe, including India depending upon the availability of inventory storage. In case of orders from Europe, custom charges may comply by the relevant government authority and we are not liable for it. 100% Customer satisfaction guaranteed! Please feel free to contact us for any queries. Seller Inventory # ABE758

More information about this seller | Contact this seller

Buy New
US$ 23.49
Convert Currency

Add to Basket

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

2.

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

Book Description McGraw-Hill Education. PAPERBACK. Condition: New. 0071713360 Fast handling - Orders prepared for Shipping Next Business Day!. Seller Inventory # RJ-PBO-44034C

More information about this seller | Contact this seller

Buy New
US$ 23.50
Convert Currency

Add to Basket

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

3.

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

Book Description McGraw-Hill Education, 2010. Condition: New. book. Seller Inventory # MB010EUW13E

More information about this seller | Contact this seller

Buy New
US$ 27.54
Convert Currency

Add to Basket

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

4.

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. Condition: New. New Book.Shipped from US within 10 to 14 business days. Established seller since 2000. Seller Inventory # IB-9780071713368

More information about this seller | Contact this seller

Buy New
US$ 32.21
Convert Currency

Add to Basket

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

5.

Tennick, Art
Published by McGraw-Hill Education
ISBN 10: 0071713360 ISBN 13: 9780071713368
New PAPERBACK Quantity Available: 1
Seller:
BookShop4U
(PHILADELPHIA, PA, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education. PAPERBACK. Condition: New. 0071713360. Seller Inventory # Z0071713360ZN

More information about this seller | Contact this seller

Buy New
US$ 39.03
Convert Currency

Add to Basket

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

6.

Tennick, Art
Published by McGraw-Hill Education
ISBN 10: 0071713360 ISBN 13: 9780071713368
New PAPERBACK Quantity Available: 1
Seller:
Bookhouse COM LLC
(Philadelphia, PA, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education. PAPERBACK. Condition: New. 0071713360. Seller Inventory # Z0071713360ZN

More information about this seller | Contact this seller

Buy New
US$ 39.03
Convert Currency

Add to Basket

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

7.

Tennick, Art
Published by McGraw-Hill Education
ISBN 10: 0071713360 ISBN 13: 9780071713368
New PAPERBACK Quantity Available: 1
Seller:
Vital Products COM LLC
(Southampton, PA, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education. PAPERBACK. Condition: New. 0071713360. Seller Inventory # Z0071713360ZN

More information about this seller | Contact this seller

Buy New
US$ 39.03
Convert Currency

Add to Basket

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

8.

Tennick, Art
Published by McGraw-Hill Education
ISBN 10: 0071713360 ISBN 13: 9780071713368
New PAPERBACK Quantity Available: 1
Seller:
Best Bates
(Bensalem, PA, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education. PAPERBACK. Condition: New. 0071713360. Seller Inventory # Z0071713360ZN

More information about this seller | Contact this seller

Buy New
US$ 39.03
Convert Currency

Add to Basket

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

9.

Tennick, Art
Published by McGraw-Hill Education
ISBN 10: 0071713360 ISBN 13: 9780071713368
New PAPERBACK Quantity Available: 1
Seller:
Mega Buzz
(Bensalem, PA, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education. PAPERBACK. Condition: New. 0071713360. Seller Inventory # Z0071713360ZN

More information about this seller | Contact this seller

Buy New
US$ 39.03
Convert Currency

Add to Basket

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

10.

Tennick, Art
Published by McGraw-Hill Education
ISBN 10: 0071713360 ISBN 13: 9780071713368
New PAPERBACK Quantity Available: 1
Seller:
Booklot COM LLC
(Philadelphia, PA, U.S.A.)
Rating
[?]

Book Description McGraw-Hill Education. PAPERBACK. Condition: New. 0071713360. Seller Inventory # Z0071713360ZN

More information about this seller | Contact this seller

Buy New
US$ 39.03
Convert Currency

Add to Basket

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

There are more copies of this book

View all search results for this book