篮球游戏

書(shū)名： Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide
作者名： Reza Rad
本章字?jǐn)?shù)： 495字
更新時(shí)間： 2021-08-13 17:55:27

Time for action – creating a tabular project

In this example, based on data in the AdventureWorksDW2012 database, we will create a tabular project with SSDT from an empty project. You will see a variety of data sources that are supported and how easy it is to work in the tabular modeling environment.

Open SSDT, and from the Files menu, choose a new project, and then from the Business Intelligence templates under Analysis Services, choose Analysis Services Tabular Project. Name this project Chapter 03 Tabular.
You might see a dialog box titled tabular model designer that asks for a tabular connect option, so enter the SSAS Tabular server's connection details and click on OK.
A new tabular project will be created. Now, from the Model menu, choose Import from Data Source.
In the Import Table Wizard, you will see a list of data source types that can be used to import data. Choose Microsoft SQL Server and continue.
Create a connection to AdventureWorksDW2012. In the Impersonation Information option, enter the credential details that have the appropriate permission on the underlying database and continue.
Choose Select from a List of Tables and Views to import data in the next step.
In the Select Tables and Views option, select FactInternetSales, and then click on select related tables. Change the name of FactInternetSales and all dimensions by removing the fact or dim prefix from their names such as InternetSales and Date.

Tip

You can filter data with the preview and filter buttons and use Excel filtering features to filter data and preview and select it when it looks appropriate for use. For this example, just add tables without any filtering.
The final step will show importing summary; all records will be loaded into a workspace for further development and modeling.
After importing data, you will see the model in the designer. Tabular designer, as you can see, is much simpler than the multidimensional designer.
Under the Model menu, go to View and then Diagram View; you will see a diagram of tables that are related to each other.

What just happened?

Creating a tabular model is as simple as importing data rows from tables or views, but the model will require further modification. In the next sections of this chapter, you will see how to change the model with hierarchies, relationships, and calculations.

SSAS Tabular, as you saw in step 4, supports many types of data sources such as SQL Server, Teradata, Web services, Text files, and more. Also, importing tables and views into the model can be customized with filtering, as mentioned in step 7.

Model designer in a tabular project is very simple; it has two different views, Grid View and Diagram View. The Grid View shows some data rows of each table with columns and properties of each column shown in the properties pane (as shown in the next screenshot). The Diagram View shows how tables relate to each other in a diagram (step 10):

官术网_书友最值得收藏!

Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide

Time for action – creating a tabular project

Tip

What just happened?