Integration & IT Modernization

How to Create a FDMEE Report in 11 Steps

Late Afternoon Toned Photo Of California Farm With Irrigation

FDMEE reports provide a solution that incorporates the source and target data, templates, and user-defined SQL queries. Templates, created in Oracle Business Intelligence Publisher, consume data in XML format and generate reports dynamically. SQL queries can be created to extract data from FDMEE internal tables and coupled with report parameters to extend the definition of a standard report.

Here is a detailed step by step on how to create the FDMEE report:

  1. Use SQL development tools, like SQL Management Studio for SQL server, to develop the SQL query on FDMEE database tables.
  2. In FDMEE “Query definition”, click “Add” to add the new SQL query for each select, where and by sections: FDMEE Report Query
  3. In the above Where section, those are report parameters: “~POVCAT~”, “~STARTPERIOD~”, “~ENDPERIOD~”, “~POVLOC~”. “~POVCAT~” is for the POV category, “~STARTPERIOD~” and “~ENDPERIOD~” are from the POV period, “~POVLOC~” is for POV location.
  4. Click “Validate Query” to validate query:Validate Query, and expect to see the “successful” message and save query:    FDMEE Query Success
  5. click “Generate XML” to create an xml file, and save the file. This file needs to be accessible from or transferred to the PC where “BI Publisher” installed.
  6. Open the Microsoft Word where “BI Publisher” installed, make sure seeing the “BI Publisher” tab:Bi
  7. Click the “Sample XML”, select the XML file exported in step 5: Samplexml     
  8. After completion of creating a template, firstly save the report as RTF format:Rtf
  9. Click  “Translation” in the “Tools” tab, then “Extract Text ….”, and save the file as XLIFF format with the same file name plus “_en”:En
  10. In “Report Definition”, click “Add”, and input Name, Group, Query, Template, and parameters: Report
  11. For template selected in step 10, needs to be uploaded firstly, RTF template should be uploaded to “templates” folder and XLIFF template to “en” folder:                                        Template
Oracle - Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud
Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud

Explore key considerations, integrating the cloud with legacy applications and challenges of current cloud implementations.

Get the Guide

 

 

After a report is created, it can be executed directly in the Workflow tab in FDMEE, or scheduled by using utility “runreport.bat” in DOS or Linux/Unix shell.

About the Author

More from this Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to the Weekly Blog Digest:

Sign Up