Microsoft SQL Server 2005 Analysis Services Step by Step

Teach yourself the fundamentals of SQL Server Analysis Services-one step at a time. With this practical, learn-by-doing tutorial, you get the guidance you need to build flexible and powerful solutions that meet the analytical needs of your organization.

Discover how to:



Start building cubes using the Microsoft Visual Studio 2005 Business Intelligence designers
Create dimensions and measure groups to build, browse, and modify OLAP cubes
Design objects to handle unique financial analysis requirements
Improve query performance with aggregations and user hierarchies
Customize cubes with multi-dimensional expressions (MDX) and other advanced design techniques
Use actions to integrate Web pages, reporting applications, and drillthrough capabilities with cubes
Manage role-based security and restrict data access
Deploy and maintain a database in a production environment

CD features



All practice exercises and answer files
Fully searchable eBook

For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.