Exporting Data

You export data from the Applications page.

As an alternative, you can export data using Data Management. Create a custom application as the source using Oracle Tax Reporting Cloud, then export the data and save the export file from within Data Management. See Importing and Exporting Data Using Data Management.

To export data:

  1. On the Home page, click Applications, and then click Overview.
  2. Click the Overview tab, and from Actions, select Export Data.
    From the Overview on the Application tab, select Export Data.
  3. On the Export Data page, click Create. A second Export Data screen is displayed.
    Select the target location for the export data file.
  4. On the Export Data page, select the target location 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.
  5. For Cube, select either Consol, Rates, or CbCR.
  6. Under File Type, select an option for the export file:
    • 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.
  7. For Smart Lists, specify Export Labels or Export Names.
  8. For Dynamic Members, select Include or Exclude.

    Table 17-1 Dynamic Members

    Dynamic Members Description

    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.
  9. Select Disable Implied Share (for BSO cubes only) option for a block storage (BSO) cube, 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.

  10. Under 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 Loading the Data Import File
  11. Under Slice Definition, select the Row, Column and Point of View for the slice of data to be exported.
  12. Select the 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.

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