Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer)
Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer)
ISBN: 0764579185
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 176
Pages: 176
Authors: Sivakumar Harinath, Stephen R. Quinn
- 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
Professional SQL Server Analysis Services 2005 with MDX (Programmer to Programmer)
ISBN: 0764579185
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 176
Pages: 176
Authors: Sivakumar Harinath, Stephen R. Quinn