us-analytics.png
Ask an Expert
Topic: Oracle FDMEE

FDMEE Tutorial: Process Log Overcoming the API

One of the standard features of a US-Analytics implementation of FDMEE is an AftValidate script which sends an e-mail when the Validate Status (Validate fish) is not successful. When developing the script, one of the requirements was to attach the log file accessible from Workflow –> Monitor –> Process Details by selecting Show on the appropriate ID. For example, selecting Show for Process ID 76 from the image would display the log an excerpt of which is displayed after the FDMEE process details screen. 

eBook: Top 10 FDMEE & ODI Tutorials

Screen_Shot_2015-08-03_at_9.48.51_AM

Screen_Shot_2015-08-03_at_9.50.05_AM

In the past when developing with FDM Classic and now with FDMEE, I typically keep the Hyperion / Oracle provided administrator guide a mouse click away for reference purposes. After checking the Java API section of the document, I found getProcessLogFile in the Java API list which “returns the log file name for the given loadID”. With knowledge of the appropriate function obtained, I proceed to develop the script. Spoiler alert  the function does not return the log file name.

Screen_Shot_2015-08-03_at_9.51.35_AM

 The script I developed is similar to the BlogAftValidate image.

Screen_Shot_2015-08-03_at_9.52.31_AM

When the script developed, I test and the Console returns an error: “com.hyperion.aif.scripting.API’ object has no attribute ‘getProcessLogFile.’" After a short period of time checking syntax, I open an SR with Oracle Support. Once the support engineered conducts the appropriate Q&A, a consultative bug with Development is created. A few days later, the SR is updated with “The function is not actually included in the currently shipping library, and should not have been included in the documentation.” Not to be deterred, I start reviewing alternatives.

Screen_Shot_2015-08-03_at_9.53.27_AM

Knowing each FDMEE execution is logged, I check table AIF_PROCESS in the FDMEE repository which has a field labeled, LOG_FILE, which based on the name warrants a query to check.

FDMEE_Image_1

The query returns a result set which includes the log file and the Universal Naming Convention “UNC” of the file. Time to return to Eclipse and populate a variable which can be attached to an email as part of the script.

Screen_Shot_2015-08-03_at_9.55.04_AM

The code to obtain the log file is displayed from lines 14 to 34 in the first image below. A successful test of the code is displayed in the second image, concluding this tutorial.

FDMEE_Post_Image_2

 

FREE eBook: The Top 10 FDMEE & ODI Tutorials

Ask an EPM/BI Advisor

If you're here, you've got questions — and we've got answers. Book your consultation to ask us about any range of topics, including:

  • Evaluating EPM or BI technologies
  • Comparing on-prem vs. cloud
  • Planning upgrades and migrations
  • Estimating project costs and timeframes
  • And much more — ask us anything!

Let our experts tackle your toughest questions for you.

Let's Talk