Instant SQL Server Analysis Services 2012 Cube Security [Instant]


This title is available as an eBook only
Instant SQL Server Analysis Services 2012 Cube Security [Instant]
eBook: $19.99
Formats: PDF, PacktLib, ePub and Mobi formats
$16.00
save 20%!
Print & eBook also available on:
Learn in an Instant - Short, Fast, Focused
Overview
Table of Contents
Author
Support
Sample Chapters
  • Learn something new in an Instant! A short, fast, focused guide delivering immediate results
  • Get to know what’s new in BI space
  • Learn about tools & tricks to secure the data layers
  • Implement best practices for Security administration

Book Details

Language : English
eBook : 68 pages
Release Date : July 2013
ISBN : 1849688702
ISBN 13 : 9781849688703
Author(s) : Satya SK Jayanty
Topics and Technologies : All Books, Enterprise Products and Platforms, Instant, Enterprise, Microsoft SQL Server

Table of Contents

Preface
Instant SQL Server Analysis Services 2012 Cube Security
  • Instant SQL Server Analysis Services 2012 Cube Security
    • Designing and creating security roles in an OLAP database (Intermediate)
    • Creating security roles (Intermediate)
    • Defining dimension access privileges (Advanced)
    • Managing role-based security – database to cube level (Advanced)
    • Managing role-based security – dimension to cell level (Advanced)
    • Accessing restrictions on dimensions and defining default members – full and partial (Intermediate)
    • Securing data at the cell level (Intermediate)
    • Preventing read/access to cell data (Intermediate)
    • Managing user-access privileges on a cube (Advanced)
    • Managing security roles for processing (Intermediate)
    • Data source and access control on cubes (Advanced)
    • Building a secure BI platform – the journey from SQL Server 2008 R2 to 2012 (Intermediate)
    • Securing key points in SSAS (Advanced)

Satya SK Jayanty

Satya (SQLMaster) SK Jayanty is a subject matter expert (Technical &Data Architectand 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.

Sorry, we don't have any reviews for this title yet.

Code Downloads

Download the code and support files for this book.


Submit Errata

Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

Sorry, there are currently no downloads available for this title.

Frequently bought together

Instant SQL Server Analysis Services 2012 Cube Security [Instant] +    Microsoft Exchange 2013 Cookbook =
50% Off
the second eBook
Price for both: $35.50

Buy both these recommended eBooks together and get 50% off the cheapest eBook.

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.

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software