1. Administering FreeForm
  2. Managing Applications
  3. Importing and Exporting Data and Metadata
  4. Importing and Exporting Data
  5. Exporting Data

Exporting Data

To export data to a file:

  1. Click Application, and then click Overview.
  2. Click Actions, and then click Export Data.
  3. Click Create and make your Export Data selections:

    Table 5-3 Data Export Options

    Data Export Option Description

    Location

    Select the target environment of the data export file:

    Cube

    Select a cube from the drop-down list.

    Note:

    The driver/column dimension in the Export Data job definition needs to be dense.

    File Type

    Select from the following types:

    • Comma delimited: Creates a comma-delimited .csv file for each artifact.

    • Tab delimited: Creates a tab-delimited .txt file for each artifact.

    • Other: Creates a .txt file for each artifact. Enter the delimiter character that you want to use in the export file. For a list of supported delimiter characters and exceptions, see Other Supported Delimiter Characters.

    Smart Lists

    Specify Export Labels or Export Names.

    Dense Dynamic Members (for BSO cubes only)

    For a block storage (BSO) cube, select whether to Include or Exclude dense dynamic calculation members during export.

    Note the following:

    • Excluding dynamic calculation members from exported data improves performance during data exports.

    • Sparse dynamic members are not included in the export even if the Include option is selected.

    Dynamic Members (for ASO cubes only)

    For an aggregate storage (ASO) cube, select whether to Include or Exclude dynamic calculation members during export.

    Note:

    Excluding dynamic calculation members from exported data improves performance during data exports.

    Decimals

    Specify the number of decimal positions (0-16) to format the data after export, or select the default None to use the default precision formatting. For example, specifying a decimal value of 3 in the Decimals field will result in the exported data displaying three digits to the right of the decimal point, wherever applicable.

    Note:

    Selecting None formats the decimal number as specified in the default precision settings, whereas selecting 0 formats the data to display a whole number. For example, if the data value you are exporting is 123.45678, selecting 0 will export the data as 123 and selecting None will export the data as 123.45678.

    Slice Definition

    Select the slice of data to be exported.

    Note:

    If you're exporting data from an aggregate storage cube and you're exporting multiple members simultaneously, make sure that at least one of the members you select is a non-shared member. You can export shared members individually because it's equivalent to selecting a base member. However, selecting level 0 descendants of a parent member whose descendants are all shared members is equivalent to not selecting any members from a dimension and the export will not run. Therefore, you must ensure that one of the members selected is a non-shared member.
  4. Optional: Click Save as Job to save the export operation as a job, which you can schedule to run immediately or at a later time.

    Note:

    • Save as Job is available only when Outbox is selected.

    • You can run up to five export jobs at one time.

    • When scheduling export jobs, you can specify a unique output file name for each job.

    • For more information about scheduling jobs, see Managing Jobs.

    Tip:

    To streamline the job creation process for subsequent Export Data jobs, you can duplicate an existing job using the Save As option, then update it. See Duplicating Jobs.

  5. Click Export, and then specify where to save the data export file.

Note:

To reduce the size of data export files, if a form has an entire row of #MISSING values, the row will be omitted from the data export file.

Troubleshooting

For help with troubleshooting issues if you get an Oracle Essbase query limit error when exporting a large number of data cells from ASO cubes, see Handling Issues Related to Large Data Export from ASO Cubes in Oracle Enterprise Performance Management Cloud Operations Guide.