Task 4:

Set up data for the cross tab

In this procedure, you set up the following items:

n	A data group, or dimension, containing values to use as the cross tab’s row headings

n	A data group, or dimension, containing values to use as the cross tab’s column headings

n	A summary field, or measure, containing aggregate values to use in the cells of the cross tab

Data that you set up for a cross tab is stored in an entity called a cube.

1	In Data Explorer, right-click Data Cubes, and choose New Data Cube.

2	On Cross Tab Cube Builder, specify the following information:

n	In Name, type

Sales Cube

n	In Primary dataset, select Sales.

3	Choose Groups and Summaries.

4	In Available Fields, expand Sales. Drag STATE and drop it on (Drop a field here to create a group), as shown in Figure 17‑4.

Figure 17‑4

Adding a state group to the cube

5	On Add Group, use the default group name. Choose OK.

6	Drag PRODUCTLINE from Available Fields and drop it on (Drop a field here to create a group). Use the default group name.

Cross Tab Cube Builder shows the STATE and PRODUCTLINE groups you created, as shown in Figure 17‑5.

Figure 17‑5

Cross Tab Cube Builder displaying two groups

7	Drag EXTENDED_PRICE from Available Fields and drop it on (Drop a field here to create a summary field).

EXTENDED_PRICE(SUM) appears under Summary Field. SUM indicates that the SUM aggregate function is used to calculate the totals of the EXTENDED_PRICE values. The cube builder selects the SUM function by default. You can, however, select a different function to apply to a summary field by selecting the measure, then choosing Edit.

Figure 17‑6 shows the dimensions and measure you defined.

Figure 17‑6

Cross Tab Cube Builder displaying two groups and a summary field

8	Choose OK to save the cube. The Sales cube appears under Data Cubes in Data Explorer.

8	Expland the Sales Cube to view its contents, as shown in Figure 17‑7.

Figure 17‑7

Data Explorer showing the Sales cube