SQL Server 2012 using profiling Services Multidimensional mode to establish a simple analysis model

A cube is a special kind of database that, in its default mode (MOLAP), aggregates data from fact tables and dimension tables in a data warehouse into a separate set of file systems. Aggregated data is improved in statistical performance and allows users to generate simple reports through simple front-end tools such as Excel.

This will describe how to make a simple cube.

The version used in this article is SQL Server 2012, the corresponding visual Studio shell is 2010, and the name is changed to SQL Data Tools.

First, open SQL Data Tools, click File->new->project ...

Next opens the New Project window. This interface may be more data for many C # developers, but here you can tell that many of the projects under SQL Server BI are built here, such as data integration projects, which are primarily responsible for the ETL process in the BI project (data cleansing conversion and loading), as well as report service projects, Many of the BI project reports are implemented through this project template. Since the Microsoft. NET strategy, much of the development has been done in Visual Studio. Here is a concrete embodiment.

Select Analysis Services in the left project template and select Analysis Services multidimensional and Data Mining project.

Here we can see another Analytics Service project template available in the latest release, which is Analysis Services tabular project, and for this new feature, refer to my other essay:

Using SQL Server Analysis Services Tabular model to establish an analytical modeling

The final output of the tabular model is similar to that of a cube, except that it is more geared towards users between business people and developers, and the cubes mentioned in this article are positioned on top of developers.

Also, pay attention to the project type of data Mining, meaning that under this project, you can also set up a Datamine project, about how to play this function, please refer to my other essay:

Using association rules for SQL SERVER Analysis Services data Mining to implement product recommendation functions

Next, let's look at the structure of the project: