Expert Cube Development with Microsoft SQL Server 2008 Analysis Services (Paperback)

Marco Russo, Alberto Ferrari, Chris Webb

  • 出版商: Packt Publishing
  • 出版日期: 2009-07-16
  • 售價: $2,130
  • 貴賓價: 9.5$2,024
  • 語言: 英文
  • 頁數: 360
  • 裝訂: Paperback
  • ISBN: 1847197221
  • ISBN-13: 9781847197221
  • 相關分類: MSSQLSQL
  • 無法訂購

買這商品的人也買了...

商品描述

Design and implement fast, scalable and maintainable cubes

  • A real-world guide to designing cubes with Analysis Services 2008
  • Model dimensions and measure groups in BI Development Studio
  • Implement security, drill-through, and MDX calculations
  • Learn how to deploy, monitor, and performance-tune your cube
  • Filled with best practices and useful hints and tips

In Detail

Microsoft's SQL Server Analysis Services 2008 is an OLAP server that allows users to analyze business data quickly and easily. However, designing cubes in Analysis Services can be a complex task: it's all too easy to make mistakes early on in development that lead to serious problems when the cube is in production. Learning the best practices for cube design before you start your project will help you avoid these problems and ensure that your project is a success.

This book offers practical advice on how to go about designing and building fast, scalable, and maintainable cubes that will meet your users' requirements and help make your Business Intelligence project a success.

This book gives readers insight into the best practices for designing and building Microsoft Analysis Services 2008 cubes. It also provides details about server architecture, performance tuning, security, and administration of an Analysis Services solution.

In this book, you will learn how to design and implement Analysis Services cubes. Starting from designing a data mart for Analysis Services, through the creation of dimensions and measure groups, to putting the cube into production, we'll explore the whole of the development lifecycle.

This book is an invaluable guide for anyone who is planning to use Microsoft Analysis Services 2008 in a Business Intelligence project.

What you will learn from this book?

  • Build a data mart suitable for use with Analysis Services
  • Create and configure an Analysis Services project in Business Intelligence Development Studio
  • Use the Dimension Wizard and the Dimension Editor to build dimensions
  • Create measure groups and associate them with dimensions
  • Add calculations to the cube, including implementing currency conversion and a date tool dimension
  • Explore the security model, including dimension security and cell security, and implement dynamic security
  • Tune queries to get the best possible performance
  • Automate processing and partition creation
  • Monitor your cube to see who's actually using it

Approach

This is a practical tutorial for Analysis Services that shows readers how to solve problems commonly encountered while designing cubes, and explains which features of Analysis Services work well and which should be avoided. The book walks through the whole cube development lifecycle, from building dimensions, cubes and calculations to tuning and moving the cube into production.

Who this book is written for?

This book is aimed at Analysis Services developers who already have some experience but who want to go into more detail on advanced topics, and who want to learn best practices for cube design.

商品描述(中文翻譯)

設計並實現快速、可擴展和易於維護的立方體
- 一本實用指南,教你如何使用 Analysis Services 2008 設計立方體
- 在 BI Development Studio 中建模維度和度量組
- 實現安全性、鑽取和 MDX 計算
- 學習如何部署、監控和調優立方體
- 充滿最佳實踐和有用的提示

詳細內容
Microsoft 的 SQL Server Analysis Services 2008 是一個 OLAP 伺服器,允許用戶快速且輕鬆地分析業務數據。然而,在 Analysis Services 中設計立方體可能是一項複雜的任務:在開發初期犯錯誤很容易導致立方體在生產環境中出現嚴重問題。在開始項目之前學習立方體設計的最佳實踐將幫助您避免這些問題,確保項目的成功。

本書提供了實用的建議,教你如何設計和構建快速、可擴展和易於維護的立方體,以滿足用戶的需求,並使您的商業智能項目取得成功。

本書為讀者提供了設計和構建 Microsoft Analysis Services 2008 立方體的最佳實踐。它還提供了有關伺服器架構、性能調優、安全性和管理 Analysis Services 解決方案的詳細信息。

在本書中,您將學習如何設計和實施 Analysis Services 立方體。從為 Analysis Services 設計數據集市開始,通過創建維度和度量組,最終將立方體投入生產,我們將探索整個開發生命周期。

本書對於計劃在商業智能項目中使用 Microsoft Analysis Services 2008 的任何人來說都是一本寶貴的指南。

本書的內容包括:
- 構建適用於 Analysis Services 的數據集市
- 在 Business Intelligence Development Studio 中創建和配置 Analysis Services 項目
- 使用維度精靈和維度編輯器構建維度
- 創建度量組並將其與維度關聯
- 向立方體添加計算,包括實現貨幣轉換和日期工具維度
- 探索安全模型,包括維度安全性和單元格安全性,並實施動態安全性
- 調優查詢以獲得最佳性能
- 自動化處理和分區創建
- 監控立方體以查看實際使用情況

方法
這是一本實用的 Analysis Services 教程,向讀者展示了在設計立方體時常遇到的問題以及哪些 Analysis Services 功能適用,哪些應該避免。本書從構建維度、立方體和計算,到調優和將立方體投入生產,全面介紹了立方體開發的整個生命周期。

本書的讀者對 Analysis Services 開發已有一定經驗,但希望深入研究高級主題並學習立方體設計的最佳實踐。