Permalink
Fetching contributors…
Cannot retrieve contributors at this time
72 lines (54 sloc) 5.62 KB
title ms.custom ms.date ms.prod ms.reviewer ms.suite ms.technology ms.tgt_pltfrm ms.topic applies_to helpviewer_keywords ms.assetid caps.latest.revision author ms.author manager
Multidimensional Modeling (Adventure Works Tutorial) | Microsoft Docs
03/07/2017
sql-server-2016
analysis-services
get-started-article
SQL Server 2016
tutorials [Analysis Services]
Analysis Services, tutorials
db55e226-601a-4026-8651-573195555a59
31
Minewiskan
owend
erikre

Multidimensional Modeling (Adventure Works Tutorial)

Welcome to the [!INCLUDEssASnoversion] Tutorial. This tutorial describes how to use [!INCLUDEssBIDevStudio] to develop and deploy an [!INCLUDEssASnoversion] project, using the fictitious company [!INCLUDEssSampleDBCoFull] for all examples.

What You Will Learn

In this tutorial, you will learn the following:

  • How to define data sources, data source views, dimensions, attributes, attribute relationships, hierarchies, and cubes in an [!INCLUDEssASnoversion] project within [!INCLUDEssBIDevStudio].

  • How to view cube and dimension data by deploying the [!INCLUDEssASnoversion] project to an instance of [!INCLUDEssASnoversion], and how to then process the deployed objects to populate them with data from the underlying data source.

  • How to modify the measures, dimensions, hierarchies, attributes, and measure groups in the [!INCLUDEssASnoversion] project, and how to then deploy the incremental changes to the deployed cube on the development server.

  • How to define calculations, Key Performance Indicators (KPIs), actions, perspectives, translations, and security roles within a cube.

A scenario description accompanies this tutorial so that you can better understand the context for these lessons. For more information, see Analysis Services Tutorial Scenario.

Prerequisites

You will need sample data, sample project files, and software to complete all of the lessons in this tutorial. For instructions on how to find and install the prerequisites for this tutorial, see Install Sample Data and Projects for the Analysis Services Multidimensional Modeling Tutorial.

Additionally, the following permissions must be in place to successfully complete this tutorial:

  • You must be a member of the Administrators local group on the [!INCLUDEssASnoversion] computer or be a member of the server administration role in the instance of [!INCLUDEssASnoversion].

  • You must have Read permissions in the AdventureWorksDW2012 sample database. This sample database is valid for the [!INCLUDEssCurrent] release.

Lessons

This tutorial includes the following lessons.

Lesson Estimated time to complete
Lesson 1: Defining a Data Source View within an Analysis Services Project 15 minutes
Lesson 2: Defining and Deploying a Cube 30 minutes
Lesson 3: Modifying Measures, Attributes and Hierarchies 45 minutes
Lesson 4: Defining Advanced Attribute and Dimension Properties 120 minutes
Lesson 5: Defining Relationships Between Dimensions and Measure Groups 45 minutes
Lesson 6: Defining Calculations 45 minutes
Lesson 7: Defining Key Performance Indicators (KPIs) 30 minutes
Lesson 8: Defining Actions 30 minutes
Lesson 9: Defining Perspectives and Translations 30 minutes
Lesson 10: Defining Administrative Roles 15 minutes

[!NOTE]
The cube database that you will create in this tutorial is a simplified version of the [!INCLUDEssASnoversion] multidimensional model project that is part of the Adventure Works sample databases available for download on the codeplex site. The tutorial version of the Adventure Works multidimensional database is simplified to bring greater focus to the specific skills that you will want to master right away. After you complete the tutorial, consider exploring the multidimensional model project on your own to further your understanding of [!INCLUDEssASnoversion] multidimensional modeling.

Next Step

To begin the tutorial, continue to the first lesson: Lesson 1: Defining a Data Source View within an Analysis Services Project.