You are previewing Professional Microsoft® SQL Server® Analysis Services 2008 with MDX.
O'Reilly logo
Professional Microsoft® SQL Server® Analysis Services 2008 with MDX

Book Description

  • When used with the MDX query language, SQL Server Analysis Services allows developers to build full-scale database applications to support such business functions as budgeting, forecasting, and market analysis.

  • Shows readers how to build data warehouses and multi-dimensional databases, query databases, and use Analysis Services and other components of SQL Server to provide end-to-end solutions

  • Revised, updated, and enhanced, the book discusses new features such as improved integration with Office and Excel 2007; query performance enhancements; improvements to aggregation designer, dimension designer, cube and dimension wizards, and cell writeback; extensibility and personalization; data mining; and more

  • Table of Contents

    1. Copyright
    2. Dedication
    3. About the Authors
    4. Credits
    5. Acknowledgments
    6. Introduction
    7. Introduction
      1. Introduction to Data Warehousing and SQL Server 2008 Analysis Services
        1. A Closer Look at Data Warehousing
        2. Key Elements of a Data Warehouse
        3. Inmon Versus Kimball — Different Approaches
        4. Business Intelligence Is Data Analysis
        5. Microsoft Business Intelligence Capabilities
        6. SQL Server Analysis Services 2008
        7. The Unified Dimensional Model
        8. Summary
      2. First Look at Analysis Services 2008
        1. Differences between Analysis Services 2000, Analysis Services 2005, and Analysis Services 2008
        2. Upgrading to Analysis Services 2008
        3. Using Business Intelligence Development Studio
        4. Using SQL Server Management Studio
        5. Querying Using the MDX Query Editor
        6. Summary
      3. Introduction to MDX
        1. What Is MDX?
        2. Fundamental Concepts
        3. MDX Queries
        4. MDX Expressions
        5. Operators
        6. MDX Functions
        7. Summary
      4. Working with Data Sources and Data Source Views
        1. Data Sources
        2. Data Source Views
        3. Data Source Views in Depth
        4. Multiple Data Sources within a DSV
        5. Summary
      5. Dimension Design
        1. Working with the Dimension Wizard
        2. Working with the Dimension Designer
        3. Browsing the Dimension
        4. Sorting Members of a Level
        5. Optimizing Attributes
        6. Defining Translations in Dimensions
        7. Creating a Snowflake Dimension
        8. Creating a Time Dimension
        9. Creating a Parent-Child Hierarchy
        10. Summary
      6. Cube Design
        1. The Unified Dimensional Model
        2. Creating a Cube Using the Cube Wizard
        3. Cube Dimensions
        4. Measures and Measure Groups
        5. Calculated Members
        6. Creating Perspectives
        7. Creating Translations
        8. Browsing Perspectives and Translations
        9. Summary
      7. Administering Analysis Services
        1. Administration Using SQL Server 2008 Tools
        2. Online Mode
        3. Summary
    8. Advanced Topics
      1. Advanced Dimension Design
        1. Custom Rollups
        2. Enhancements to Parent-Child Hierarchies
        3. Using Properties to Customize Dimensions
        4. Dimension Intelligence Using the Business Intelligence Wizard
        5. Server Time Dimension
        6. Dimension Writeback
        7. Summary
      2. Advanced Cube Design
        1. Measure Groups and Measures
        2. Adding and Enhancing Dimensions
        3. Adding Calculations to Your Cube
        4. Key Performance Indicators (KPIs)
        5. Drillthrough
        6. Actions
        7. Adding Intelligence to the Cube
        8. Working with Partitions
        9. Defining Security
        10. AMO Warnings
        11. Summary
      3. Advanced Topics in MDX
        1. Calculation Fundamentals
        2. Restricting Cube Space/Slicing Cube Data
        3. Removing Empty Cells
        4. Filtering Members on Axes
        5. Ranking and Sorting
        6. Parameterize Your Queries
        7. MDX Functions
        8. Summary
      4. Extending MDX Using External Functions
        1. Built-In UDFs
        2. .NET User-Defined Functions (Stored Procedures)
        3. COM User-Defined Functions
        4. COM UDFs versus .NET Stored Procedures
        5. Summary
      5. Data Writeback
        1. Dimension Writeback
        2. Cell Writeback
        3. Summary
    9. Advanced Administration and Performance Optimization
      1. Programmatic and Advanced Administration
        1. Analysis Management Objects (AMO)
        2. Resource and Activity Monitoring
        3. HTTP Connectivity to Analysis Services
        4. Analysis Services and Fail-Over Clustering
        5. Summary
      2. Designing for Performance
        1. Optimizing UDM Design
        2. Optimizing for Processing
        3. Designing Aggregations
        4. Managing Aggregation Designs
        5. Scalability Optimizations
        6. Summary
      3. Analyzing and Optimizing Query Performance
        1. The Calculation Model
        2. Query Execution Architecture
        3. Performance Analysis and Tuning Tools
        4. Analyzing Query Performance Issues
        5. Query Optimization Techniques
        6. Scale Out with Read-Only Database
        7. Writeback Query Performance
        8. Summary
    10. Integration with Microsoft Products
      1. Data Mining
        1. The Data Mining Process
        2. Real-World Applications
        3. Data Mining Algorithms in SQL Server Analysis Services 2008
        4. Working with Mining Models
        5. Summary
      2. Analyzing Cubes Using Microsoft Office Components
        1. Analyzing Data in Excel 2007
        2. ProClarity
        3. Microsoft Performance Point Server 2007
        4. Summary
      3. Using Data Mining with Office 2007
        1. Configuring Your SSAS
        2. Table Analytics
        3. Data Mining Tools
        4. Visio Add-In
        5. Summary
      4. Integration Services
        1. Creating an Integration Services Project
        2. Creating Integration Services Packages for Analysis Services Operations
        3. Automating Execution of SSIS Packages
        4. Summary
      5. Reporting Services
        1. Report Designer
        2. Report Server
        3. Creating a Report on a Relational Database
        4. Creating Reports Based on a UDM
        5. Managing Your Analysis Services Reports
        6. Ad-Hoc Reports Using Report Builder
        7. Summary
    11. Scenarios
      1. Designing Real-Time Cubes
        1. Proactive Caching
        2. Proactive Caching at Work
        3. Long Latency Scenario
        4. Average Latency Scenario
        5. No Latency Scenario
        6. Summary
      2. Securing Your Data in Analysis Services
        1. Securing Your Source Data
        2. Securing Your Dimension Data
        3. Securing Your Cube Data
        4. Summary
      3. Inventory Scenarios
        1. Inventory Control and Orders
        2. Forecasting
        3. Understanding Inventory
        4. Summary
      4. Financial Scenarios
        1. Presenting Budget Information
        2. Currency Conversion Scenario (m:n)
        3. Precision Considerations
        4. Employee Scenario (P/C)
        5. Custom Rollup Scenarios
        6. Summary
      5. Web Analytics
        1. What Is Web Analytics?
        2. Collecting Data
        3. Transforming Web Log Data
        4. Step-by-Step Guide
        5. Summary
      6. MDX Functions
    12. Index