Extracting Data

You can extract base-level input data and some calculated data from an application. When you extract data, it is saved to an ASCII file. By default, data files use the .DAT file extension. After you extract data to a data file, you can view and modify it in a text editor.

When you extract data, you must specify a member for the Scenario and Year dimensions. You can specify one or more members for the Period, Entity, and Account dimensions.

You can also extract these types of calculated data:

Consolidated data for parent entities
Base accounts and custom dimension members that are calculated by rules
Parent accounts that intersect with their respective CustomTop member and ICPTop member. If the CustomTop metadata attribute is blank or ALL, then the None member is used. Only valid data intersections are extracted.

In the Web, specify the name of the file to extract and make sure that you set up a directory for log files and extracted Web files.

Note:

The log file stores information about the process, such as the start and end time of the extract and the number of extracted records.

Web Procedure

To extract data:

Open the application from which to extract data.
Select the Browser View tab.
In the view pane, expand Tasks and select Extract Tasks.
Select Extract Data.
Select a member for the Scenario dimension and a member for the Year dimension.
Select one or more members for the Period, Entity, and Account dimensions.
Select a data view to extract:
- Year to Date
- Periodic
- Scenario Default
Optional: Select Extract Calculated Data to extract calculated data.
Optional: Select Extract Process Management Data to extract submission phase data.
Click Extract.
Click the Click Here to Download link and select Save.
Enter a name for the extracted file and make sure that the location for the file is in the Web directory that you set up.
Note:
By default, data files use the DAT file extension.
Click Save.