Professional Microsoft® Sql Server® 2012 Analysis Services with MDX and DAX -- 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 -- BISM Multidimensional Mode -- A Closer Look at Data Warehousing -- Key Elements of a Data Warehouse -- Fact Tables -- Dimension Tables -- Dimensions -- Cubes -- The Star Schema -- The Snowflake Schema -- Inmon Versus Kimball?-?Different Approaches -- Business Intelligence Is Data Analysis -- BISM Tabular Mode -- SQL Server Analysis Services 2012 -- The Business Intelligence Semantic Model -- Data Model -- Query Language -- Data Access Technology -- 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 -- Creating a Project Using SQL Server Data Tools -- The Solution Explorer -- The Properties Window -- The Output Window -- Creating an Analysis Services Database Using SQL Server Data Tools -- Creating a Data Source -- Creating a Data Source View (DSV) -- Creating a Cube Using the Cube Wizard -- Deploying and Browsing a Cube -- Using SQL Server Management Studio -- The Object Explorer Pane -- Querying Using the MDX Query Editor -- Summary -- Chapter 3: Understanding MDX -- What Is MDX? -- MDX Concepts -- Measures and Measure Groups -- Hierarchies and Hierarchy Levels -- Members -- Cells -- Tuples -- Sets -- MDX Queries -- SELECT Statement and Axis Specification -- FROM Clause and Cube Specification -- Subselect Clauses -- WHERE Clause and Slicer Specification -- Slicer Dimension.

WITH Clause, Named Sets, and Calculated Members -- Named Sets -- Calculated Members -- Ranking and Sorting -- MDX Expressions -- MDX Operators -- Arithmetic Operators -- Set Operators -- Comparison Operators -- Logical Operators -- Special MDX Operators?-?Curly Braces, Commas, and Colons -- MDX Functions -- MDX Function Categories -- Set Functions -- Crossjoin -- NONEMPTYCROSSJOIN and NONEMPTY -- Filter and Having -- Member Functions -- Numeric Functions -- Dimension Functions, Level Functions, and Hierarchy Functions -- String Manipulation Functions -- Other Functions -- MDX Scripts -- MDX Script Execution -- CALCULATE Statement -- Cube Space -- AUTO EXISTS -- Cell Calculations and Assignments -- Recursion -- Freeze Statement -- Restricting Cube Space/Slicing Cube Data -- SCOPE Statement -- CREATE and DROP SUBCUBE -- Using EXISTS -- Using EXISTING -- Using SUBSELECT -- Parameterized MDX Queries -- MDX Comments -- Summary -- Chapter 4: Data Sources and Data Source Views -- Data Sources -- Data Sources Supported by Analysis Services -- .NET Versus OLE DB Data Providers -- .NET Framework Data Providers -- OLE DB Data Providers -- The Trade-Offs -- Data Source Views -- DSV Wizard -- DSV Designer -- Adding/Removing Tables in a DSV -- Specifying Primary Keys and Relationships in the DSV -- Customizing Your Tables in the DSV Designer -- Data Source Views in Depth -- Diagrams -- Data Source View Properties -- Different Layouts in DSVs -- Validating Your DSV and Initial Data Analysis -- Multiple Data Sources Within a DSV -- Summary -- Chapter 5: Dimension Design -- Working with the Dimension Wizard -- Working with the Dimension Designer -- Attributes -- Attribute Relationships -- User Hierarchies -- 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 BISM Multidimensional Mode -- Creating a Cube Using the Cube Wizard -- Browsing Cubes -- Cube Dimensions -- Relationship Types -- No Relationship -- Regular Relationships -- Fact Relationships -- Many-to-Many Relationships -- Data Mining Relationships -- Referenced Relationships -- Browsing Reference Dimensions in Excel -- Measures and Measure Groups -- Calculated Members -- Calculated Measures -- Querying Calculated Measures -- Creating Perspectives -- Creating Translations -- Browsing Perspectives and Translations -- Summary -- Chapter 7: Administration and Management -- Administration Using SQL Server 2012 Tools -- Managing Analysis Servers -- Managing Analysis Services Objects -- Database Creation -- Processing Analysis Services Database Objects -- Processing a Cube -- Processing a Dimension -- Managing Partitions -- Managing Assemblies -- Backup and Restore -- Detach and Attach -- Synchronization -- Managing Security -- Server and Database Roles -- Enabling or Disabling Features -- Online Mode -- Programmatic and Advanced Administration -- Analysis Management Objects (AMO) -- Processing Analysis Services Databases -- Back Up and Restore -- Adding Assemblies to Analysis Services -- PowerShell and Analysis Services -- Resource and Activity Monitoring -- HTTP Connectivity to Analysis Services -- Analysis Services and FailOver Clustering -- Summary -- Chapter 8: Advanced Dimension Design -- Custom Rollups -- Enhancements to Parent-Child Hierarchies -- Unary Operators -- Specifying Names of Levels in a Parent-Child Hierarchy -- Using Properties to Customize Dimensions -- Ordering Dimension Members -- The All Member, Default Member, and Unknown Member.

Error Configurations for Processing -- Storage Mode -- Grouping Members -- Dimension Intelligence Using the Business Intelligence Wizard -- Account Intelligence -- Time Intelligence -- Dimension Intelligence -- Server Time Dimension -- Dimension Writeback -- Summary -- Chapter 9: Advanced Cube Design -- Measure Groups and Measures -- Adding and Enhancing Dimensions -- Fact Dimensions -- Many-to-Many Dimensions -- Data Mining Dimensions -- Role-Playing Dimensions -- Adding Calculations to Your Cube -- Key Performance Indicators (KPIs) -- KPI Creation -- KPIs in Depth -- Using ADOMD.NET to Query KPIs -- Drillthrough -- Actions -- Action Types -- Action Target Types -- URL Action -- Browse URL Action in the Cube Browser -- Report Actions -- Drillthrough Action -- Adding Intelligence to the Cube -- Semiadditive Measures -- Currency Conversion -- Working with Partitions -- Building a Local Partition -- Building a Remote Partition -- Storage Modes and Storage Settings -- Building Aggregations -- The Aggregation Design Process -- Usage-Based Optimization -- Real-Time Cubes -- Long Latency Scenario -- Caching After Data Change -- Caching Using Timed Updates -- Average Latency Scenario -- Caching with MOLAP Storage Option -- No Latency Scenario -- Real-Time ROLAP Storage Option -- Defining Security -- Cell Writeback -- Cell Writeback Prerequisites -- Writeback Statement -- Update Nonleaf Cell Value Using Allocation -- Equal Allocation -- Weighted Allocation -- Incremental Allocation -- Cautions -- AMO Warnings -- Design Experience -- Dismissing Warnings -- Warnings Designer -- Summary -- Chapter 10: Designing Mulitdimensional BISM for Performance -- Optimizing Multidimensional BISM Design -- Fine-Tuning Your Dimensions -- Choosing the Right Key Attribute -- Avoiding Unnecessary Attributes.

Turning Off Optimization for Rarely Used Attributes -- Turning Off AttributeHierarchy for Member Properties -- Defining Relationships between Attributes -- Fine-Tuning Your Cube -- Fact Table ? Measure Groups or Partitions -- Optimizing Reference Dimensions -- Many-to-Many Dimensions -- Partitions -- Merging Partitions -- Partition Slices -- Partition Slices and ROLAP -- A Partition Slice Example -- Distinct Count Partitioning -- Optimizing for Processing -- Creating Partitions to Speed Up Processing -- Choosing Small and Appropriate Data Types and Sizes -- SQL Server and Analysis Services Installations -- Optimizing a Relational Data Source -- Avoiding Excessive Aggregation Design -- Using Incremental Processing When Appropriate -- Parallelism during Processing -- Identifying Resource Bottlenecks -- Designing Aggregations -- Understanding Aggregations -- Creating Aggregations -- Applying Aggregation Design -- Usage-Based Aggregation Design -- Aggregation Design Options -- Designing Efficient Aggregations Using Hints -- Relationships between Attributes -- Properties Controlling Attributes and Aggregation Design -- Managing Aggregation Designs -- Scalability Optimizations -- Configuring Server Configuration Properties -- Scaling Out -- Scaling Up -- Handling Large Dimensions -- Summary -- Chapter 11: Optimizing Query Performance -- How OLAP Enhances Performance -- The Calculation Model -- MDX Scripts -- Scope and Assignments -- Dimension Attribute Calculations -- Session and Query Calculations -- Query Execution Architecture -- Analysis Services Engine Components -- Stages of Query Execution -- Query Evaluation Modes -- Cell-by-Cell Mode -- Subspace Computation -- Performance Analysis and Tuning Tools -- SQL Server Profiler -- Analysis Services Trace Events -- Performance Monitor -- Task Manager.

SQL Server Management Studio.