作者：Marco Russo, Alberto Ferrari, Chris Webb
出版日期：July 15, 2009
出版社：其它
页数：360
ISBN：ISBN-10: 1847197221 ISBN-13: 978-1847197221
文件格式：PDF


Design and implement fast, scalable and maintainable cubes
A real-world guide to designing cubes with Analysis Services 2008Model dimensions and measure groups in BI Development StudioImplement security, drill-through, and MDX calculationsLearn how to deploy, monitor, and performance-tune your cubeFilled with best practices and useful hints and tipsIn Detail
Microsoft’s SQL Server Analysis Services 2008 is an OLAP server thatallows users to analyze business data quickly and easily. However,designing cubes in Analysis Services can be a complex task: it’s alltoo easy to make mistakes early on in development that lead to seriousproblems when the cube is in production. Learning the best practicesfor cube design before you start your project will help you avoid theseproblems and ensure that your project is a success.
This book offers practical advice on how to go about designing andbuilding fast, scalable, and maintainable cubes that will meet yourusers’ requirements and help make your Business Intelligence project asuccess.
This book gives readers insight into the best practices fordesigning and building Microsoft Analysis Services 2008 cubes. It alsoprovides 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 AnalysisServices cubes. Starting from designing a data mart for AnalysisServices, through the creation of dimensions and measure groups, toputting the cube into production, we’ll explore the whole of thedevelopment lifecycle.
This book is an invaluable guide for anyone who is planning to useMicrosoft Analysis Services 2008 in a Business Intelligence project.
What you will learn from this book?
Build a data mart suitable for use with Analysis ServicesCreate and configure an Analysis Services project in Business Intelligence Development StudioUse the Dimension Wizard and the Dimension Editor to build dimensionsCreate measure groups and associate them with dimensionsAdd calculations to the cube, including implementing currency conversion and a date tool dimensionExplore the security model, including dimension security and cell security, and implement dynamic securityTune queries to get the best possible performanceAutomate processing and partition creationMonitor your cube to see who’s actually using itApproach
This is a practical tutorial for Analysis Services that showsreaders how to solve problems commonly encountered while designingcubes, and explains which features of Analysis Services work well andwhich should be avoided. The book walks through the whole cubedevelopment lifecycle, from building dimensions, cubes and calculationsto tuning and moving the cube into production.
Who this book is written for?
This book is aimed at Analysis Services developers who already havesome experience but who want to go into more detail on advanced topics,and who want to learn best practices for cube design.
About the Author
Alberto Ferrari
Alberto Ferrari is a consultant and trainer for the BI developmentarea with the Microsoft suite for Business Intelligence. His maininterests are in the methodological approaches to BI development and heworks as a trainer for software houses that need to design complex BIsolutions.He co-authored the “SqlBI Methodology“, which can be found on the SqlBI site.
Chris Webb
Chris Webb has been working with Microsoft Business Intelligencetools for almost ten years in a variety of roles and industries. He isan independent consultant and trainer based in the UK, specializing inMicrosoft SQL Server Analysis Services and the MDX query language. Heis the co-author of “MDX Solutions for Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase“, is a regular speaker at conferences, and blogs on BI at cwebbbi.spaces.live.com. He is a recipient of Microsoft’s Most Valuable Professional award for his work in the SQL Server community.
Marco Russo
Marco Russo is a consultant and trainer in software developmentbased in Italy, focusing on development for Microsoft Windows operatingsystems. He’s involved in several Business Intelligence projects,including those of relational and multidimensional warehouse design,with particular experience in sectors like banking and financialservices, manufacturing and commercial distribution.
He previously wrote several books about .NET and recentlyco-authored “Introducing Microsoft LINQ” and “Programming MicrosoftLINQ”, both published by Microsoft Press. He also wrote “Themany-to-many revolution”, a mini-book about many-to-many dimensionrelationships in Analysis Services, and co-authored the “SQLBIMethodology” with Alberto Ferrari. Marco is a founder of SQLBI (sqlbi.com) and his blog is available at sqlblog.com/blogs/marco_russo