Exporting Files

You can export to some formats without much preparation.

  To export a file:

  1. From any Strategic Finance view, select File, then Export, then To Files.

  2. In File Name, select or enter the name of the file to export.

    This lists files with the file name extension selected in the Export Files of Type field.

    • To list files of the same extension, type an asterisk (*), a period, and the three-character extension, and click Enter.

    • To list different file types, separate multiple file name extensions with semicolons (;). For example: *.xls; *.asc.

  3. In Save as Type, select a file type from File Name:

    • Select ASCII Files (*.asc)

      Exports output (calculated) values for input accounts or for all accounts into a comma- or tab-delimited ASCII file format that indexes the account data by the account descriptions or the Strategic Finance account numbers. Even if the Input and Display flags for an account are not set in the Customize view, input data for that account are exported to an ASCII file.

      See Selecting ASCII File Options.

    • Select Report to Excel Files (*.xls) to export selected Strategic Finance reports into an Excel file (*.xls).

    • Select Essbase Outline (*.txt) to create an Essbase outline out of the accounts in Strategic Finance (*.txt). This outline can be loaded into a Essbase database.

    • Select Export Map Files (*.mps) to create a map (*.mps) file that exports Strategic Finance data to Oracle Essbase, Oracle's Hyperion® Enterprise®, or Excel.

  4. View the File Information.

    Displays the day, date, and time the file was last saved; the size of the file; and the status of the read/write privileges.

  5. Optional: If you are exporting to ASCII, click Options to select various ASCII options. Invokes the ASCII File Export Options dialog box.

    See Selecting ASCII File Options.

  6. Optional: If you are exporting to Excel, click Multiple to select multiple reports to export. See Selecting Multiple Reports to Export.

  7. Click Save to perform the export.