Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008

Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008, 9780071713368 (0071713360), McGraw-Hill, 2010

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

Comments

Amazing Books

The Flagellar World: Electron Microscopic Images of Bacterial Flagella and Related Surface Structures

Academic Press, 2014

The Flagellar World is a unique publication. The product of years of research and data collection by the author, this book is a pictorial guide to flagella in a variety of organisms. Each EM image is accompanied by a short description of the system in each organism. These never-before-seen pictures represent a wide variety of flagella,...

The Chief: The Life and Turbulent Times of Chief Justice John Roberts

Basic Books, 2019

An incisive biography of the Supreme Court's enigmatic Chief Justice, taking us inside the momentous legal decisions of his tenure so far

John Roberts was named to the Supreme Court in 2005 claiming he would act as a neutral umpire in deciding cases. His critics argue he has been anything but,...

Access 2007 VBA Bible: For Data-Centric Microsoft Office Applications

John Wiley & Sons, 2007

Learn how to tap the full potential of Access 2007 Transfer Access data seamlessly between Microsoft Office applications—and that's just for starters. In this all-new, comprehensive guide by well-known Access expert Helen Feddema, you’ll learn to write Visual Basic code that automates Access database tasks, creates standalone...

Database Benchmarking and Stress Testing: An Evidence-Based Approach to Decisions on Architecture and Technology

Apress, 2018

Provide evidence-based answers that can be measured and relied upon by your business. Database administrators will be able to make sound architectural decisions in a fast-changing landscape of virtualized servers and container-based solutions based on the empirical method presented in this book for answering “what if”...

Evolution of Physics

Touchstone, 1967

BEFORE you begin reading, you rightly expect some simple questions to be answered. For what purpose has this book been written? Who is the imaginary reader for whom it is meant?

It is difficult to begin by answering these questions clearly and convincingly. This would be much easier, though quite superfluous, at the end of the...

The Bible And the Dead Sea Scrolls (Archaeology and Biblical Studies)

Society of Biblical Literature, 2005

The Dead Sea Scrolls have revolutionized our understanding of the literature of the Hebrew Bible, Second Temple Judaism, and the New Testament. The study of the Scrolls is now essential for understanding the history and transmission of the earliest biblical manuscripts, the development of apocalyptic and wisdom writings, and the rise of Jewish...