Import and Export File Format
When you import and export data for Planning and FreeForm dimensions, you must use a
comma-delimited (.csv
) file.
The following list describes the comma-delimited file's format and other considerations:
- The file must have the following columns:
- Name The dimension name specified in the registration or the external dimension name, if you entered it.
- Parent The name of the parent node. If there is no parent node, this field must be empty.
- Alias: name, where name is the name of a the alias table you registered. You must have at least one alias table.
- These are common columns:
- Plan Type (cube name), Aggregation (cube name), Data Storage (cube name), Formula (cube name), Formula Description (cube name), these are typically defined for each cube you registered.
- Solve Order (cube name) this is defined for each ASO cube you registered.
Tip:
cube name is the name of the cube you registered. - Smart List The smart list names are optionally specified for nodes.
- Attribute Dimension Name The name of the attribute dimension entered during registration.
Note:
Additional columns can be imported and exported from the external application, see Dimension Properties and Member Properties.
- The import file's data is imported in row order. Rows for parent nodes must precede rows for child nodes. If a child node's row precedes its parent node's row, an error occurs when the file is imported.
- The import ignores duplicate rows.
-
Strings that contain the delimiter, quote, or line terminator (
CR/LF
) character for the file or that start with characters from ASCII 35 and below (such asTab
,!
or#
) will be surrounded by quotes. (For example,"# Children"
,"Accumulated Depreciation, Equipment"
.)
Note:
The import contains the logic to process shared nodes (Data Storage = shared) based on the requirements of Planning.