Creating an Export Data Job
To export data, you create an Export Data job.
To export data to a file:
-
From the Home page, click Application, and then click Jobs.
-
Click the Import Export tab at the bottom of the Jobs console.
-
On the Import Export tab, click Create Job.
-
In Job Type, click the drop-down and select Export Data.
-
In Job Details, enter the following information:
Table 3-3 Export Data Options
Export Data Option Description Name Name of the Export Data job.
Location Select the target environment for 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.
See Uploading and Downloading Files Using the Inbox/Outbox Explorer.
Cube Select a cube from the drop-down list.
Missing Data Label Specify how to display missing values 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 are 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.
Smart Lists Specify Export Labels or Export Names.
Dynamic Members 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 None to use the default precision formatting.
For example, specifying a decimal value of 3 in the Decimals field results in the exported data displaying three digits to the right of the decimal point, wherever applicable.
Selecting 0 formats the data to display a whole number. For example, if the data value you are exporting is
123.45678.Disable Implied Share Select whether to disable implied share when exporting the job.
File Type Select from the following options:
-
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.
Slice Definition Select the slice of data to export.
If you are exporting data for 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.
-
-
If you selected Local as the location for the export data file location, click Export, and then specify where to save the data export file..
-
Click Save to save the job details.
-
Return to the Import/Export tab to view the Import Data job.
Note:
- 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 Scheduling Jobs.
- To reduce the size of data export files, if a slice 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 Operations Guide.