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.