Getting started with SQL server 2012 cube development : learn to develop and query Analysis Services cubes and models, with a practical, step-by-step approach / Simon Lidberg ; graphics, Yuvraj Mannari.

Format:

Book

Author/Creator:

Lidberg, Simon.

Contributor:

Mannari, Yuvraj.

Language:

English

Subjects (All):

SQL server.

Client/server computing.

Relational databases.

Physical Description:

1 online resource (288 p.)

Edition:

1st ed.

Place of Publication:

Birmingham : Packt Publishing, 2013.

Language Note:

English

Biography/History:

Lidberg Simon: Simon Lidberg is a database veteran, who has worked in the Computer industry since the mid nineties. He has had roles as Consultant, Support Engineer, Escalation Engineer, and Technical Presales Specialist. In the past 15 years, he has worked with databases and ERP Systems at companies such as Digital Equipment, Compaq, and Microsoft. He has been an expert in Microsoft SQL Server since he started to work with Version 6. 5 at Microsoft as a Support Engineer. Since 2006, he has worked with the Microsoft Business Intelligence stack that includes Analysis Services. Since then, he has helped numerous companies to start using Analysis Services as well as have trained hundreds of people on Microsoft BI. Simon is also a frequent speaker at conferences such as PASS SQLRally and Microsoft TechDays. He currently blogs at http: //blogs. msdn. com/b/querysimon

Summary:

As a practical tutorial for Analysis Services, get started with developing cubes. "Getting Started with SQL Server 2012 Cube Development" walks you through the basics, working with SSAS to build cubes and get them up and running.Written for SQL Server developers who have not previously worked with Analysis Services. It is assumed that you have experience with relational databases, but no prior knowledge of cube development is required. You need SQL Server 2012 in order to follow along with the exercises in this book.

Contents:

Intro

Getting Started with SQL Server 2012 Cube Development

Table of Contents

Credits

About the Author

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers and more

Why Subscribe?

Free Access for Packt account holders

Instant Updates on New Packt Books

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code

Errata

Piracy

Questions

1. 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

2. Installing SSAS and Preparing for Cube Development

Understanding the BI semantic model architecture

Choosing the deployment mode

Actions

Aggregations

Custom assemblies

Custom rollups

Distinct count

Linked objects

Many-to-many relationships

Parent-child hierarchies

Translations

Writeback

Tool support

Installing Analysis Services 2012 in multidimensional mode

Hands-on steps for installing Analysis Services

Hands-on steps for attaching the sample database

Starting SQL Server Data Tools for the first time

Choosing the correct project

Hands-on steps for creating your first cube project

Navigating the project environment

Solution Explorer

Properties window

Build menu

Hands-on steps for configuring your cube project

3. Creating Your First Multidimensional Cube

An introduction to data warehousing

Understanding data sources

Creating the data connection

Understanding the data source view

Creating a new data source view

Adding objects to the data source view.

Extending the data source view

Understanding dimensions

Creating the Date dimension

Preparing the Date dimension for end users

Renaming attributes

Creating a hierarchy and attribute relationships

Processing the dimension to review the results

Creating the first cube

Creating the Fact Internet Sales cube

Creating additional dimensions and adding them to the cube

4. Deploying and Processing Cubes

Deploying objects to Analysis Services

Deploying the FirstCube project to the server

Deploying projects using advanced deployment strategies

Processing objects in Analysis Services

Processing the FirstCube project

Using advanced processing options when processing cubes

Scheduling processing

Building a SSIS package to control processing

Troubleshooting processing errors

Partitioning cubes to speed up processing

Adding partitions to the FirstCube cube

Configuring storage modes in Analysis Services

MOLAP

ROLAP

HOLAP

Proactive caching

Adding a ROLAP dimension to the FirstCube cube

5. Querying Your Cube

Understanding multidimensionality

Writing MDX queries using Management Studio

Connecting to the cube using Management Studio

Understanding the anatomy of an MDX query

The FROM clause

The WHERE clause

The query axis clause

Important query concepts

Unique names

Finding unique names of objects

Tuples

Sets

Calculated members

Named sets

Functions

Using Excel as the query tool against cubes

Connecting Excel to the FirstCube cube

Advanced Excel features

Calculated measures

Using Reporting Services together with your cube

6. Adding Functionality to Your Cube

Adding measures

Adding additional measure groups

Adding dimensions to the FirstCube project.

Adding referenced dimensions

Adding many-to-many dimensions

Adding dimensions with parent-child hierarchies

Adding calculations to cubes

Simple calculated measures

Adding advanced calculated measures

Adding calculated members

Time and date calculations

Key Performance Indicators

Adding perspectives to simplify cube browsing

Adding translations to support global implementations

Extending the cube with custom actions

Building budget solutions using writeback

7. Securing Your Cube Project

Understanding role-based security

Adding users to the fixed server role

Adding custom roles to the database

Securing objects in Analysis Services

Adding dimension security to the FirstCube project

Securing measures

Implementing data security

Testing data security

Enable Visual Totals to restrict what a user can see

Understanding security when a user belongs to several roles

Implementing dynamic data security

8. 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

9. 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

Adding calculated columns to the tabular model

Creating calculated measures in the tabular model

Creating advanced 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

10. Cubes in the Larger Context

Using Microsoft frontend tools to query Analysis Services

Developer-focused tools

Using Reporting Services to query your cube

SharePoint PerformancePoint Services

Self-service tools

Using Excel as a self-service tool against Analysis Services cubes

Using Excel PowerPivot to allow user-created models

SharePoint Excel Services

Introducing Power View - an analytical tool

Third-party tools

Index.

Notes:

"Professional expertise distilled"--Cover.

Includes index.

Description based on online resource; title from PDF title page (ebrary, viewed October 1, 2013).

ISBN:

9781849689519

1849689512

OCLC:

861536153