runComplianceReport
Generates a report that is defined in Reconciliation Compliance.
See these information sources in Administering Account Reconciliation:
- Using Reports for instructions on defining reports.
-
Generating Predefined Reports in Reconciliation Compliance for a list of predefined Reconciliation Compliance reports and the parameters for generating them.
Applies to
Account ReconciliationRequired Roles
- Service Administrator
- Power User
- User
- Viewer
Usage
epmautomate runComplianceReport FILE_NAME GROUP_NAME REPORT_NAME REPORT_FORMAT [Param=value] where:
-
FILE_NAMEis a unique file name for the report that will be generated. If a report with this name exists on the server, it will be overwritten. Use thedownloadFilecommand to download this report to a local computer. -
GROUP_NAMEis the name of the group with which the report is associated. -
REPORT_NAMEis a unique name for the report to be generated. -
REPORT_FORMATis one of the following formats for the report:- HTML (not supported for graphs and charts)
- XLSX (not supported for graphs)
- CSV
- CSV2
Note:
REPORT_FORMATCSVdoes not permit the formatting of data based on a template whileCSV2does. GeneratingCSV2formatted report takes more time compared toCSVoutput. Param=value, optionally identifies the required parameters for generating the report. For example, theBalance By Account Typereport takes two parametersPeriodwith the valueJuly 2017andCurrency Bucketwith the valueEntered. You should specify these parameters as"Period=July 2017" "Currency Bucket=Entered".
Example
epmautomate runComplianceReport "Example_File Name""Reconciliation Manager" "Balance By Account Type" PDF "Period=July 2017" "Currency Bucket=Entered"