Skip to content

This release contains sample Adventure Works tabular and multidimensional model database backups, scripts, and projects for use with Azure Analysis Services and SQL Server Analysis Services.

Feedback on this release: send to sqlserversamples@microsoft.com.

Analysis Services multidimensional model downloads

adventure-works-multidimensional-model-full-database-backup.zip
A full database backup of an Analysis Services multidimensional database. This sample is based on Adventure WorksDW2014 sample data. Requires SQL Server 2014 Analysis Services or later.

adventure-works-multidimensional-model-project.zip
A sample Analysis Services multidimensional model project. Requires Visual Studio 2015 with SQL Server Data Tools. To use this sample project, you must install an AdventureWorksDW database as a data source.

adventure-works-multidimensional-model-readme.txt
Instructions to install the AdventureWorksDW2014 multidimensional model from the full database backup, or by using the project.

adventure-works-multidimensional-tutorial-projects.zip
A collection of completed sample projects for each lesson in the multidimensional modeling tutorial. Requires SQL Server Analysis Services 2012 or later. To use this sample project, you must also install an AdventureWorksDW database as a data source.

Analysis Services tabular model downloads

adventure-works-tabular-model-1200-full-database-backup.zip
A sample AdventureWorks Internet Sales tabular model database at the 1200 compatibility level. To restore, you must have an Azure Analysis Services server or a SQL Server 2016 or later Analysis Services instance.

adventure-works-tabular-model-project-1200.zip
A sample AdventureWorks Internet Sales tabular model project at the 1200 compatibility level. This sample project requires SQL Server Data Tools (SSDT) for Visual Studio 2015 or Visual Studio 2017 with Microsoft Analysis Services Projects. To load data into the workspace database for this project, you must also install an AdventureWorksDW database as a data source. To deploy this project, you must have an Azure Analysis Services server, or a SQL Server 2016 or later Analysis Services instance.

Assets 8
You can’t perform that action at this time.