Updating Layout Templates in Batch Mode

SQR Production Reporting Studio supports a command-line option to update layout templates in a batch mode. This is a great benefit if you have many report layouts created from a single template.

The batch mode process connects to the data source. If you have reports from more than one data source, make a separate update.dat file for each of them; otherwise you will see a message stating, “Cannot locate user.”

Table 21. SQR Production Reporting Studio Switches

SwitchDescription

-T<batch filename>

Starts batch mode and returns to the DOS prompt after it updates the templates. Follow -T with the name of a batch file that contains one or more SRM file names (one file name per line). When the -T switch appears in the command line, it overrides anything else.

-Q

Regenerates the Production Reporting file corresponding to the updated SRM file. If the template for an SRM file is up-to-date, SQR Production Reporting Studio does not regenerate the Production Reporting file.

For example, assume you have the following update.dat file to update your reports:

c:\Hyperion\products\biplus\bin\SQR\Studio\samples\report1.srm
c:\Hyperion\products\biplus\bin\SQR\Studio\samples\report2.srm
c:\Hyperion\products\biplus\bin\SQR\Studio\samples\report3.srm
c:\Hyperion\products\biplus\bin\SQR\Studio\samples\report4.srm

You could use this update.dat file in the following command to update your layout templates in a batch mode:

developer -Tupdate.dat -Q

If you have reports from more than one datasource, make a separate update.dat file for each of them. For example, assume you have the following reports:

Quarterly_Sales (Oracle Financials)

Product_Analysis (Oracle Financials)

Marketing_Exp (Oracle Financials)

Cust_Cases (Siebel)

Parts_Tracking (Siebel)

*  To update these reports in a batch mode:

  1. Create two update.dat files, each containing the reports for one data source.

    OptionFile or Path

    Filename:

    updateOraFinancials.bat

    Contents:

    c:\Hyperion\products\biplus\bin\SQR\Studio\samples\Quarterly_Sales.srm

    c:\Hyperion\products\biplus\bin\SQR\Studio\samples\Product_Analysis.srm

    c:\Hyperion\products\biplus\bin\SQR\Studio\samples\Marketing_Exp.srm

    Filename:

    updateSiebel.bat

    Contents:

    c:\Hyperion\products\biplus\bin\SQR\Studio\samples\Cust_Cases.srm

    c:\Hyperion\products\biplus\bin\SQR\Studio\samples\Parts_Tracking.srm

  2. Run the update script for each of the update.bat files.

    When a script runs, SQR Production Reporting Studio lists the data sources used for all reports in the file. This is why separate files are necessary for each data source.

    To run the update script:

    1. Run the following command from a DOS prompt:

      cd c:\Hyperion\products\biplus\bin\SQR\Studio\samples
..\bin\developer ‑TupdateOraFinancials.dat –Q

    2. Select the data source from the Data Connection dialog box.