Objective: To setup sample databases that we would use.
We would be exploring MDX on SQL Server Analysis Service platform. For queering we would use AdventureWorks Analysis Service database, therefore we will start by setting up AdventureWorks sample database. There are two ways to setup the AdventureWorks Cube.
Restoring from an existing backup
Deploying from Sql Server Analysis …