Previous Next

Presenting Data in a Cross Tab : Tutorial 6: Creating a cross tab : Task 4: Set up data for the cross tab

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 row headings
n
A data group, or dimension, containing values to use as the column headings
n

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

1
2
n
Sales Cube
n
3
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

Figure 17-4
5
Drag PRODUCTLINE from Available Fields and drop it on (Drop a field here to create a group). 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

Figure 17-5
Cross Tab Cube Builder displaying two groups
6
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

Figure 17-6
Cross Tab Cube Builder displaying two groups and a summary field
7
Choose OK to save the cube. The Sales cube appears under Data Cubes in Data Explorer, as shown in Figure 17‑7.

Figure 17-7 Data Explorer showing the Sales cube

Figure 17-7
Data Explorer showing the Sales cube

(c) Copyright Actuate Corporation 2008