The default column order for the native data file is Scenario, Year, Period, View, Entity, Value, Account, ICP, Custom1, Custom2, Custom3, and Custom4.

You cannot change the column order for the data file.

The Group section defines the POV for the data file; you can define only a single member for each POV dimension.

The Line Items detail section contains data values.

The Group section is required.

Frequency

Calendar

Dimension Associations

Language(s)

Scenario

A parent account is limited to 3 children or less.

Parent accounts should have more than one child account but it is not required.

Parent accounts can have a single child only if the currency is changing.

The number of children under a parent account has no performance impact.

Parent accounts inherit the properties of their children.

Manage documents.

View system messages.

Run Data and Task Audits.

Manage Task Flows.

Manage Security.

IsCalculated is required for parents to sum up the values of their children.

IsConsolidate tells Financial Management whether a member should consolidate up the entity and value dimensions.

If IsICP is selected, a PlugAccount can be specified to enable elimination.

CustomTopMember properties are always associated with the entity dimension.

1, 2, 3, 4, 5

2, 1, 4, 3, 5

2, 1, 5, 3, 4

1, 2, 5, 3, 4

1, 2, 3, 5, 4

Use the FMCopyApplication.exe utility.

Copy the application using the Admin Task list, select Extract Application and then import into a new application.

Select the Copy User Provisioning in Shared Services.

Use Life Cycle Management to migrate the artifacts and data.

Use the EPMA File Generator Utility to extract and import metadata.