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

Overview

• 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

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.

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

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 written 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.

在 SQL Server 2012 開發環境中，使用這本實用指南，您可以快速分析和保護立方體。

概述:
- 立即學習新知識！一本短小、快速、專注的指南，立即獲得結果。
- 了解商業智能領域的最新資訊。
- 學習有關保護數據層的工具和技巧。
- 實施安全管理的最佳實踐。

詳細內容:
SQL Server 2012 包含特定於商業智能的功能，例如立方體分析、報告相關功能、多維度商業智能語義模型等等。這是一個非常有用的新功能，對於商業分析師來說非常實用，他們現在可以使用來自數據庫引擎的關聯表來構建商業智能語義模型，而不是使用分析服務中的維度。

《立即學習 Microsoft SQL Server Analysis Services 2012 立方體安全》是一本實用的實作指南，提供了清晰的、逐步的步驟，讓您快速入門立方體安全。作為數據庫管理員和數據架構師，數據安全是首要關注的問題，本書重點介紹了保護立方體的關鍵概念。通過閱讀本書，您將了解 SQL Server 安全模型以及如何在數據平台上有效實施相同的方法。

安全在數據平台中至關重要，幸運的是，關於數據訪問的問題可以在設計初期解決。這使您能夠避免任何數據訪問層的違規行為。本書中的指南包含了實施和管理 OLAP 和商業智能安全管理所需的必要要素。通過本書，您將掌握實施和管理安全要素以及保護數據層的關鍵方面。

本書中的指南採用了最佳實踐的實施方法，包括逐步指示，用於根據當前登錄的 Windows 用戶名或基於傳遞給分析服務的自定義數據來實施安全模型。新的商業智能平台功能將幫助最終用戶、業務用戶和技術用戶，為業務用戶提供強大的 IT 環境，用於計劃、預算、預測與記分卡以及報告能力。這些分析將幫助最終用戶創建一個全面的管理應用程序，以輕鬆查看數據。

從本書中您將學到:
- 探索商業智能語義的安全架構。
- 實施安全措施。
- 使用 SQL Server 工具實施安全方法。
- 從立方體級別到單元格級別授予用戶訪問權限。
- 管理不同角色的安全性。
- 控制立方體上的訪問和數據來源。

方法:
本書充滿了實用的、逐步的指示和清晰的解釋，針對最重要和最有用的任務。《立即學習 Microsoft SQL Server Analysis Services 2012 立方體安全》是一本實用的實作指南，提供了一系列清晰的、逐步的練習，讓您快速入門立方體安全。

本書適合對 SQL Server 數據平台進行管理的數據庫管理員、數據架構師和系統管理員。對於已經具有一定技術經驗的分析服務開發人員來說，本書也有益處，他們希望更深入地了解高級主題並學習立方體設計的最佳實踐。