> 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

(c) Copyright Actuate Corporation 2009