20,39 €
Mehr erfahren.
- Herausgeber: Packt Publishing
- Kategorie: Fachliteratur
- Sprache: Englisch
SQL Server 2012 includes BI-specific features such as cube analytics, reporting-related features, multidimensional BI semantic models, and many more. This is a new addition that is of great use to Business Analysts, who can now build BI semantic models using the relational tables from the database engine rather than the dimensions from analysis services.
Instant Microsoft SQL Server Analysis Services 2012 Cube Security is a practical, hands-on guide that provides clear, step-by-step recipes for getting started with cube security. As a Database Administrator and Data Architect, data security is of prime concern, and this book highlights the key concepts of securing cubes. By the end of this book, you will understand the SQL Server security model and how to effectively implement the same on the data platform.
Security is paramount within a data platform, and thankfully, the issues surrounding data access can be fixed in the initial stages of its design. This allows you to avoid any breach of data access layers. The recipes in this book consist of the required ingredients to implement and administer OLAP & BI security management for your cubes. With this book, you will master the key aspects of implementing and managing security essentials and securing data layers.
The recipes in this book incorporate best practice implementation, which include step-by-step instructions for creating models that implement security based on the currently logged on Windows user name or based on custom data passed to analysis services. The new BI platform features will help end users, business users, and technology users by providing a robust environment for IT, planning, budgeting, forecasting with scorecards, and reporting capabilities for the business users. These analytics will help end users to create a comprehensive management application to view the data with ease.
Das E-Book können Sie in Legimi-Apps oder einer beliebigen App lesen, die das folgende Format unterstützen:
Seitenzahl: 78
Veröffentlichungsjahr: 2013
Ähnliche
Table of Contents
Instant SQL Server Analysis Services 2012 Cube Security
Instant SQL Server Analysis Services 2012 Cube Security
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: July 2013
Production Reference: 1220713
Published by Packt Publishing Ltd.
Livery Place
35 Livery Street
Birmingham B3 2PB, UK.
ISBN 978-1-84968-870-3
www.packtpub.com
Credits
Author
Satya SK Jayanty
Reviewer
Tomislav Piasevoli
Acquisition Editor
Joanne Fitzpatrick
Commissioning Editor
Yogesh Dalvi
Technical Editors
Anita Nayak
Jalasha D'costa
Project Coordinator
Michelle Quadros
Proofreader
Stephen Copestake
Production Coordinator
Aparna Bhagat
Cover Work
Aparna Bhagat
Cover Image
Sheetal Aute
About the Author
Satya (SQLMaster) SK Jayanty is a subject matter expert (Technical & Data Architect and DBA) having more than 21 years of experience in the IT field, which includes a wide range of industries: the Stock Exchange, insurance, telecommunications, financial, retail, and manufacturing sectors, among others.
He has been the Microsoft Most Valuable Professional (MVP) for Architecture – SQL Server since the year 2006.
He has also authored the book Microsoft SQL Server 2008 R2 Administration Cookbook (May 2011), Packt Publishing. He has co-authored the book MVP Deep Dives Volume II – SQL Server (October 2011), Manning Publications.
Satya has technically reviewed and provided forewords for three books related to High Availability and Disaster Recovery. And has also been the Item Writer and Technical Reviewer for SQL Server 2008, 2008 R2 and 2012 Microsoft ITPRO and DEV certification exams.
Satya is a regular speaker and SME volunteer at major technology conferences such as Microsoft Tech-Ed (Europe, India, and North America), SQL PASS (Europe and North America), and SQL Bits – the UK and Scottish Area SQL Server user group based in Scotland.
He works as a Director, and Principal Architect, at D B I A Solutions Limited, Database Business Intelligence Architecture Solutions Europe Limited.
First and foremost, I would like to thank my wife Hima for keeping up with me during the writing of this book, particularly as most of the book-writing work occurred on weekends, nights, and other times inconvenient to my family.
Not to mention, my wonderful kids Abhi and Anjali for having patience with me and letting me take another challenge, which has reduced the amount of time I could spend with them.
Finally, a special thanks to Michelle Quadros for supporting me all along in this project.
About the Reviewer
Tomislav Piasevoli is a Business Intelligence (BI) Specialist with a decade of experience working with SQL Server Analysis Services (SSAS). He successfully implemented many still-in-use BI solutions, achieved the highest certification for SQL Server Analysis Services (SSAS Maestro), and shared his expertise in the form of a book named MDX with SQL Server 2008 R2 Analysis Services Cookbook published in 2011 by Packt Publishing (http://www.amazon.com/dp/1849681309). Tomislav currently specializes in dimensional modeling, cube design, and MDX consulting worldwide and can be contacted at <[email protected]>.
In addition to his regular work, Tomislav also finds the time to present at local conferences and to occasionally write an article or two for local magazines or on his blog (http://tomislav.piasevoli.com). His contribution to the community has been recognized by Microsoft honoring him with the Most Valuable Professional (MVP) award every year since 2009.
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.
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?
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.
Preface
Welcome to Instant SQL Server Analysis Services 2012 Cube Security. You must know that a broad range of activities, such as building solutions and deploying analytical databases for Business Intelligence (BI), is contained within a Cube. SQL Server 2012 Analysis Services provides a wide range of solutions within BI with Excel, Performance Point, Reporting Services, and SharePoint services. The BI semantics from SQL Server 2012 Analysis Services requires robust security and protection for analytics to manage the Cube data. This book covers the key steps in security and highlights the required model along with connecting relational data for processing.
What this book covers
Designing and creating security roles in an OLAP database (Intermediate) begins with security management with a design and creates phases that are initial steps to defining the security roles, irrespective of relational database type or analytical database type.
Creating security roles (Intermediate) covers the topic where, in order to manage security for Analysis Services objects and data, a role is important. This associates relevant operating system security identifiers that will build a much more robust system.
Defining dimension access privileges (Advanced) will look through dimension access privileges. As an administrator, your responsibility is to grant relevant read or write permissions to some or all members of any dimension in the cubes to which the database role has access permissions.
Managing role-based security – database to cube level (Advanced) will look at how to grant access and permissions from the database to cube level within an Analysis Services database.
Managing role-based security – dimension to cell level (Advanced) will look through how to grant access and permissions from the dimension to cell level within an Analysis Services database.
Accessing restrictions on dimensions and defining default members – full and partial (Intermediate) lets us overview access restrictions and define the default members with necessary permissions.
Securing data at the cell level (Intermediate) will look through the key steps in securing data at the cell level within a cube.
Preventing read/access to cell data (Intermediate) highlights the essential steps to limit the cell data access within the cube or dimension that will explicitly restrict cell access.
Managing user-access privileges on a cube (Advanced) will look through the user-access privileges on the cube.
Managing security roles for processing (Intermediate)
