Happy to announce the upcoming release of my 3rd book in SQL Server arena.
As always first in SQL Server series the new style which is instant, Micro-book format. Earlier the SQL Server 2008 R2 Administration cookbook was first in the series of cookbook.
The Instant style of books are aimed to highlight the key topic, in this case I’ve targeted the SSAS 2012 Cube Security which is an essential task for every Developer and DBA in their data platform management.
Instant Microsoft SQL Server Analysis Services 2012 Cube Security
What you will learn from this book
Explore security architecture on BI semantics
Implement security
Use SQL Server tools to implement security methods
Grant user access privileges from Cube level to Cell level
Manage security for different roles
Control access and data sources on cubes
In Detail
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.
Approach
Filled with practical, step-by-step instructions and clear explanations for the most important and useful tasks. Instant Microsoft SQL Server Analysis Services 2012 Cube Security is a practical, hands-on guide that provides a number of clear, step-by-step exercises for getting started with cube security.
Who this book is for
This book is aimed at Database Administrators, Data Architects, and Systems Administrators who are managing the SQL Server data platform. It is also beneficial for analysis services developers who already have some experience with the technology, but who want to go into more detail on advanced topics and learn best practices for cube design.
Book Details
Language : English
eBook : 77 pages
Release Date : July 2013
ISBN : 1849688702
ISBN 13 : 9781849688703
Author(s) : Satya SK Jayanty
Topics and Technologies : All Books, Instant, Enterprise, Microsoft SQL Server
eBook expected July 2013. Pre-order now!