Professional SQL server analysis services 2005 with MDX
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 vari...
| Autor principal: | |
|---|---|
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, IN :
Wrox/Wiley Pub
c2006.
|
| Edición: | 1st edition |
| Colección: | Wrox professional guides.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627356106719 |
Tabla de Contenidos:
- 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
