Tax Reporting Import and Export File Format

When you import and export data for Tax Reporting 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 Editing Dimensions in the Simplified Dimension Editor and Editing Member Properties using the Simplified Dimension Editor in Administering Tax Reporting .
• 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.

• 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 as Tab, ! or #) will be surrounded by quotes. (For example, "# Children", "Accumulated Depreciation, Equipment".)

• The import ignores duplicate rows.

Note:

The import contains the logic to process shared nodes (Data Storage = Shared) based on the requirements of Tax Reporting.