There are two ways to create a cube: through Cube Wizard or by creating an empty cube. When we create a cube from the wizard, the relationships between measures and dimensions will be created automatically based on the underlying Data Source View (DSV) after choosing it. However, if we create a cube from an empty one, we need to set up a relationship between the measure groups and dimensions in the cube designer. In the next example, we create the cube using Cube Wizard.
The first step is to create a data source connection. To create a data source connection, right-click on a data sources folder.
Open the SSAS project and select New Data Source. As shown in the next screenshot, create a connection to the AdventureWorksDW2012 database. In the Impersonation Information field, enter the username and password of a domain/windows account that has the appropriate permissions for that database. Name the data source
AdventureWorksDW2012
.