SQL Server 2017 Adventure Works Multidimensional Cube

It is easy to find Adventure Works scripts for OLTP and DW databases. But it sometimes tricky to find either solution to the Adventure Works Multidimensional Cube and Tabular or backup files.

So solve this problem for you I am sharing links to the abf files for quick access. This post is part 2 of last post on SQL Server 2017 quick setup. With SSAS and Tabular model sample databases you will be perfectly able to handle testing and development samples.

Go to : https://github.com/Microsoft/sql-server-samples/releases/tag/adventureworks-analysis-services

and at the very end of the article you will find the link for Adventure Works Analysis Services databases samples. Backups will be working for SQL Server 2016 and later versions. Tested by me.

Analysis Services database backups:

1. adventure-works-multidimensional-model-full-database-backup.zip  – You get two backups Enterprise and Standard. I have both restored.
2. adventure-works-tabular-model-1200-full-database-backup.zip  – You get only Sales data Tabular Model

 

Analysis services projects:

1. adventure-works-multidimensional-model-project.zip
2. adventure-works-tabular-model-1200-project.zip

Enjoy!! easy download then restore and you have working cubes for testing and working.

Let me know if there is any hiccup while you do all the setups from SQL Server 2017 to Adventure Works databases. Waiting for comments with appreciation or criticism.