Instant SQL Server Analysis Services 2012 Cube Security

Analyze and secure cubes in the SQL Server 2012 development environment in no time using this hands-on guide

Instant SQL Server Analysis Services 2012 Cube Security

Satya SK Jayanty

Analyze and secure cubes in the SQL Server 2012 development environment in no time using this hands-on guide
Mapt Subscription
FREE
$29.99/m after trial
eBook
$14.00
RRP $19.99
Save 29%
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$14.00
$29.99p/m after trial
RRP $19.99
Subscription
eBook
Start 30 Day Trial
Subscribe and access every Packt eBook & Video.
 
  • 5,000+ eBooks & Videos
  • 50+ New titles a month
  • 1 Free eBook/Video to keep every month
Start Free Trial
 
Preview in Mapt

Book Details

ISBN 139781849688703
Paperback68 pages

Book Description

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.

Table of Contents

Chapter 1: 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)

What You Will Learn

  • 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

Authors

Table of Contents

Chapter 1: 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)

Book Details

ISBN 139781849688703
Paperback68 pages
Read More

Read More Reviews

Recommended for You

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook Book Cover
Microsoft SQL Server 2012 Integration Services: An Expert Cookbook
$ 26.99
$ 18.90
Expert Cube Development with SSAS Multidimensional Models Book Cover
Expert Cube Development with SSAS Multidimensional Models
$ 29.99
$ 21.00
Microsoft Tabular Modeling Cookbook Book Cover
Microsoft Tabular Modeling Cookbook
$ 32.99
$ 23.10
Microsoft SQL Server 2012 Performance Tuning Cookbook Book Cover
Microsoft SQL Server 2012 Performance Tuning Cookbook
$ 35.99
$ 25.20
Getting Started with SQL Server 2012 Cube Development Book Cover
Getting Started with SQL Server 2012 Cube Development
$ 29.99
$ 21.00
Expert Cube Development with SSAS Multidimensional Models Book Cover
Expert Cube Development with SSAS Multidimensional Models
$ 29.99
$ 21.00