10 End of Day Reporting

Authorized users in the Application Portal will have the ability to setup End-of-Day Reporting configuration. This End-of-Day Reporting configuration allows for specific reports to be scheduled for delivery when the property end-of-day (EOD) is identified from OPERA. These reports include:

  • Data Model-based BI Publisher Reports

    • Only BI Publisher Reports that are based upon a data model, not a Subject Areas, qualify for use during EOD.

    • For BIP reports to work with EOD, add a p_resorts and p_business_date as parameters in the Data Model.

  • Analysis Reports

    • For an analysis report to qualify for use during EOD, the report must have Property and Business Date as prompts under filters. This allows the values passed by the application to be ran.

End of Day Configuration

  1. If Service Account is not enabled, enable at this time.

  2. From the Navigation Menu, select End of Day Reporting.

  3. From the End of Day Reporting page, enter the code of the property to view or use the search option to pick from a list of properties.

  4. Once entered, click the Search button to load any reports configured for the property.

  5. Under the Reports register section will be any reports current scheduled to run at the end of day.

Add a New Report

Allows you to add reports to the End-of Day reports register for a property.

  1. Click the New button to add a new report.

  2. Using the Search and Select Report window, locate the BI Publisher report to have scheduled to run after EOD.

  3. Highlight the report and click the Select button.

  4. Under Select Destination, choose the destination for the Report to be distributed after the EOD. There are 4 options to choose from For BI Publisher report:

    1. Defined By Report: The Defined by Report option will utilize the destination(s) preconfigured under the bursting query for this report.

    2. Email: Email will prompt you to enter a single email address for delivery.

    3. Object Storage: When selection Object Storage, you will be prompted to provide the Prefix and File Name to use during delivery of the report. These are both case-sensitive fields.

    4. SFTP: You must chose from one of the defined Delivery Profiles prior to setting the Remote Directory and File Name to use for delivery.

  5. Click Save to save the report delivery configuration. For Analysis Reports, e-mail is the only available delivery destination

Repeat steps 1 through 5 for any additional reports to be delivered as part of the End of Day Reporting for this property.

Clone Reports to Property

For use with multi-property instances. If reports defined from one property are also the same needed for other properties, a clone feature has been made to copy existing reports register from one property to others without having to recreate each report job.

  1. Navigate to the Reports register for the property to clone.

  2. Click the Clone to Property button to prompt for a list of Properties to select for replication of the report jobs.

  3. Select at least one property and click the Save button to clone these reports to the selected properties.

Edit Property Report

In the case where you wish to change the destination of a report in the report registry for a property, you can edit the report. After changing, the next time the report is scheduled it will go to the new destination.

  1. Navigate to the Reports register for the property to edit.

  2. Click the Ellipses button on the report to expose the Edit Report option.

  3. Select the Edit Report option.

  4. Update the destination configuration of the report and click Save.

Delete Property Report

In the case where you wish to remove a report in the report registry for a property, you can delete the report.

  1. Navigate to the Reports register for the property to edit.

  2. Click the Ellipses button on the report to expose the Delete Report option.

  3. Select the Delete Report option to remove the report from the Report register.