1. User's Guide
  2. Data and Data Cells
  3. Using the Submit Data Options
  4. Submitting Data

Submitting Data

Cloud data source types: Oracle Analytics Cloud - Essbase, Planning, Financial Consolidation and Close, Tax Reporting

On-premises data source types: Oracle Essbase, Oracle Hyperion Financial Management, Oracle Hyperion Planning

Video

Your Goal Watch This Video

Learn about basic Oracle Smart View for Office functionality, including submitting data.

video icon Entering and Saving Plan Data in Smart View with Oracle Planning and Budgeting Cloud

To submit data:

  1. Connect to the data source.
  2. Optional: To help you identify modified cells, set a cell style for dirty cells, as described in Cell Styles.
  3. Essbase only: If you are working in free-form mode with an Essbase on-premises release earlier than 11.1.2.1.102, from the Essbase ribbon, select Refresh.
  4. Modify data as needed.
  5. From any ribbon, select Submit Data.

    All dirty cells on the worksheet are submitted.

Note:

If you are working with multiple grids on a worksheet, see Guidelines for the Submit Data Options.