Submitting a Report

This example shows how to submit a report. The script calls a batch file that includes the necessary parameters instead of including the parameters directly in the script. Note that if you try to submit a report script with an equal sign (=) in the parameters, the script fails.

#

This sample Jython script provides code related to custom scripts. All the messages being logged (meaning printed) are visible in the process log file as per Log Level profile.

#

# Log the beginning of the script, at the INFO level

fdmAPI.logInfo("======================================================================")

fdmAPI.logInfo("Custom Script: Begin")

fdmAPI.logInfo("======================================================================")

# Execute the subprocess to call and run the batch file

import os

import subprocess

os.chdir("D:/ORCL/MW/EPMSystem11R1/products/FinancialDataQuality/bin")

myScriptName = "D:/ORCL/MW/EPMSystem11R1/products/FinancialDataQuality/bin/myreport.bat"

retcode = subprocess.Popen(myScriptName) 

fdmAPI.logDebug("The return code = " + retcode)

The myreport.bat file referenced above can contain the equal sign as a parameter as in the following:

runreport.bat <username> <password> "TB All Columns (Per,Cat,Loc)" "Period=Jan 15" "Category=Actual" "Location=AAA" "Rule Name=AAA" "Report Output Format=PDF"