Now that the first dimension of your database has been created, it is time to start creating a cube that has some values that you can slice by the dimension. In Analysis Services, a database can contain several cubes. A cube is a structure that contains the data that you want to analyze. The data that you want to analyze are defined as measures and belong to a measure group. Another object of a cube is the dimensions. A cube can contain several measure groups and the measure groups can use the same dimensions to allow a user to analyze data from different subject areas.
To create the Fact Internet Sales cube, perform the following steps: