Create a Conversion File - OPTIONS

Conversion files define the mapping by dimensions from external member names to internal member names.

They also provide the ability to perform arithmetic and rounding on data as it
is converted. You create one conversion file per dimension in a transformation. Each conversion file can contain one or more sheets for different types of data transformations.

OPTIONS:

FORMAT = DELIMITED
There is no default so this option must be defined. You must enter a format type. Delimited means that there is a special character between each column of data, defined by the Delimiter option (below). Fixed means that the data is in a fixed field format.

HEADER
Default: YES If YES, then your input file contains one header row that defines the fields.
DELIMITER can be COMMA | SPACE | TAB Default:, (comma) If the FORMAT option is set to DELIMITED, this option defines the single character that is the delimiter between columns. Use the keywords SPACE or TAB if space or tab-delimited.
 
SKIP = Default: 0 (zero) Number of lines to skip at the top of a data file. If your data file has a header, set this value so that thoselines are skipped during transformation. SKIPIF = NULL will skip a record is it null.
 
VALIDATERECORDS = No | Yes Default: No If YES, validate the mapping and that members exist, and map data in the proper order for BPC.
  
CREDITPOSITIVE = Default: YES, If Yes, all amounts referring to an ACCOUNT type (LEQ, INC) will have their signs reversed.

MAXREJECTCOUNT = The number of bad records before the entire load fails.
  
ROUNDAMOUNT =Default: no rounding. Specifies the amount of decimal places to round values during the transformation.