Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008

Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008
Author :
Publisher : McGraw Hill Professional
Total Pages : 300
Release :
ISBN-10 : 9780071713375
ISBN-13 : 0071713379
Rating : 4/5 (379 Downloads)

Book Synopsis Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008 by : Art Tennick

Download or read book Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008 written by Art Tennick and published by McGraw Hill Professional. This book was released on 2010-07-29 with total page 300 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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


Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008 Related Books

Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008
Language: en
Pages: 300
Authors: Art Tennick
Categories: Computers
Type: BOOK - Published: 2010-07-29 - Publisher: McGraw Hill Professional

GET EBOOK

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
Professional Microsoft SQL Server Analysis Services 2008 with MDX
Language: en
Pages: 1058
Authors: Sivakumar Harinath
Categories: Computers
Type: BOOK - Published: 2011-01-31 - Publisher: John Wiley & Sons

GET EBOOK

When used with the MDX query language, SQL Server Analysis Services allows developers to build full-scale database applications to support such business functio
Microsoft SQL Server 2008 MDX Step by Step
Language: en
Pages: 565
Authors: Bryan Smith
Categories:
Type: BOOK - Published: 2009-02-25 - Publisher: Pearson Education

GET EBOOK

Teach yourself the Multidimensional Expressions (MDX) query language—one step at a time. With this practical, learn-by-doing tutorial, you’ll build the core
Practical SQL Queries for Microsoft SQL Server 2008 R2
Language: en
Pages: 336
Authors: Art Tennick
Categories: Computers
Type: BOOK - Published: 2010-11-05 - Publisher: McGraw Hill Professional

GET EBOOK

400+ ready-to-use, powerful SQL queries Learn powerful techniques for surfacing and delivering actionable business intelligence using SQL. Practical SQL Queries
Tabular Modeling in Microsoft SQL Server Analysis Services
Language: en
Pages: 1001
Authors: Marco Russo
Categories: Computers
Type: BOOK - Published: 2017-04-12 - Publisher: Microsoft Press

GET EBOOK

Build agile and responsive business intelligence solutions Create a semantic model and analyze data using the tabular model in SQL Server 2016 Analysis Services