Professional Microsoft SQL Server Analysis Services 2008 with MDX / Sivakumar Harinath ... [et al.].

Format:

Book

Author/Creator:

Harinath, Sivakumar, author.

Contributor:

Harinath, Sivakumar, 1971-

Series:

Wrox professional guides.

Wrox professional guides

Language:

English

Subjects (All):

SQL server.

Client/server computing.

MDX (Computer program language).

OLAP technology.

Relational databases.

Physical Description:

1 online resource (1056 p.)

Edition:

1st edition

Place of Publication:

Hoboken, NJ : Wiley ; Chichester, c2009.

Language Note:

English

System Details:

text file

Summary:

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 solutionsRevised, updated, and enhanced, the book discusses new features such as improved integration with Office and Excel 2007; query performance enhancements; improvements to aggregation designer

Contents:

Professional Microsoft SQL Server Analysis Services 2008 with MDX; About the Authors; Credits; 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 SQL Server 2008 Analysis Services; A Closer Look at Data Warehousing; Key Elements of a Data Warehouse; Inmon Versus Kimball - Different Approaches; Business Intelligence Is Data Analysis; Microsoft Business Intelligence Capabilities

SQL Server Analysis Services 2008The Unified Dimensional Model; Summary; Chapter 2: First Look at Analysis Services 2008; Differences between Analysis Services 2000, Analysis Services 2005, and Analysis Services 2008; Upgrading to Analysis Services 2008; Using 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 Queries; MDX Expressions; Operators; MDX Functions; Summary; Chapter 4: Working with Data Sources and Data Source Views; Data Sources

Data Source ViewsData Source Views in Depth; Multiple Data Sources within a DSV; Summary; Chapter 5: Dimension Design; Working with the Dimension Wizard; Working with the Dimension Designer; 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 the Cube Wizard; Cube Dimensions; Measures and Measure Groups; Calculated Members; Creating Perspectives

Creating TranslationsBrowsing Perspectives and Translations; Summary; Chapter 7: Administering Analysis Services; Administration Using SQL Server 2008 Tools; Online Mode; Summary; Part II: Advanced Topics; 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 Cube

Key Performance Indicators (KPIs)Drillthrough; Actions; Adding Intelligence to the Cube; Working with Partitions; Defining Security; AMO Warnings; Summary; Chapter 10: Advanced Topics in MDX; Calculation Fundamentals; Restricting Cube Space/Slicing Cube Data; Removing Empty Cells; Filtering Members on Axes; Ranking and Sorting; Parameterize Your Queries; MDX Functions; Summary; Chapter 11: Extending MDX Using External Functions; Built -In UDFs; .NET User-Defined Functions (Stored Procedures); COM User-Defined Functions; COM UDFs versus .NET Stored Procedures; Summary

Chapter 12: Data Writeback

Notes:

Includes index.

"Wrox programmer to programmer".

ISBN:

9786612461330

9781118059579

1118059573

9781282461338

1282461338

9780470483718

0470483717

OCLC:

428967071