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 ...
See more details below
Paperback (REV)
$36.21 price
(Save 9%)$39.99 List Price
Other sellers (Paperback)
  • All (29) from $1.99   
  • New (7) from $1.99   
  • Used (22) from $1.99   
Sending request ...


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

A Note Regarding the CD or DVD

The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to

Read More Show Less

Product Details

  • ISBN-13: 9780735621992
  • Publisher: Microsoft Press
  • Publication date: 4/26/2006
  • Series: Step by Step Developer Series
  • Edition description: REV
  • Pages: 400
  • Product dimensions: 7.70 (w) x 8.86 (h) x 1.02 (d)

Meet the Author

Reed Jacobson is a senior architect in Hitachi Consulting’s Business Intelligence practice. He has authored several training courses and books, including Microsoft SQL Server 2000 Analysis Services Step by Step.

Hitachi Consulting, a division of Hitachi Ltd., is a global business and IT consulting firm serving Fortune 2000 companies. It is a leader in developing corporate training and custom solutions for Reporting Services

Stacia Misner, MCITP, MCTS, is a consultant and trainer specializing in Microsoft business intelligence solutions. She has more than 20 years of IT experience and has written several books on SQL Server, including Microsoft SQL Server 2008 Reporting Services Step by Step. Stacia is also one of the first to earn the new SQL Server Analysis Services Maestro certification.

Read More Show Less

Table of Contents

Finding Your Best Starting Point;
About the Companion CD-ROM;
System Requirements;
Installing and Using the Sample Files;
Conventions and Features in This Book;
Part I: Getting Started with Analysis Services;
Chapter 1: Understanding Business Intelligence and Data Warehousing;
Introducing Business Intelligence;
Reviewing Data Warehousing Concepts;
Chapter 1 Quick Reference;
Chapter 2: Understanding OLAP and Analysis Services;
Understanding OLAP;
Understanding Analysis Services;
Chapter 2 Quick Reference;
Chapter 3: Building Your First Cube;
Exploring Business Intelligence Development Studio;
Preparing to Create a Cube;
Creating a Cube;
Generating a Schema;
Processing and Browsing a Cube;
Chapter 3 Quick Reference;
Part II: Design Fundamentals;
Chapter 4: Designing Dimensions;
Reviewing the Data Warehouse Structure;
Building a Standard Dimension;
Working with a Time Dimension;
Creating a Parent-Child Dimension;
Chapter 4 Quick Reference;
Chapter 5: Designing Measure Groups and Measures;
Adding Measure Groups to a Cube;
Aggregating Semiadditive Measures;
Calculating Distinct Counts;
Creating Simple Calculations;
Chapter 5 Quick Reference;
Chapter 6: Working with a Finance Measure Group;
Designing an Account Dimension;
Designing Nonadditive Financial Measures;
Chapter 6 Quick Reference;
Chapter 7: Designing Aggregations and Hierarchies;
Understanding Aggregation Design;
Designing User Hierarchies;
Optimizing Aggregations;
Chapter 7 Quick Reference;
Part III: Advanced Design;
Chapter 8: Using MDX;
Creating Tuple-Based Calculated Members;
Querying with MDX;
Designing Custom Members;
Working with MDX Scripts;
Developing Key Performance Indicators;
Chapter 8 Quick Reference;
Chapter 9: Exploring Special Features;
Defining Dimension Relationships;
Supporting Currency Conversions;
Localizing Cubes;
Organizing Information with Folders and Perspectives;
Chapter 9 Quick Reference;
Chapter 10: Interacting with Cubes;
Implementing Actions;
Using Writeback;
Chapter 10 Quick Reference;
Part IV: Production Management;
Chapter 11: Implementing Security;
Using Role-Based Security;
Applying Security to a Dimension;
Securing Data at the Cell Level;
Setting Administration Security;
Chapter 11 Quick Reference;
Chapter 12: Managing Partitions and Database Processing;
Managing Very Large Databases;
Working with Storage;
Managing OLAP Processing;
Monitoring Cube Activity;
Chapter 12 Quick Reference;
Chapter 13: Managing Deployment;
Reviewing Deployment Options;
Managing Database Objects Programmatically;
Automating Database Processing;
Planning for Disaster and Recovery;
Chapter 13 Quick Reference;
Appendix : About the Authors;
Contributing Authors;

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 2 Customer Reviews
  • Anonymous

    Posted April 11, 2006

    No info on Mining Structures

    I was totally surprised that the only mention of mining structures in the book was that the folder exists. There is no guidance related to them or in how a person might use them. This was the info I wanted. This book is useful only for cubing and reporting with SQL Server 2005, so far as I can see.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted December 16, 2009

    No text was provided for this review.

Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)