Getting started with SQL server 2012 cube development PDF
Preview Getting started with SQL server 2012 cube development
Getting Started with SQL Server 2012 Cube Development Learn to develop and query Analysis Services cubes and models, with a practical, step-by-step approach Simon Lidberg BIRMINGHAM - MUMBAI Getting Started with SQL Server 2012 Cube Development Copyright © 2013 Packt Publishing All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews. Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book. Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information. First published: September 2013 Production Reference: 1040913 Published by Packt Publishing Ltd. Livery Place 35 Livery Street Birmingham B3 2PB, UK. ISBN 978-1-84968-950-2 www.packtpub.com Cover Image by Suresh Mogre ([email protected]) Credits Author Project Coordinator Simon Lidberg Apeksha Chitnis Reviewers Proofreader David Loo Mario Cecere Richard Louie Donabel Santos Indexer Tejal Daruwale Acquisition Editor James Jones Graphics Yuvraj Mannari Lead Technical Editor Dayan Hyames Production Coordinator Manu Joseph Technical Editors Anusri Ramchandran Cover Work Manu Joseph Dennis John Kapil Hemnani Gaurav Thingalaya About the Author Simon Lidberg is a database veteran, who has worked in the Computer industry since the mid nineties. He has had roles as Consultant, Support Engineer, Escalation Engineer, and Technical Presales Specialist. In the past 15 years, he has worked with databases and ERP Systems at companies such as Digital Equipment, Compaq, and Microsoft. He has been an expert in Microsoft SQL Server since he started to work with Version 6.5 at Microsoft as a Support Engineer. Since 2006, he has worked with the Microsoft Business Intelligence stack that includes Analysis Services. Since then, he has helped numerous companies to start using Analysis Services as well as have trained hundreds of people on Microsoft BI. Simon is also a frequent speaker at conferences such as PASS SQLRally and Microsoft TechDays. He currently blogs at http://blogs.msdn.com/b/querysimon I wish to thank the people at Packt Publishing who gave me the opportunity to write this book. I have tried to write the book that I felt was missing when I moved into the Business Intelligence space, after having worked with databases for 10 years. I hope that you, as a reader, will find it beneficial and that it will help you know Analysis Services. I also want to thank the people who have helped me while writing this book, Mikael, Stephen, and all the rest; thanks for your help and inspiration. Most of all, I wish to thank my wife, Marita, for the support during the work with the book. About the Reviewers David Loo is a Senior Software Development Professional with over 25 years of experience in both software development and people management. He is respected for his ability to focus teams on service excellence and for designing and implementing practical process improvements. Always on the lookout for ways to contribute his knowledge and experience of software development, team-building, and development best practices. Richard Louie is a Business Intelligence developer at Redwood Trust, a residential and commercial mortgage investment firm. He has extensive experience in Oracle and Microsoft SQL for ETL, SSIS, SSRS, SSAS, and VB.NET. Richard is ASQ Green Belt Certified. He is a graduate in Information and Computer Science from the University of California, Irvine. Donabel Santos is a SQL Server MVP and is the Senior SQL Server Developer/ DBA/Trainer at QueryWorks Solutions, a consulting and training company in Vancouver, BC. She has worked with SQL Server since Version 2000 in numerous development, tuning, reporting, and integration projects with ERPs, CRMs, SharePoint, and other custom applications. She holds MCITP certifications for SQL Server 2005/2008, and an MCTS for SharePoint. She is a Microsoft Certified Trainer (MCT), and is also the lead instructor for SQL Server Administration, Development, Tableau, and SSIS courses at British Columbia Institute of Technology (BCIT). Donabel is a proud member of PASS (Professional Association of SQL Server), and a proud BCIT alumna (CST diploma and degree). Donabel blogs at www.sqlmusings.com and her twitter handle is @sqlbelle. She speaks and presents at SQLSaturday, VANPASS, Vancouver TechFest, and so on. She writes for Packt, Idera, SSWUG, and so on. She is the author of Packt's SQL Server 2012 with PowerShell V3 Cookbook, and a contributing author of Manning's PowerShell Deep Dives. www.PacktPub.com Support files, eBooks, discount offers and more You might want to visit www.PacktPub.com for support files and downloads related to your book. Did you know that Packt offers eBook versions of every book published, with PDF and ePub files available? You can upgrade to the eBook version at www.PacktPub.com and as a print book customer, you are entitled to a discount on the eBook copy. Get in touch with us at [email protected] for more details. At www.PacktPub.com, you can also read a collection of free technical articles, sign up for a range of free newsletters and receive exclusive discounts and offers on Packt books and eBooks. TM http://PacktLib.PacktPub.com Do you need instant solutions to your IT questions? PacktLib is Packt's online digital book library. Here, you can access, read and search across Packt's entire library of books. Why Subscribe? • Fully searchable across every book published by Packt • Copy and paste, print and bookmark content • On demand and accessible via web browser Free Access for Packt account holders If you have an account with Packt at www.PacktPub.com, you can use this to access PacktLib today and view nine entirely free books. Simply use your login credentials for immediate access. Instant Updates on New Packt Books Get notified! Find out when new books are published by following @PacktEnterprise on Twitter, or the Packt Enterprise Facebook page. Table of Contents Preface 1 Chapter 1: Self-service Business Intelligence, Creating Value from Data 7 Identifying common user requirements for a BI system 8 Creating a flexible reporting solution 11 Getting user value through self-service reporting 15 Summary 17 Chapter 2: Installing SSAS and Preparing for Cube Development 19 Understanding the BI semantic model architecture 20 Choosing the deployment mode 21 Actions 22 Aggregations 23 Custom assemblies 24 Custom rollups 24 Distinct count 24 Linked objects 24 Many-to-many relationships 25 Parent-child hierarchies 25 Translations 25 Writeback 26 Tool support 26 Installing Analysis Services 2012 in multidimensional mode 28 Hands-on steps for installing Analysis Services 29 Hands-on steps for attaching the sample database 31
The list of books you might like
