Dynamically Changing Import Formats

You can use the BefFileImport event to modify the import format for a location dynamically. The following script changes the import group; the change is based on the file name.

To implement the script, you create two import formats and assign one of them to the Oracle Hyperion Financial Data Quality Management, Enterprise Edition location. The script evaluates the file name and, if necessary, changes the import format.

if fdmContext["LOCNAME"] == "ITALY":

  filename = fdmContext["FILENAME"]

  if filename[:12] == "ProductSales":

    fdmAPI.updateImportFormat("SALESJOURNAL", fdmContext["LOADID"])