Data File Sections
Data file sections include column order, data, view, line item detail, and descriptions.
Table 3-1 Data File Sections
| File Section | Description |
|---|---|
|
Column Order |
Specifies the order in which dimension members are displayed. The following syntax specifies the default column order:
The default dimension sequence is optional. You can change the column order to meet your needs, and you can specify multiple Column Order sections in a data file. Each subsequent Column Order section overrides the previously defined section. Note: Column order impacts load performance. To maintain optimal performance, first list the Scenario, Year, Entity, and Period dimensions. If you do not specify the Scenario, Year, or Period dimensions in the column order sequence, it is assumed that they are specified in a separate section of the data file. If you do not include the ICP or Custom dimensions in the sequence, they are assumed to be ICP None, and None respectively. |
|
View |
Specifies the default view for all data following it. You can specify multiple View sections in the data file; each section must start with a valid View dimension. Each subsequent View section overrides the previously defined section. If you do not specify a View section, the view must be specified in the point of view. |
|
Data |
Specifies numeric amounts for valid input cells. If accounts do not accept line item detail, you must load data into them. The syntax for this section is as follows: Note: Zeros are stored as data. Loading zeros into an application is not recommended because zeros can increase the size of the database and impact performance. You can specify several Data sections throughout the data file. If you place the Data section before the first Column Order section, the default column order is used. Ownership data is used to calculate the ultimate ownership and consolidation percentages for the dependents of the selected parent. Ownership information is managed within the ICP dimension by way of a member list called System that is automatically generated by the system. For percent consolidation data, you must know an entity member’s parent in the hierarchy. The parent is required for percent consolidation data but is ignored in all other circumstances. |
|
Line Item Detail |
You load line item detail to accounts that support line item detail and are valid dimension combinations. A line item is represented by a delimited pair that consists of a description and a value. You can specify several Line Item Detail sections throughout the data file. The following syntax specifies a sample point of view, line item detail, and line item value:
You must load line item detail to one period. You cannot load it to a range of periods. The scenario’s default view (YTD or Periodic) determines how the line item detail is loaded. The line item detail description cannot be blank, but you can leave the line item detail value blank. Descriptions do not need to be unique. If you do not enter a description and value pair after the point of view settings, an error occurs and you are prompted to enter a description for the line item detail. Note: Use only double quotation marks (“) in line item detail. Single quotation marks (‘) are not supported. |
|
Description |
Specifies cell text information. Use one of these delimiters to separate cell text content: the pipe symbol (|) or the tilde (~). The following syntax specifies sample cell text:
|