Modifying the Metadata

Locating metadata objects

After you create a metadata object, such as a dimension or cube, you can access that object from the OLAP management tree. Dimensions are grouped by schema under Dimensions, cubes are grouped by schema under Cubes, and measure folders are optionally grouped under parent folders.

You can view the properties of a metadata object, change those properties, or delete the object.

Procedure: Modifying your metadata

Follow these steps to modify a metadata object:

1. If necessary, start Oracle Enterprise Manager and access OLAP management, as described in "Procedure: Accessing OLAP management".

2. Expand the OLAP tree until you see the object you want to modify, as shown in "Figure: Expanded OLAP tree". For example, to modify a dimension, expand Dimensions, then expand the appropriate schema.

3. To simply view the properties of an object, select it on the tree. Its property sheet will appear in the right pane of the main window.

   or

   To edit an object, right-click the object, then choose Edit. The property sheet for that object will appear in the Edit dialog box.

   or

   To delete an object, right-click it, then choose Remove. You will be prompted to confirm that you want to remove the object.

Figure: Expanded OLAP tree

The following figure shows Cubes expanded to show the dimensions and measures in a cube. The property sheet of the selected measure appears in the right pane.

Related information

For more information about making changes to your metadata, search Oracle Enterprise Manager Help for the following topics:

"Editing Cubes"

"Editing Dimensions"