Specifying Load Options

Use the Options tab of the load inspector to specify the File Format, Processing, and Merge options for your load.

File Format Options

Field Description Example
Delimiter Character Character that separates text strings. Select a value, or select Specified and enter the delimiter characters in the Delimiter field. You can enter more than one character as a delimiter up to a maximum of 10, and you can use whitespace characters such as Space. Comma
Line Feed Style Character that advances to the next line

CR+LF (Windows)

CR Only (Mac)

LF Only (Linux)

Clear Value Keyword Keyword to clear the value for a property <clear>
Defined Empty String Keyword Keyword to replace defined empty values in the file No Data
Top Node Keyword Keyword that indicates that a node is a top node. Root

Processing Options

Field Description
Ignore Empty Fields

Specifies how empty fields in the load file are processed:

  • Enabled: No value is loaded for the property. (The value for the property will be null if it does not inherit a value and there is no defined or default value.)
  • Disabled: A defined empty value is stored for the property if the property data type supports defined empty values. If the property data type does not support a defined empty value, the load will display a warning and no value will be loaded for that property.
Expand Allowed Values

(Applies to loads in Replace mode only. Does not apply to dynamic allowed values lists.) Specifies whether or not new distinct allowed values can be added to properties with string and list data types that are set up to use allowed values when you run a load.

  • Enabled: Values in the load file that are not already in the list of allowed values for that property are added to the list of allowed values for that property.

    Note:

    If there are currently allowed values at the node type override level, the loaded allowed values are added to them. Otherwise, the new allowed values are added at the application override level.
  • Disabled: Values in the load file that are not already in the list of allowed values for that property are not added to the list of allowed values for that property.

Merge Options

Field Description
Process Deletes

Specifies how delete operations are processed during merge loads:

  • Disabled (default): Removes nodes from a bound viewpoint if they do not exist in the load file. No nodes are deleted from any bound node type.
  • Safe Mode: Removes nodes from a bound viewpoint if they do not exist in the load file. The removed nodes are also deleted from bound node types only if the nodes are not used in any other hierarchy node set or hierarchy set for the dimension.
  • Forced Mode: Deletes nodes from a bound viewpoint if they do not exist in the load file. These nodes are deleted from node types used by any node set and hierarchy set in the dimension.
Process Reordering

If enabled, this sets the order of the nodes in the viewpoint being loaded into to the order in which they appear in the load file.

Caution:

This option may generate a large number of request items if there are significant differences between the existing order and the order in the load file.

Default Data Source Enables you to optionally select a default data source for the data being loaded. During viewpoint load, each request item created in the load request is populated with the name of the data source that you selected.

Only data sources that are unregistered and enabled can be selected. See Understanding Data Sources.

Auto Submit Select to automatically submit merge load requests if there are no validation issues.
Bypass Approvals and Commits Select to bypass approvals and commits for auto-submitted merge load requests.