Technical data

Chapter 5 Creating Data Cubes
2. Enter the data cube name.
3. Click OK.
Note. Do not create formulas for input data cubes.
See Also
Chapter 5 , “Creating Data Cubes,” Input Data Cubes, page 32
Creating Calculation Data Cubes
To create a calculation data cube:
1. Select Part, Ne
w, Data Cube.
TheEditPartNa
me dialog box appears.
2. Enter the data
cube name.
3. Click OK.
4. Createaformul
a for the calculation data cube.
See C
hapter 10, “Creating Rules, Formu las, and User Functions,” Defining and Editing Data Cube
Formulas, page 119.
See Also
Chapter 5, “Cr
eating Data Cubes,” Calculation Data Cubes, page 33
Creating Association Data Cubes
To create an as
sociation data cube:
1. Select Part, New, Data Cube.
The Edit Part Name dialog box appears.
2. Enter the data cube name.
3. Click OK.
4. Format the data cube as a member of a dimension.
This dimension contains the members that the end user will group or categorize. In the application,
these members appear in the left-hand column of the data cube’s data.
See C
hapter 5, “Creating Data Cubes,” Defining General Data Cube Properties, page 40.
5. Attach a different dimension to the data cube.
This dimension contains the categories by which the end user will group the members of the X
dimension. These members appear in the right-hand column of the data cube’s data. The end user can
select these members from a drop-down list box.
Copyright © 1988-2007, Oracl e. All rights reserved. 39