Naming Conventions

Oracle Hyperion Financial Data Quality Management, Enterprise Edition uses the following methods to name open batch files:

1. Auto Create Data Load Rule—used when the data load rule is created the first time.
2. Existing Data Load Rule—used when the data load rule has been created in FDMEE.

When FDMEE creates the data rule name automatically, it checks whether a data rule with the " Location_Category" name exists. If the name does not exist, FDMEE creates the data rule using the file naming convention:FileID~Location~Category~Period~RR.ext (this example uses a ~ (tilde) file name separator).

• File ID–a free-form value used to sort the file for a given Location. Files are sorted by Location and within a location, the File ID is used to sort the files.

• Location–POV location

• Category–POV Category

• Period–POV Period

• load method–a two-character value. The first character indicates the import Format, and the second character indicates the export format.

  Valid values for import mode are A and R.

  Valid values for export mode are A, R, M, and S.

  For more information, see Open Batch Import and Export Load Methods.

• ext-–file extension (txt or csv)

When FDMEE finds that a data rule already exists for an open batch, it uses the file naming convention:   FileID~Period~RR.ext (this example uses a ~ (tilde) file name separator)

• File ID–a free-form value used to define the load order of batch execution. Batch files load in alphabetic order by file name.

• Data Load Rule–Data Load Rule name

• Period–POV Period

• load method–a two-character value. The first character indicates the import Format, and the second character indicates the export format.

  Valid values for import mode are A and R.

  Valid values for export mode are A, R, M, and S.

  For more information, see Open Batch Import and Export Load Methods.

• ext-–file extension (txt or csv)