---

Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer)

ISBN: 0764579185
EAN: 2147483647

Year: 2004
Pages: 176

Authors: Sivakumar Harinath, Stephen R. Quinn

BUY ON AMAZON

• Table of Contents
• Back Cover
• Professional SQL Server Analysis Services 2005 with MDX
• Introduction
• What This Book Covers
• How This Book Is Structured
• What You Need to Use This Book
• Conventions
• Source Code
• Errata
• http:p2p.wrox.com
• Section I: Introduction
• Chapter 1: Introduction to Data Warehousing and Analysis Services 2005
• Key Elements of a Data Warehouse
• Inmon Versus Kimball Different Approaches
• Business Intelligence Is Data Analysis
• Analysis Services 2005
• The Unified Dimensional Model
• Summary
• Chapter 2: First Look at Analysis Services 2005
• Differences between Analysis Services 2000 and Analysis Services 2005
• Upgrading to Analysis Services 2005
• Using the Business Intelligence Development Studio
• Using SQL Server Management Studio
• Querying Using the MDX Query Editor
• Summary
• Chapter 3: Introduction to MDX
• Fundamental Concepts
• MDX Query
• MDX Expressions
• Operators
• MDX Functions
• Summary
• Chapter 4: Working with Data Sources and Data Source Views
• Data Source Views
• Data Source Views in Depth
• Multiple Data Sources within a DSV
• Summary
• Chapter 5: Dimension Design
• Working with the Dimension Editor
• Browsing the Dimension
• Sorting Members of a Level
• Optimizing Attributes
• Defining Translations in Dimensions
• Creating a Snowflake Dimension
• Creating a Time Dimension
• Creating a Parent-Child Hierarchy
• Summary
• Chapter 6: Cube Design
• Creating a Cube using Cube Wizard
• Cube Dimensions
• Measures and Measure Groups
• Calculated Members
• Creating Perspectives
• Creating Translations
• Browsing Perspectives and Translations
• Summary
• Section II: Advanced Topics
• Chapter 7: Advanced Topics in MDX
• Restricting Cube SpaceSlicing Cube Data
• Removing Empty Cells
• Filtering Members on Axes
• Ranking and Sorting
• Parameterize Your Queries
• New MDX Functions
• Summary
• Chapter 8: Advanced Dimension Design
• Custom Rollups
• Enhancements to Parent-Child Hierarchies
• Using Properties to Customize Dimensions
• Dimension Intelligence using the Business Intelligence Wizard
• Server Time Dimension
• Dimension Writeback
• Summary
• Chapter 9: Advanced Cube Design
• Adding and Enhancing Dimensions
• Adding Calculations to Your Cube
• Key Performance Indicators (KPIs)
• Drill-Through
• Adding Intelligence to the Cube
• Working with Partitions
• Defining Security
• Summary
• Chapter 10: Extending MDX using External Functions
• COM User Defined Functions
• Built-in COM UDFs
• .NET User Defined Functions (Stored Procedures)
• COM UDFs vs .NET Assemblies
• Summary
• Section III: Administration, Performance Tuning Integration
• Chapter 11: Updating Your UDM Data
• Updating Your Cube Data
• Summary
• Chapter 12: Administering Analysis Services
• Online Mode
• Administration via Programming
• HTTP Connectivity to Analysis Services
• Legacy DSO Applications
• Analysis Services and Fail-over Clustering
• Summary
• Chapter 13: Performance Optimization
• Optimizing UDM Design
• Optimize for Processing
• Query Performance Improvement
• Scalability Optimizations
• Using Profiler to Analyze Performance
• Summary
• Chapter 14: Data Mining
• The Data Mining Process
• Real-World Applications
• Data Mining Algorithms in Analysis Services 2005
• Working with Mining Models
• Summary
• Chapter 15: Analyzing Cubes using Office Client Components
• Creating Local Cubes from Excel
• Office Web Component Pivot Table
• Analyzing UDM Data using Microsoft Data Analyzer
• Summary
• Chapter 16: Integration Services
• Creating an Integration Services Project
• Creating Integration Services Packages for Analysis Services Operations
• Automating SSIS Packages
• Summary
• Section IV: Scenarios
• Chapter 17: Reporting Services
• Report Designer
• Report Server
• Creating a Report on Relational Database
• Creating Reports Based on a UDM
• Managing Your Analysis Services Reports
• Ad-Hoc Reports using Report Builder
• Summary
• Chapter 18: Designing Real-Time Cubes
• Proactive Caching
• Proactive Caching at Work
• Long Latency Scenario
• Average Latency Scenario
• No Latency Scenario
• Summary
• Chapter 19: Securing Your Data in Analysis Services
• Securing Your Source Data
• Securing Your Dimension Data
• Securing your Cube Data
• Summary
• Appendix A: MDX Function and Operator Reference
• Basic Operators
• Index
• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X
• Y
• List of Figures
• List of Tables
• List of Code Examples