Microsoft SQL Server 2005 Analysis Services Step by Step

by Consulting, Hitachi

Edition: 1st

ISBN13: 9780735621992

ISBN10: 0735621993

Format: Paperback

Pub. Date: 2006-03-29

Publisher(s): Microsoft Press

Upgraded Edition: Click here!

Other versions by this Author

Free Shipping On All Orders!*

Free economy shipping applies to all orders shipped to residential addresses. Orders shipped to campus receive free standard shipping. Free shipping offers do not apply to Marketplace items.

List Price: ~~$39.99~~

Rent Book

Select for Price

Add to Cart

There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Buy from our Marketplace starting at $6.41

Summary

Your hands-on guide to learning Microsoft SQL Server Analysis Services, Microsoft's customizable analysis solution for business data modeling and interpretation. Analysis Services is a powerful tool for business intelligence, so understanding the essentials-how to create a cube, as well as how to deploy, customize, and extend the basic calculations-is critical to harnessing the full benefits of SQL Server. This step-by-step tutorial shows you how to get started, how to build scalable analytical applications, and how to use and administer advanced featuresWith STEP BY STEP, you work at your own pace through hands-on, learn-by-doing exercises. A companion CD includes data sets and sample code.

Author Biography

Reed Jacobson is a senior architect in Hitachi Consulting's Business Intelligence practice

Introduction	p. ix
Finding Your Best Starting Point	p. ix
About the Companion CD-ROM	p. x
System Requirements	p. xi
Installing and Using the Sample Files	p. xi
Conventions and Features in This Book	p. xii
Getting Started with Analysis Services
Understanding Business Intelligence and Data Warehousing	p. 3
Introducing Business Intelligence	p. 3
Reviewing Data Warehousing Concepts	p. 5
The Purpose of a Data Warehouse	p. 5
The Structure of a Dimensional Database	p. 6
A Fact Table	p. 10
Dimension Tables	p. 11
Chapter 1 Quick Reference	p. 16
Understanding OLAP and Analysis Services	p. 17
Understanding OLAP	p. 17
Consistently Fast Response	p. 18
Metadata-Based Queries	p. 20
Spreadsheet-Style Formulas	p. 22
Understanding Analysis Services	p. 23
Analysis Services and Speed	p. 24
Analysis Services and Metadata	p. 24
Analysis Services Formulas	p. 26
Analysis Services Tools	p. 28
Chapter 2 Quick Reference	p. 29
Building Your First Cube	p. 31
Exploring Business Intelligence Development Studio	p. 31
Examining the Contents of an Analysis Services Project	p. 32
Exploring Menu Commands	p. 35
Preparing to Create a Cube	p. 36
Reviewing the Analysis Requirements	p. 37
Creating a New Analysis Services Project	p. 37
Creating a Cube	p. 38
Using the Cube Wizard Without a Data Source	p. 38
Reviewing the Cube Structure in the Cube Designer	p. 45
Generating a Schema	p. 47
Using the Schema Generation Wizard	p. 47
Loading Data into the Relational Schema	p. 52
Processing and Browsing a Cube	p. 55
Deploying and Processing a Cube	p. 55
Browsing a Cube	p. 56
Chapter 3 Quick Reference	p. 58
Design Fundamentals
Designing Dimensions	p. 63
Reviewing the Data Warehouse Structure	p. 63
Building a Standard Dimension	p. 64
Adding a Data Source	p. 65
Creating a Data Source View	p. 67
Using the Dimension Wizard	p. 69
Deploying a Dimension	p. 74
Changing Attribute Properties	p. 76
Working with a Time Dimension	p. 77
Modifying a Data Source View	p. 78
Creating a Time Dimension	p. 79
Working with Role-Playing Dimensions	p. 84
Creating a Parent-Child Dimension	p. 85
Adding an Employee Dimension	p. 86
Totaling Data for Non-Leaf-Level Data Members	p. 88
Managing Levels within a Parent-Child Dimension	p. 92
Chapter 4 Quick Reference	p. 96
Designing Measure Groups and Measures	p. 99
Adding Measure Groups to a Cube	p. 99
Building a Cube	p. 100
Changing Properties for Measure Groups and Measures	p. 103
Specifying Dimension Usage	p. 104
Browsing Multiple Measure Groups	p. 107
Aggregating Semiadditive Measures	p. 113
Adding a Measure Group to an Existing Cube	p. 113
Using a Semiadditive Aggregate Function	p. 115
Calculating Distinct Counts	p. 117
Creating Simple Calculations	p. 119
Adding a Calculation to a Cube	p. 120
Applying Conditional Formatting	p. 126
Chapter 5 Quick Reference	p. 127
Working with a Finance Measure Group	p. 129
Designing an Account Dimension	p. 129
Working with Account Intelligence	p. 130
Using Unary Operators	p. 135
Aggregating by Account	p. 139
Designing Nonadditive Financial Measures	p. 144
Creating a Nonadditive Measure	p. 145
Chapter 6 Quick Reference	p. 148
Designing Aggregations and Hierarchies	p. 149
Understanding Aggregation Design	p. 149
Using the Aggregation Design Wizard	p. 151
Inspecting Aggregations	p. 155
Changing Partition Counts	p. 158
Adding Attributes to the Aggregation Design	p. 160
Designing User Hierarchies	p. 161
Adding a User Hierarchy	p. 162
Aggregating User Hierarchies	p. 165
Optimizing Aggregations	p. 167
Using the Query Log	p. 168
Viewing Usage Data	p. 170
Using the Usage-Based Optimization Wizard	p. 171
Maintaining the Query Log	p. 172
Chapter 7 Quick Reference	p. 173
Advanced Design
Using MDX	p. 177
Creating Tuple-Based Calculated Members	p. 177
Creating an MDX Calculation for Percent of Total	p. 182
Creating an MDX Calculation for Percent of Parent	p. 186
Querying with MDX	p. 188
Executing MDX Queries	p. 188
Working with Basic MDX Queries	p. 193
Designing Custom Members	p. 197
Creating a Calculated Member Using a Set-Based Function	p. 197
Creating Cumulative Calculations	p. 200
Working with MDX Scripts	p. 202
Managing the Sequence of Calculations	p. 202
Adding a Script Assignment	p. 205
Developing Key Performance Indicators	p. 209
Comparing Cube Values to Goals	p. 209
Using MDX Expressions with Key Performance Indicators	p. 212
Chapter 8 Quick Reference	p. 215
Exploring Special Features	p. 217
Defining Dimension Relationships	p. 217
Using a Referenced Relationship Type	p. 217
Using a Many-to-Many Relationship Type	p. 221
Supporting Currency Conversions	p. 229
Localizing Cubes	p. 231
Adding Translations	p. 231
Browsing Translations	p. 235
Organizing Information with Folders and Perspectives	p. 236
Organizing Measures	p. 236
Using Perspectives	p. 238
Chapter 9 Quick Reference	p. 242
Interacting with Cubes	p. 245
Implementing Actions	p. 245
Using Standard Actions	p. 246
Linking to Reports	p. 249
Adding Drillthrough	p. 251
Using Writeback	p. 253
Write-Enabling a Dimension	p. 254
Dynamically Adding Members to a Dimension	p. 255
Modifying the Cube Structure for Writeback	p. 257
Writing Values Back to a Cube	p. 261
Chapter 10 Quick Reference	p. 267
Production Management
Implementing Security	p. 271
Using Role-Based Security	p. 271
Creating Security Roles	p. 272
Managing Roles	p. 277
Applying Security to a Dimension	p. 278
Restricting Access to a Dimension	p. 278
Restricting Access to Specific Members of a Dimension	p. 281
Controlling Visual Totals for a Dimension	p. 283
Defining a Default Member for a Dimension	p. 284
Securing Data at the Cell Level	p. 287
Preventing Values in Cells from Being Read	p. 287
Allowing Users to Write to Cells	p. 290
Setting Administration Security	p. 291
Creating Security Roles for Processing	p. 291
Chapter 11 Quick Reference	p. 293
Managing Partitions and Database Processing	p. 295
Managing Very Large Databases	p. 295
Understanding Partition Strategies	p. 295
Creating Partitions	p. 296
Merging Partitions	p. 301
Working with Storage	p. 304
Understanding Analysis Services Storage Modes	p. 305
Setting Storage Options	p. 306
Changing Data in a Warehouse	p. 308
Managing OLAP Processing	p. 312
Processing a Dimension	p. 313
Processing a Cube	p. 318
Configuring Proactive Caching	p. 320
Monitoring Cube Activity	p. 326
Profiling Analysis Services Queries	p. 326
Using the Performance Monitor	p. 330
Chapter 12 Quick Reference	p. 333
Managing Deployment	p. 335
Reviewing Deployment Options	p. 335
Building a Database	p. 336
Deploying a Database	p. 341
Processing a Database	p. 348
Managing Database Objects Programmatically	p. 351
Working with XMLA Scripts	p. 352
Automating Database Processing	p. 356
Creating a SQL Server Integration Services Package	p. 357
Using the Analysis Services Processing Task	p. 358
Handling Task Failures	p. 359
Scheduling a SQL Server Integration Services Package	p. 361
Planning for Disaster and Recovery	p. 364
Backing Up an Analysis Services Database	p. 365
Restoring an Analysis Services Database	p. 366
Chapter 13 Quick Reference	p. 368
Glossary	p. 369
Index	p. 373
Table of Contents provided by Ingram. All Rights Reserved.