Import Sections
An import consists of up to five sections. Each import section corresponds to a set of source data of a specific granularity. All records for an import section are expected to be the same number of columns. Import sections in source files are identified with a unique section header composed of a prefix, label, and suffix. An import file can consist of multiple sections of the same type but all sections of the same type must have the same number of columns. For database sources, each import section is mapped to a single database table or view.
Table 12-1 Import Sections
Import Section | Description |
---|---|
Version |
Property values of the new version This import section is only required to allow for the name or description of the new version created by the import to be different for each run or to load version property values. Required column: Version Name |
Hierarchy |
Hierarchies to be created by the import process, their top nodes, and property values for each hierarchy This section is required to relate nodes to each other using hierarchy relationships. Required columns: Hierarchy Name, Top Node |
Node |
Nodes to be created by the import process and global node property values for each node Nodes that are not related to hierarchies will be imported into the new version as orphans. Required column: Node Name |
Relationship |
Parent-child relationships between nodes in hierarchies and global or local node property values for the child node This section is required to relate nodes using hierarchy relationships. Nodes that are directly or indirectly related to a top node of a hierarchy being imported will be inserted into the hierarchy unless the insert would result in duplicate instances of the node. Required columns: Parent Node Name, Node Name |
Hierarchy Node |
Local node property values specific to a specified hierarchy The Hierarchy import section is required when this section is being used. Required columns: Hierarchy Name, Node Name |
Example 12-1 Import File Example
[version]
My Version
[hier]
Balance Sheet,BALSHEET
[node]
1000,Assets
2000,Liabilities
3000,Equity
[relation]
BALSHEET,1000
BALSHEET,2000
BALSHEET,3000
Preserving Quoted Strings and Formatting
The import process can preserve quoted strings and tab and carriage return formatting. In the import file, for any section where you want to preserve the quoting and formatting, enclose the entire section in quotes. For quoted items within the section, you must provide an extra set of quotes. Quoted string processing is enabled by the Strip Quoted Strings" parameter in the import. This option must be selected to enable the processing and stripping of quoted strings.
For example, if you want to preserve the formatting and quoted strings in this section:
IF (@ISMBR("Plan") AND @ISMBR(&NextYear))
"Units"->"P_TP1"->"YearTotal" / "Avg Order Size" / "Close Rate" * "Travel %";
ELSEIF (@ISMBR("Forecast") AND @ISMBR(&NextYear))
"Units"->"P_TP1"->"Rolling" /"Avg Order Size" / "Close Rate" * "Travel %";
ENDIF
You would add quotes like this:
"IF (@ISMBR(""Plan"") AND @ISMBR(&NextYear))
""Units""->"P_TP1"->""YearTotal"" / ""Avg Order Size"" / ""Close Rate"" * ""Travel %"";
ELSEIF (@ISMBR(""Forecast"") AND @ISMBR(&NextYear))
""Units""->""P_TP1""->""Rolling"" /""Avg Order Size"" / ""Close Rate"" * ""Travel %"";
ENDIF"
Note:
If the section uses single quotes, add an extra set of single quotes to those items.