會員

Expert Cube Development with Microsoft SQL Server 2008 Analysis Services

Alberto Ferrari, Chris Webb, Marco Russo 著

更新時間：2021-04-01 14:00:28

開會員，本書免費讀 >

ThisisapracticaltutorialforAnalysisServicesthatshowsreadershowtosolveproblemscommonlyencounteredwhiledesigningcubes,andexplainswhichfeaturesofAnalysisServicesworkwellandwhichshouldbeavoided.Thebookwalksthroughthewholecubedevelopmentlifecycle,frombuildingdimensions,cubesandcalculationstotuningandmovingthecubeintoproduction.ThisbookisaimedatAnalysisServicesdeveloperswhoalreadyhavesomeexperiencebutwhowanttogointomoredetailonadvancedtopics,andwhowanttolearnbestpracticesforcubedesign.

目錄(88章)

倒序

Coverpage
Copyright Information
Credits
About the Authors
About the Reviewers
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Chapter 1. Designing the Data Warehouse for Analysis Services
The source database
Data modeling for Analysis Services
Physical database design for Analysis Services
Summary
Chapter 2. Building Basic Dimensions and Cubes
Choosing an edition of Analysis Services
Setting up a new Analysis Services project
Creating data sources
Creating Data Source Views
Designing simple dimensions
Building a Simple Cube
Summary
Chapter 3. Designing More Complex Dimensions
Grouping and Banding
Slowly Changing Dimensions
Junk dimensions
Ragged hierarchies
Summary
Chapter 4. Measures and Measure Groups
Measures and aggregation
Measure groups
Dimension/measure group relationships
Summary
Chapter 5. Adding Transactional Data such as Invoice Line and Sales Reason
Details about transactional data
Drillthrough
Many-to-many dimension relationships
Summary
Chapter 6. Adding Calculations to the Cube
Different kinds of calculated members
Common calculations
Calculation dimensions
Named sets
Summary
Chapter 7. Adding Currency Conversion
Introduction to currency conversion
Where to perform currency conversion
The Add Business Intelligence Wizard
Measure expressions
Summary
Chapter 8. Query Performance Tuning
How Analysis Services processes queries
Performance tuning methodology
Designing for performance
Performance-specific design features
MDX calculation performance
Caching
Scale-up and scale-out
Summary
Chapter 9. Securing the Cube
Sample security requirements
Analysis Services security features
Administrative security
Data security
Dynamic cell security
Accessing Analysis Services from outside a domain
Managing security
Security and query performance
Summary
Chapter 10. Productionization
Making changes to a cube in production
Managing partitions
Managing processing
Analysis Services data directory maintenance
Backup
Copying databases between servers
Summary
Chapter 11. Monitoring Cube Performance and Usage
Analysis Services and the operating system
Monitoring processing performance
Monitoring query performance
Monitoring usage
How to build a complete monitoring solution
Summary
Index 更新時間：2021-04-01 14:00:28

官术网_书友最值得收藏!

Expert Cube Development with Microsoft SQL Server 2008 Analysis Services