Blog

FDMEE Import Formats

Import formats are the mechanism that allows FDMEE to read and parse the source extract file. The import format identifies the file type (delimited CSV) and what information to pull from the file directly from the data source without manual file manipulation. Each data load location must be assigned an import group that will be used when importing data files. Import groups instruct FDMEE on how to interpret source files and transform them into data that can be loaded into the Hyperion Planning data structure. More data can be included in the file than match the dimensions and mapped via the FDMEE mapping tool and/or ignored.

The import format form is arranged in a master/detail format. In FDMEE , the top grid of the Import Format module shows the import group, and the bottom grid is where the fields for a group are defined.

Once the import format is created, the source file layout must remain the same for future data loading. Should the source file format change, the import will fail and the corresponding import format will need to be updated.

Import Scripts are commonly used to manipulate source data upon importing a source file into FDMEE . Import scripts are executed during the import process (source data being imported into FDMEE) and run on every line of the source file being imported. When Hyperion FDMEE reads a source file, it automatically skips every line that does not contain a valid or 0.00 amount, but scripts in the Amount field will still be executed.

FDMEE Import Formats

Contact MindStream Analytics

Want to learn more about FDMEE Import Formats ? The consultants at MindStream Analytics are here to help you take your reporting to the next level.


Latest testimonial

MindStream Analytics is a leading consulting firm focused on helping clients improve business understanding and decision making. With years of experience in the analytics and Business Performance Management area, MindStream offers customers services ranging from software selection and implementation to best practices for financial planning. MindStream will work with customers towards a solution that enhances value and offers more insight into their data. MindStream believes in the power of technology combined with new procedures to give customers better analytic capabilities


Partner SpotLight

Oracle Partner

Oracle

Oracle has the most comprehensive suite of integrated, global business applications that enable organizations to make better decisions, reduce cost

Oracle

Share: