1. Administrator's Guide
  2. Using Smart View to Import and Edit Planning Metadata
  3. Editing Members in Smart View

Editing Members in Smart View

The Oracle Smart View for Office grid allows you to rapidly edit the properties of members of a Oracle Hyperion Planning dimension.

Note:

Metadata grids queries are executed against the Planning business layer without interaction with Oracle Essbase.

For detailed information on the use of dimensions and members in Smart View, see "Dimensions and Members" in the Oracle Smart View for Office User's Guide.

To edit member properties in Smart View:

  1. Within Smart View, import a Planning dimension into a Smart View grid (see Importing Dimensions in Smart View).
  2. Highlight a member property in the grid.
  3. In the drop-down menu, select a value.

    Note:

    Modified cells are displayed in a different color.

  4. Click Submit Data to save the grid.

    Note:

    You can save changes to multiple members and properties in the same Submit Data operation. If Submit Data fails for one member, the Planning server will stop the operation and not save any changes.