PacktLib: Getting Started with SQL Server 2012 Cube Development

Getting Started with SQL Server 2012 Cube Development

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

Self-service Business Intelligence, Creating Value from Data

Identifying common user requirements for a BI system

Creating a flexible reporting solution

Getting user value through self-service reporting

Summary

Installing SSAS and Preparing for Cube Development

Understanding the BI semantic model architecture

Choosing the deployment mode

Installing Analysis Services 2012 in multidimensional mode

Starting SQL Server Data Tools for the first time

Choosing the correct project

Navigating the project environment

Hands-on steps for configuring your cube project

Summary

Creating Your First Multidimensional Cube

An introduction to data warehousing

Understanding data sources

Understanding the data source view

Adding objects to the data source view

Understanding dimensions

Creating the first cube

Creating additional dimensions and adding them to the cube

Summary

Deploying and Processing Cubes

Deploying objects to Analysis Services

Processing objects in Analysis Services

Partitioning cubes to speed up processing

Configuring storage modes in Analysis Services

Summary

Querying Your Cube

Understanding multidimensionality

Writing MDX queries using Management Studio

Understanding the anatomy of an MDX query

Using Excel as the query tool against cubes

Connecting Excel to the FirstCube cube

Using Reporting Services together with your cube

Summary

Adding Functionality to Your Cube

Adding measures

Adding dimensions to the FirstCube project

Adding calculations to cubes

Adding perspectives to simplify cube browsing

Adding translations to support global implementations

Extending the cube with custom actions

Building budget solutions using writeback

Summary

Securing Your Cube Project

Understanding role-based security

Securing objects in Analysis Services

Summary

Using Aggregations to Performance Optimize a Cube

Understanding cube aggregations

Adding aggregations to improve performance

Running the aggregation wizard

Adding aggregations manually

Using usage-based optimization to optimize the cube

Summary

In-memory, the Future

Understanding tabular models

Installing a tabular mode instance

Creating a tabular mode project

Defining the workspace server

Connecting to the data source

Adding tables to the data model

Adding data from other data sources

Working with partitions in tabular models

Creating calculations

Specifying other types of tables and columns

KPIs

Adding hierarchies

Sorting data based on other columns

Hiding columns and tables from the end users

Creating perspectives

Adding security to your in-memory model

Optimizing the tabular model for performance

Querying tabular models

Summary

Cubes in the Larger Context

Using Microsoft frontend tools to query Analysis Services

Third-party tools

Summary

Index