Developing analysis Services Multidimensional Project in SQL Server 2012

SQL Server 2012 provides two models for developing SSAS projects, one is the newly added tabular model table, and the other is the original multidimensional model multidimensional models.

Here is the demo multidimensional model, if you want to understand the tabular model table models, see-http://www.cnblogs.com/biwork/archive/2013/05/22/ 3093896.html

The environment used below is VS2012 + SSDT integration, which can be see-http://www.cnblogs.com/biwork/archive/2013/05/12/BI_VS2012.html

Database AdventureWorks can be downloaded here-http://msftdbprodsamples.codeplex.com/releases/view/55330

Create a new multidimensional model project

Create a data source

The data source contains information when the profiling service is connected to the source database.