Automap Wildcarding

FDM enables target-account or target-entity derivation by permitting the placement of wildcard characters (* and ?) in both source and target members. Mapping-table records that have wildcard characters in both the source and target column are considered to be Automap.

Example Automap

Rule NameRule DescriptionRule ValueTarget Account

w0011--

Cash Accts

0011??

Cash.??

Example General Ledger Trial Balance Records

GL AccountCenterDescriptionAmount

001100

0160000

Cash In Bank

1000.00

001101

0000000

Cash Corp LB

2000.00

001116

0001000

Petty Cash

1000.00

223500

0160000

AP

5000.00

Resulting Record Conversion

GL Account DescriptionHyperion Account

001100 0160000

Cash.00

001101 0000000

Cash.01

001116 0160000

Cash.16

Explanation of the Conversion Process

The criteria for the Automap entry (Like 0011??) retrieves the first three records from the general ledger trial balance. Because the Automap entry contains wildcard characters in the target account column, FDM must search the source account to replace the wildcard characters within the target account with actual characters from the source account.

The source-account characters represented by the two hyphens (under Rule Name) are used to replace the two question marks that follow Cash (under Target Account). Next, FDM verifies that the new target accounts (Cash.00, Cash.01, Cash.16) are valid target accounts. If the accounts are valid, the derived values are assigned to the trial balance as the target account values.