Previous Next

Task 4:  Set up data for the cross tab

In this procedure, you set up the following items:

*
*
*

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

1  
2  
*
Sales Cube
*
3  
4  
(Drop a field here to create a group)

Figure 16-4 Adding a state group to the cube

Figure 16-4  Adding a state group to the cube
5  
6  
(Drop a field here to create a group)
7  
Cross Tab Cube Builder shows the STATE and PRODUCTLINE dimensions you created, as shown in Figure 16-5.

Figure 16-5 Cross Tab Cube Builder displaying two groups

Figure 16-5  Cross Tab Cube Builder displaying two groups
8  
(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 measure by selecting the measure, then choosing Edit.
Figure 16-6 shows the dimensions and measure you defined.

Figure 16-6 Cross Tab Cube Builder displaying two groups and a summary field

Figure 16-6  Cross Tab Cube Builder displaying two groups and a summary field
9  
10  

Figure 16-7 Data Explorer showing the Sales cube

Figure 16-7  Data Explorer showing the Sales cube

(c) Copyright Actuate Corporation 2013