Description |
1 online resource (xxvi, 828 pages) : illustrations |
Series |
Wrox professional guides |
|
Wrox professional guides.
|
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 |
Notes |
Copyright © Wrox 2006 |
|
Print version record |
SUBJECT |
SQL server. http://id.loc.gov/authorities/names/n90684343
|
|
SQL server. blmlsh |
|
SQL server fast |
Subject |
Client/server computing.
|
|
Relational databases.
|
|
MDX (Computer program language)
|
|
REFERENCE -- General.
|
|
Client/server computing
|
|
MDX (Computer program language)
|
|
Relational databases
|
Genre/Form |
Electronic book
|
Form |
Electronic book
|
Author |
Quinn, Stephen R., 1962-
|
LC no. |
2005032272 |
ISBN |
0471927198 |
|
9780471927198 |
|