Exporting Data

You export data from the Applications page.

As an alternative, you can export data using Data Integration. See Administering Data Integration.

To export data:

  1. On the Home page, 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-6 Data Export Options

    Data Export Option Description

    Location

    Select the target environment of the data export file:

    • Local: Saves the data export file to a location on your local computer.

    • Outbox: Saves the data export file to the server.

    Cube Type

    Select either Consol or Rates.

    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

    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.

    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.

    Disable Implied Share (for BSO cubes only)

    For a block storage (BSO) cube, select this option to export the child row in the data file even though both parent and child rows have the same data.

    Note:

    By default, implied sharing is enabled during data export. This means that when data is exported, the implied sharing relationship is maintained so only the parent row is exported because the child row contains the same data as the parent. But if you want to export the child data row, you can select this option to disable the implied sharing relationship so that the child row can be exported.

    Missing Data Label

    Specify how you want missing values to display in forms. Enter an alphabetic value that does not exceed 16 characters. You may begin the value with a # (number sign). If no value is entered, the system defaults to #MISSING.

    Note:

    If you're running the export data process to create a template file for a data import and you define a custom missing data label during data export, the Missing Data Label defined during the import data process must match the label defined here. See Importing Data.

    Slice Definition

    Select the slice of data to be exported.

    If the Application supports Period and Movement as Dense, then either Period or Movement must be in the Column. Otherwise, if Account is the only dense dimension in the system, then Account must be in the Column.
  4. Select an action to export the data:
    • If the selected location is Outbox, click Save as Job to save the export operation as a job, which you can schedule to run immediately or at a later time.
    • If the selected location is Local, click Export, and then specify where to save the data export file.

    NOTE: To reduce the size of data export files, if a form contains an entire row of missing values (for example, #MISSING), the row will be omitted from the data export file.