SQL Server Analysis Services Sample Data




By:
Overview

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.

Explanation

The first step is to download sample Adventureworks databases for Multidimensional and Tabular data models.

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 below.

SQL Server Analysis Services Restored Multi-dimensional database

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.

SQL Server Analysis Services Restored Tabular database
Additional Information
  • 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.

Last Update: 4/18/2017




More SQL Server Solutions











Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name
*Email
Email me updates

Signup for our newsletter

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.






download





get free sql tips

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



Learn more about SQL Server tools