1. Administrator's Guide
  2. Using FDMEE
  3. Administration Tasks
  4. Loading Excel Data

Loading Excel Data

Use the Load from Excel feature to load data to and from a Microsoft Excel workbook. This feature enables you to load large amounts of application information and entity types without having to enter each line manually, and to push data into tables without SQL access.

Available options include:

  • Download to Excel—Select an entity and download the data from the corresponding table to an Excel spreadsheet.

  • Upload from Excel—Import source data representing one or more ranges from an Excel spreadsheet.

Caution:

When loading data using this method, Oracle Hyperion Financial Data Quality Management, Enterprise Edition does not validate the data. It is the responsibility of the user to validate the data using this method.