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