Databases Reference
In-Depth Information
FIGURE 19.3
Launch the Cube Wizard from the Solution Explorer.
3.
Right-click the Cubes node in the Solution Explorer to launch the Cube Wizard, as
shown in Figure 19.3.
4.
On the Select Build Methods page, select the Generate tables in the data source
option. Then click the Next button.
5.
Create two measures (
store_sales
and
store_cost
) and a measure group (
Sales
).
Choose the
Integer
data type and
Sum
aggregate function for your measures. Then,
click the Next button.
6.
Create four new dimensions—
Product
,
Customer
,
Store
, and
Promotion
—to use in
the
Sales
measure group (see Figures 19.4 and 19.5). Clear the
Time
dimension
check box, and then click the Next button. On the next page, associate all your
dimensions with the
Sales
measure group.
FIGURE 19.4
Use the Cube Wizard to create new dimensions.
Search WWH ::
Custom Search