Find a copy online
Links to this item
Find a copy in the library
Finding libraries that hold this item...
|Material Type:||Document, Internet resource|
|Document Type:||Internet Resource, Computer File|
|All Authors / Contributors:||
|ISBN:||9781118223437 1118223438 9781118237083 1118237080 9781118262092 1118262093 1118101103 9781118101100|
|Notes:||"Wrox Programmer to programmer"--Cover.
|Description:||1 online resource|
|Contents:||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.|
|Other Titles:||Microsoft SQL Server 2012 Analysis Services with MDX and DAX|
|Responsibility:||Sivakumar Harinath [and others].|