Cargando…

Professional Microsoft SQL Server Analysis Services 2008 with MDX /

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 databas...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Harinath, Sivakumar, 1971- (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Indianapolis, Ind. : Wrox Press/Wiley Pub., ©2009.
Colección:Wrox professional guides.
Temas:
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • 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