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

Source: Internet
Author: User

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:

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.