Time for action – creating the first cube

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.

  1. The first step is to create a data source connection. To create a data source connection, right-click on a data sources folder.
  2. Open the SSAS project and select New Data Source. As shown in the next screenshot, create a connection to the ...

Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.