Task 4: Set up data for the cross tabIn 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
nData that you set up for a cross tab is stored in an entity called a cube.
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
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
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
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
(c) Copyright Actuate Corporation 2008 |