BI-SSAS practice, bi-ssas practice

BI-SSAS practice, bi-ssas practice

As the saying goes, "I have to get to the bottom of the paper, and I know that this is something to do." in the previous article, I briefly introduced SSAS, so today I will use an instance to understand its sense of presence.

I. Prerequisites

The prerequisite is necessary components, examples, and tools.

(1) SQL Server database engine (which comes with SQL Server 2012)

(2) AnalysisServices (SQL Server 2012)

(3) DataTools (SQL Server 2012)

(4) AdventureWorksDW2012_Data database (a download is also provided here)

Ii. Scenarios

Five tables are used in this database. dimension tables include customer tables, category tables, product tables, and timelines. fact tables include network sales tables. This allows you to create a multi-dimensional dataset to understand the network sales performance in four dimensions.

Step 3

(1) Create and restore the AdventureWorksDW2012_Data database to the local instance.

(2) Open the SSDT that comes with SQL Server 2012 and create an AnalysisServices Multidimensional and Data Mining Project named Multidimensionaliuyujtest. (Or use VS to create business intelligence. The effect is the same)

(3) Right-click and create a new data source and Data Source view (Note: all are created through navigation ). The Data Source view chart is a fact table and four dimension tables.

(4) create a dimension table and select four dimension tables respectively. You can set the default values for other dimension tables.

(5) Creating a cube table is complicated here.

 

 

 

 

The preceding multi-dimensional dataset is successfully created!

(6) Deploy and release, right-click deployment, and the project will be automatically deployed. After successful deployment, you can create a table based on your requirements.

 

Iv. Summary

The above small instance is a simple implementation of SSAS, so as to experience its powerful data processing, and hope to be more proficient in it and exert its maximum value in future study and work.