Professional SQL server analysis services 2005 with MDX / Sivakumar Harinath, Stephen R. Quinn.

Format:

Book

Author/Creator:

Harinath, Sivakumar, 1971-

Contributor:

Quinn, Stephen R., 1962-

Series:

Wrox professional guides.

Wrox professional guides

Language:

English

Subjects (All):

SQL server.

Client/server computing.

Relational databases.

MDX (Computer program language).

Genre:

Electronic books.

Physical Description:

1 online resource (859 p.)

Edition:

1st edition

Other Title:

SQL server analysis services 2005 with MDX

Professional Structured Query Language server analysis services 2005 with MultiDimensional eXpressions

Place of Publication:

Indianapolis, IN : Wrox/Wiley Pub., c2006.

Language Note:

English

System Details:

text file

Summary:

Written by the lead developers of Analysis Services at Microsoft, this book begins with an overview showing how Analysis Services and MDX can be used to build data warehouses and multidimensional databasesThe authors then describe the development processes for building dimensions and cubes from various data sourcesDemonstrating a variety of techniques in real-world scenarios, the book shows how MDX can be used to query databases to provide sophisticated analysis of business problemsFinally, the book explains how Analysis Services can be used with other components of SQL Ser

Contents:

Professional SQL Server Analysis Services 2005 with MDX; About the Authors; Acknowledgments; Contents; Introduction; Who This Book Is For; What This Book Covers; How This Book Is Structured; What You Need to Use This Book; Conventions; Source Code; Errata; p2p.wrox.com; Part I Introduction; Chapter 1 Introduction to Data Warehousing and Analysis Services 2005; A Closer Look at Data Warehousing; 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 2005Differences 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; What Is MDX?; Fundamental Concepts; MDX Query; MDX Expressions; Operators; MDX Functions; Summary; Chapter 4 Working with Data Sources and Data Source Views; Data Source; Data Source Views; Data Source Views in Depth; Multiple Data Sources within a DSV; Summary

Chapter 5 Dimension DesignWorking with the Dimension Wizard; 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; The Unified Dimensional Model; Creating a Cube using Cube Wizard; Cube Dimensions; Measures and Measure Groups; Calculated Members; Creating Perspectives; Creating Translations; Browsing Perspectives and Translations; Summary; Part II Advanced Topics

Chapter 7 Advanced Topics in MDXCalculation Fundamentals; Restricting Cube Space/Slicing 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; Measure Groups and Measures; Adding and Enhancing Dimensions

Adding Calculations to Your CubeKey Performance Indicators (KPIs); Drill-Through; Actions; 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; Part III Administration, Performance Tuning Integration; Chapter 11 Updating Your UDM Data; Updating Dimension Data in UDM; Updating Your Cube Data; Summary; Chapter 12 Administering Analysis Services

Administration using SQL Server 2005 Tools

Notes:

Includes index.

"Programmer to programmer"--Cover.

ISBN:

9786610450329

9781280450327

1280450320

9780471927198

0471927198

OCLC:

77492975