Publisher's Synopsis
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.
