Use Cube Editor to create a Cube from the start, or to edit a previously created Cube.
Oracle Fusion Middleware Developing Applications with Oracle JDeveloper
Enter values for the following parameters in the table:
| Parameter | Description |
|---|---|
| Name | Enter the name of the Cube. |
| Description | Enter the details of the Cube. |
| Pattern Name | By default, the Cube pattern is automatically set.
If you want a specific pattern to be applied to the Cube, select a pattern name. |
The Details tab contains the following:
Dimensions Table
Key Binding Table
Measures Table
The Dimensions table displays the list of Dimensions being used by the Cube. You can add or delete a Dimension, using the + or x icons at the top right corner.
Set value for the following parameter in the table:
| Parameter | Description |
|---|---|
| Level | The level of the Dimension that is referenced by the Cube.
Click the ... icon to open a list of all the levels in all the Dimensions in ODI repository. Once the level is selected, the qualified name of the level appears in the column in the following format: <dimension_name>.<level_name> |
| Role | If you plan to use the same Dimension multiple times in a Cube, then enter an alternate name to uniquely identify that Dimension. |
The Key binding table is related to the Dimension table.
Set values for the following parameters in the table:
| Parameter | Description |
|---|---|
| Dimension Key | If any Dimension is selected in the Dimension table, then the Key binding table will display the keys in the Dimension Key column.
If the dimension uses a surrogate key, then the Surrogate Key will be displayed. If the dimension does not use a surrogate key, then the Natural Keys will be displayed. |
| Attribute | Select an attribute from the drop-down list that displays all the attributes in the Cube Binding Table. If any attribute is already bound to a Dimension key or a measure, then that attributes will not be listed |
Use the Measures Table to:
Add or delete new measures.
Bind the measure to a Cube Binding Table attribute and Cube Binding Error Table attribute.
Set values for the following parameters in the table:
| Parameter | Description |
|---|---|
| Name | Enter the name of the Measure. |
| Description | By default, this will not be visible in the UI, but you can enable it by clicking the "Select Columns" button. |
| Datatype | Select the datatype of the Level attribute from the drop-down box.
The valid values of the drop-down box will be one of the datatypes in the "Generic SQL" technology, defined in the ODI repository. |
| Size | Specify the length or precision of the Measure.
By default, this will not be visible in the UI, but you can enable it by clicking the "Select Columns" button. |
| Scale | Set the scale of this Measure (for numeric datatype).
By default, this will not be visible in the UI, but you can enable it by clicking the "Select Columns" button |
| Attribute | Select the datastore column to store the data for Measure.
The valid values of the drop-down box are the columns of the Cube Table. If any attribute is already bound to a Dimension Key or a Measure, then that attributes will not be listed. |