Category Archives: Tabular Model
Include post related to SQL Server 2012, BI Semantic Tabular Model
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:
- adventure-works-multidimensional-model-full-database-backup.zip – You get two backups Enterprise and Standard. I have both restored.
- adventure-works-tabular-model-1200-full-database-backup.zip – You get only Sales data Tabular Model
Analysis services projects:
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.