Microsoft® SQL Server™ 2005 Analysis Services Step by Step

About this book

Your hands-on, practical guide to Microsoft SQL Server 2005 Analysis Services. Get started using Business Intelligence tools that simplify data analysis and with this popular, learn-by-doing tutorial. 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 cubesDesign objects to handle unique financial analysis requirementsImprove 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 cubesManage role-based security and restrict data accessDeploy and maintain a database in a production environmentThe CD that accompanies the print edition of this book is not available with its eBook edition, although select CD content is available for download. A link to the content is included in your eBook.