Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Expert Cube Development with Microsoft SQL Server 2008 Analysis Services
  • Table Of Contents Toc
Expert Cube Development with Microsoft SQL Server 2008 Analysis Services

Expert Cube Development with Microsoft SQL Server 2008 Analysis Services

4.4 (19)
Buy this Book
close
close
Expert Cube Development with Microsoft SQL Server 2008 Analysis Services

Expert Cube Development with Microsoft SQL Server 2008 Analysis Services

4.4 (19)
Buy this Book

Overview of this book

Microsoft's SQL Server Analysis Services 2008 is an OLAP server that allows users to analyze business data quickly and easily. However, designing cubes in Analysis Services can be a complex task: it's all too easy to make mistakes early on in development that lead to serious problems when the cube is in production. Learning the best practices for cube design before you start your project will help you avoid these problems and ensure that your project is a success. This book offers practical advice on how to go about designing and building fast, scalable, and maintainable cubes that will meet your users' requirements and help make your Business Intelligence project a success. This book gives readers insight into the best practices for designing and building Microsoft Analysis Services 2008 cubes. It also provides details about server architecture, performance tuning, security, and administration of an Analysis Services solution. In this book, you will learn how to design and implement Analysis Services cubes. Starting from designing a data mart for Analysis Services, through the creation of dimensions and measure groups, to putting the cube into production, we'll explore the whole of the development lifecycle. This book is an invaluable guide for anyone who is planning to use Microsoft Analysis Services 2008 in a Business Intelligence project.
Table of Contents (17 chapters)
close
close
close
Expert Cube Development with Microsoft SQL Server 2008 Analysis Services
Icon
Expert Cube Development with Microsoft SQL Server 2008 Analysis Services
Credits
Icon
Credits
About the Authors
chevron up
Icon
About the Authors
About the Reviewers
Icon
About the Reviewers
Preface
Icon
Preface
Lock Free Chapter
1
Designing the Data Warehouse for Analysis Services
Icon
Designing the Data Warehouse for Analysis Services
Icon
The source database
Icon
Data modeling for Analysis Services
Icon
Physical database design for Analysis Services
Icon
Summary
2
Building Basic Dimensions and Cubes
Icon
Building Basic Dimensions and Cubes
Icon
Choosing an edition of Analysis Services
Icon
Setting up a new Analysis Services project
Icon
Creating data sources
Icon
Creating Data Source Views
Icon
Designing simple dimensions
Icon
Building a Simple Cube
Icon
Summary
3
Designing More Complex Dimensions
Icon
Designing More Complex Dimensions
Icon
Grouping and Banding
Icon
Slowly Changing Dimensions
Icon
Junk dimensions
Icon
Ragged hierarchies
Icon
Summary
4
Measures and Measure Groups
Icon
Measures and Measure Groups
Icon
Measures and aggregation
Icon
Measure groups
Icon
Dimension/measure group relationships
Icon
Summary
5
Adding Transactional Data such as Invoice Line and Sales Reason
Icon
Adding Transactional Data such as Invoice Line and Sales Reason
Icon
Details about transactional data
Icon
Drillthrough
Icon
Many-to-many dimension relationships
Icon
Summary
6
Adding Calculations to the Cube
Icon
Adding Calculations to the Cube
Icon
Different kinds of calculated members
Icon
Common calculations
Icon
Calculation dimensions
Icon
Named sets
Icon
Summary
7
Adding Currency Conversion
Icon
Adding Currency Conversion
Icon
Introduction to currency conversion
Icon
Where to perform currency conversion
Icon
The Add Business Intelligence Wizard
Icon
Measure expressions
Icon
Summary
8
Query Performance Tuning
Icon
Query Performance Tuning
Icon
How Analysis Services processes queries
Icon
Performance tuning methodology
Icon
Designing for performance
Icon
Performance-specific design features
Icon
MDX calculation performance
Icon
Caching
Icon
Scale-up and scale-out
Icon
Summary
9
Securing the Cube
Icon
Securing the Cube
Icon
Sample security requirements
Icon
Analysis Services security features
Icon
Administrative security
Icon
Data security
Icon
Dynamic cell security
Icon
Accessing Analysis Services from outside a domain
Icon
Managing security
Icon
Security and query performance
Icon
Summary
10
Productionization
Icon
Productionization
Icon
Making changes to a cube in production
Icon
Managing partitions
Icon
Managing processing
Icon
Analysis Services data directory maintenance
Icon
Backup
Icon
Copying databases between servers
Icon
Summary
11
Monitoring Cube Performance and Usage
Icon
Monitoring Cube Performance and Usage
Icon
Analysis Services and the operating system
Icon
Monitoring processing performance
Icon
Monitoring query performance
Icon
Monitoring usage
Icon
How to build a complete monitoring solution
Icon
Summary
1
Index
Icon
Index

About the Authors

Chris Webb () has been working with Microsoft Business Intelligence tools for almost ten years in a variety of roles and industries. He is an independent consultant and trainer based in the UK, specializing in Microsoft SQL Server Analysis Services and the MDX query language. He is the co-author of MDX Solutions for Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase, Wiley, 0471748080, is a regular speaker at conferences, and blogs on Business Intelligence (BI) at http://cwebbbi.spaces.live.com. He is a recipient of Microsoft's Most Valuable Professional award for his work in the SQL Server community.

First and foremost, I'd like to thank my wife Helen and my two daughters Natasha and Amelia for putting up with me while I've been working on this book. I'd also like to thank everyone who's helped answer all the questions I came up with in the course of writing it: Deepak Puri, Darren Gosbell, David Elliott, Mark Garner, Edward Melomed, Gary Floyd, Greg Galloway, Mosha Pasumansky, Sacha Tomey, Teo Lachev, Thomas Ivarsson, and Vidas Matelis. I'm grateful to you all.

Alberto Ferrari () is a consultant and trainer for the BI development area with the Microsoft suite for Business Intelligence. His main interests are in the methodological approaches to the BI development and he works as a trainer for software houses that need to design complex BI solutions.

He is a founder, with Marco Russo, of the site www.sqlbi.com, where they publish many whitepapers and articles about SQL Server technology. He co-authored the SqlBI Methodology, which can be found on the SQLBI site.

My biggest thanks goes to Caterina, who had the patience and courage to support me during all the hard time in book writing and my son, Lorenzo, is just a year old but he's an invaluable source of happiness in my life.

Marco Russo () is a consultant and trainer in software development based in Italy, focusing on development for the Microsoft Windows operating system. He's involved in several Business Intelligence projects, making data warehouse relational, and multidimensional design, with particular experience in sectors such as banking and financial services, manufacturing and commercial distribution.

He previously wrote several books about .NET and recently co-authored Introducing Microsoft LINQ, 0735623910, and Programming Microsoft LINQ, 0735624003, both published by Microsoft Press. He also wrote The many-to-many revolution, a mini-book about many-to-many dimension relationships in Analysis Services, and co-authored the SQLBI Methodology with Alberto Ferrari. Marco is a founder of SQLBI (http://www.sqlbi.com) and his blog is available at http://sqlblog.com/blogs/marco_russo.

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Expert Cube Development with Microsoft SQL Server 2008 Analysis Services
Next Chapter
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon