- Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide
- Reza Rad
- 495字
- 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
factordimprefix from their names such as InternetSales and Date. - 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):
- Vue.js 3.x快速入門
- 少兒人工智能趣味入門：Scratch 3.0動畫與游戲編程
- Java 9 Concurrency Cookbook（Second Edition）
- C/C++常用算法手冊（第3版）
- Python高效開發實戰：Django、Tornado、Flask、Twisted（第2版）
- Kotlin Standard Library Cookbook
- 網絡爬蟲原理與實踐：基于C#語言
- Extending Puppet（Second Edition）
- 持續輕量級Java EE開發：編寫可測試的代碼
- JavaScript+jQuery網頁特效設計任務驅動教程
- Struts 2.x權威指南
- MySQL 8從零開始學（視頻教學版）
- R語言數據挖掘：實用項目解析
- Python預測分析實戰
- Three.js權威指南：在網頁上創建3D圖形和動畫的方法與實踐（原書第4版）