Book Image

Instant SQL Server Analysis Services 2012 Cube Security

By : Satya Shyam K Jayanty
Book Image

Instant SQL Server Analysis Services 2012 Cube Security

By: Satya Shyam K Jayanty

Overview of this book

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 (7 chapters)

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 .

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.