Microsoft SQL Server 2005 Analysis Services

by Edward Melomed, Irina Gorbach, Alexander Berger, Py Bateman


Book Description:

Microsoft SQL Server Analysis Services provides fast access to data by means of multidimensional data structures and the multidimensional query language MDX. Analysis Services provides the capability to design, create, and manage multidimensional cubes based on data warehouse tables, and it serves as the foundation for the Microsoft Business Intelligence strategy.

Microsoft SQL Server 2005 Analysis Services gives the reader insight into the way Analysis Services functions. It not only explains ways to design and create multidimensional objects, databases, dimensions, and cubes, but also provides invaluable information about the reasons behind decisions made by the development team.

Here’s what you’ll find inside:
  • Explore the multidimensional object model and its definition language
  • Learn the main concepts of the MDX language and gain an in-depth understanding of advanced MDX concepts
  • Understand the mechanisms of integrating multidimensional and relational databases
  • Learn how to build client applications to access data in Analysis Services
  • Examine server architecture, including main data structures, data processing, and query resolution algorithms
  • Gain a deep understanding of the internal and external protocols for data transfer, including the XML/A protocol
  • Explore how Analysis Services manages memory
  • Explore the security model, including role-based security, code-access security, and data security
  • Discover how to monitor and manage Analysis Services

New! Check out our new forum, it is currently empty but will soon have book corrections and other material. You can also ask questions there.
INView OCX
To get the INView OCX control please go to our downloads section.

VBA functions in Analysis Services 2005 can be downloaded in word format from the downloads section.

FoodMart
The FoodMart database is a sample database. It is a variation of the same sample database that shipped with SQL Server 2000 and is used throughout the book. The database is available in our downloads section.
Disclaimer.
The TestRole grants permission to Everyone, instead of two users TestRole and redmond\irinag. If you need the samples in chapters 37 and 38 to work correctly, you need to create a local user TestRole and remove everyone from the testrole, and replace with TestRole user.

To view the Foodmart 2005 Sample Project documentation please click here

Samples for the book:
Chapter 14 Samples: Download
Chapter 33 Samples: Download
Chapter 34 Samples: Download