Building a multi-dataset cube
The tutorial earlier in this chapter walked through the steps for building a cube that used data from a single data set. In this section, you learn how to create a multi-dataset cube. Because the concepts and procedures are easier to understand with an example, this section walks through the steps for performing the following tasks:
Creating the data sets to retrieve data from the Orders, OrderDetails, and Products tables in the Classic Models sample database
Using data from the data sets to build a cube that contains a sales amount measure, a product line dimension, and a year dimension