Relational modeling

Harmonization of export/import between relational modeling and Financial Consolidation

To synchronize the format of the relational modeling export file and the Financial Consolidation data import file, the import to Financial Consolidation was adjusted. You can use the file from the relational modeling export, using the BudgetingMain table, as an import file directly into Financial Consolidation using the Consolidation Data dialog box. You can use a comma, tab, space, semicolon, or pipe as delimiters. These are the same settings that are available in the export settings for relational modeling. Commas or dots are supported as decimal separators when importing into Financial Consolidation.

The import does not support thousands separator. For example, 10,000.99 generates an error during the load.