Initiating Data Mode and Editing Data

Users with permissions can edit cell values and write edits back to Essbase. You can initiate Edit Data mode only from the spreadsheet display type.

  To initiate Edit Data mode and Edit Data.

  1. Right-click a cell and select Edit Data

    The Edit Data Bar is displayed at the bottom of the content area and features these controls:

    Button

    Control

    Description

    Exit icon

    Close and Disable Edit Data mode

    Closes Edit Data mode.

    Send Data icon

    Send/Commit changes to database server

    Applies edits to the database.

    Calculate icon

    Calculate database

    Prompts the database server to recalculate the database.

    Refresh icon

    Refresh Data

    Reload the last saved data values.

  2. Double-click a cell to edit its data value.

  3. Double-click a cell to edit its data value.

    The cell border becomes gray, and cell formatting is disabled.

  4. Enter a data value and click outside the cell.

  5. Click Send/Commit changes to the database server.

    Only authorized users can successfully write changes to the database. The Confirmation dialog box is displayed if write-back is successful.

  6. Optional: To recalculate the database, click Calculate database.

  7. To exit Edit Data mode, click Close and Disable Edit Data mode.