- 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):
- 微服務設計（第2版）
- Advanced Splunk
- Learning Scala Programming
- Java Web開發學習手冊
- Advanced Machine Learning with Python
- Mastering C# Concurrency
- ADI DSP應用技術集錦
- Ext JS 4 Web Application Development Cookbook
- 貫通Tomcat開發
- 寫給大家看的Midjourney設計書
- Visual Basic語言程序設計基礎（第3版）
- 軟件測試分析與實踐
- Mapping with ArcGIS Pro
- Visual C#（學習筆記）
- Thymeleaf 3完全手冊