SQL Server Analysis Services Sample Data
By: Siddharth Mehta
Developing an end to end data model with an appropriate volume of sample data is a time intensive process. Our focus is to come up to speed with major building blocks of the SSAS data model without spending lot of time in setting up a sample structure and data for the model. In order to work with SSAS Multidimensional as well as Tabular data model, we need a sample data model for each server mode so that we can explore different parts of the data model. In this chapter we will download sample Adventureworks databases for SSAS Multidimensional as well as Tabular models and install them on a SSAS instance.
After downloading them, the next step is to restore these database backups on the Multidimensional and Tabular SSAS Instances. Although backup and restore are typically an administrator's task, anyone working with SSAS needs to know a certain level of administration to independently accomplish routine tasks.
Starting with the multidimensional mode, restore the downloaded Adventureworks backup
on the multidimensional instance of SSAS. Detailed steps to accomplish this
can be read
here. After successful restore, when you to connect to your SSAS Multidimensional
instance using SSMS, you should be able to explore your restored database as shown
The next step is to restore the downloaded Adventureworks tabular database on the tabular instance of SSAS. The steps for this process are identical to the one for restoring a multidimensional database. Alternatively, you can also download a tabular SSAS solution and deploy it to create a sample tabular SSAS database. You can read about the steps for that here.
- You will find different database objects in your tabular and multidimensional databases after restoring. To understand the differences, consider reading this article on the comparison of Tabular and Multidimensional solutions.