teach you to use SQL Server Analysis Services tabular mode table modeling

The following is my personal experience with the "SQL Server Analysis Services Tabular Model Table Modeling" tutorial available on MSDN, which contains a picture instance of each lesson, step-by-Step document import from a data source, creating a relationship , computed columns, metrics, hierarchies, perspectives, roles to deployment, and so on each stage, is believed to be a useful supplement to this tutorial.

If you feel light on MSDN on the text tutorials compare bitter, contrast the picture to step by step operation will also help save everyone valuable learning time, you can quickly browse this article to understand the tabular mode under the ease of creation, compared to the traditional multidimensional mode is will be easier and easier to use.

MSDN Original Tutorials-http://msdn.microsoft.com/zh-cn/library/hh231691.aspx

Start with the following text

SQL Server Tabular Model Table modeling

Goal

In the process of table modeling, we need to be proficient in the knowledge points include the following content-

Creating SQL Server Analysis Services table model projects using SSDT (SQL Server Data Tools)

To import data from a SQL Server relational database into a table model

Create and manage relationships between tables in the model

Create and manage calculations, metrics, and key performance metrics that can help users analyze model data

Create and manage perspectives and hierarchies to help users navigate model data more easily by providing business and application-specific viewpoints

Create a partition to divide the table data into smaller logical parts that can be processed independently of other partitions

Create roles and user members to protect model objects and data security

Deploy the table model to an analysis Services Sand box or Production environment running in tabular mode

Experimental conditions

The SQL Server Analysis Services example selects the table mode tabular mode installation, and the other is the multidimensional and Data Mining mode that we have been familiar with before. You can only choose one of the two, but you will be able to install another mode to another instance at the next installation.

Download the http://msftdbprodsamples.codeplex.com/releases/view/105902 sample database

WIN 7 Right-click Administrator to run SQL Server 2012 and attach a downloaded demo database

<SPAN style="FONT-SIZE: 13px"><SPAN style="FONT-FAMILY: 'Microsoft Yahei'">CREATE DATABASE AdventureWorksDW2012 ON
(FILENAME = 'M:\Data\AdventureWorksDW2012_Data.mdf'),
(FILENAME = 'L:\Tlogs\AdventureWorksDW2012_Log.ldf') FOR ATTACH;
</SPAN></SPAN>