Cargando…
Professional Microsoft SQL server 2012 analysis services with MDX and DAX /
Understand Microsoft's dramatically updated new release of its premier toolset for business intelligence The first major update to Microsoft's state-of-the-art, complex toolset for business intelligence (BI) in years is now available and what better way to master it than with this detailed...
| Clasificación: | Libro Electrónico |
|---|---|
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Indianapolis, IN :
John Wiley & Sons,
©2012.
|
| Temas: | |
| Acceso en línea: | Texto completo |
Tabla de Contenidos:
- Cover; Part I: Introduction; Chapter 1: Introduction; BISM Multidimensional Mode; BISM Tabular Mode; SQL Server Analysis Services 2012; Summary; Part II: Designing Multidimensional BISM; Chapter 2: A First Look at Multidimensional BISM; Development, Administrative, and Client Tools; Upgrading to Analysis Services 2012; Using SQL Server Data Tools to Build Analysis Services Multidimensional Applications; Using SQL Server Management Studio; Querying Using the MDX Query Editor; Summary; Chapter 3: Understanding MDX; What Is MDX?; MDX Concepts; MDX Queries; MDX Expressions; MDX Operators.
- MDX FunctionsMDX Scripts; Restricting Cube Space/Slicing Cube Data; Parameterized MDX Queries; MDX Comments; Summary; Chapter 4: Data Sources and Data Source Views; Data Sources; Data Source Views; Data 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 DesignThe BISM Multidimensional mode; Creating a Cube Using the Cube Wizard; Cube Dimensions; Measures and Measure Groups; Calculated Members; Creating Perspectives; Creating Translations; Browsing Perspectives and Translations; Summary; Chapter 7: Administration and Management; Administration Using SQL Server 2012 Tools; Online Mode; Programmatic and Advanced Administration; Analysis Management Objects (AMO); Resource and Activity Monitoring; HTTP Connectivity to Analysis Services; Analysis Services and FailOver Clustering; Summary; Part III: Advanced Topics in BISM.
- Chapter 8: Advanced Dimension DesignCustom 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; Real-Time Cubes; Defining Security; Cell Writeback; AMO Warnings; Summary.
- Chapter 10: Designing Mulitdimensional BISM for PerformanceOptimizing Multidimensional BISM Design; Optimizing for Processing; Designing Aggregations; Managing Aggregation Designs; Scalability Optimizations; Summary; Chapter 11: Optimizing Query Performance; How OLAP Enhances Performance; The Calculation Model; Query Execution Architecture; Performance Analysis and Tuning Tools; Analyzing Query Performance Issues; Query Optimization Techniques; Scale Out with Read-Only Database; Writeback Query Performance; Summary.