You can use an ASCII file to transfer data from an internal financial consolidation and reporting system such as Hyperion Enterprise or an external source such as Compustat or Disclosure.
To transfer data from a database:
Export the data from your financial database into a comma-delimited ASCII file, and insert this heading on the ASCII file:
# Hyperion Strategic Finance Formatted ASCII File#
#comment
#delimiter=comma (or tab)
#format=name
#time, (list period labels here)
Ensure that the account names in Strategic Finance match those in the financial database. Most databases use the same account descriptions used by Strategic Finance for all outputs.
In Strategic Finance, set up a template with the same time-period structure and account names as your ASCII file.