Content: 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
Abstract: 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 book from key members of the product's development team? If you're a database or data warehouse developer, this is the expert resource you need to build full-scale, multi-dimensional, database applications using Microsoft's new SQL Server 2012 Analysis Services and related tools. Discover how to solve real