1. Business Intelligence Connector
  2. Publishing Reports to the OpenAir OData Service
  3. Configuring OpenAir to Publish Reports Automatically and Refresh Published Reports Periodically

Configuring OpenAir to Publish Reports Automatically and Refresh Published Reports Periodically

If the Business Intelligence Connector feature is enabled for your account and if you have the Publish reports role permission, you can use the Schedule feature in the OpenAir Reports application to publish your reports automatically at regular intervals. Publishing your reports automatically on a daily, weekly or monthly basis will refresh the report data available from the OpenAir OData service.

You can configure OpenAir to refresh each published report automatically twice on the same day, and specify the times for each refresh. This option is only available if the Business Intelligence Connector feature is enabled for your account, and only for reports published to the OpenAir OData service.

If your BI tools connect to the OpenAir OData service and are configured to refresh automatically, the data you see in these tools will be refreshed according to the same schedule. For more information, see Connecting BI Tools to Your OpenAir OData Feed.

To configure OpenAir to publish a report automatically and periodically to the OpenAir OData service:

  1. Go to Reports > Saved reports > My reports.

    Saved reports list view including the Schedule action.

  2. Click the schedule icon Schedule icon in the Action column for the report you want to publish. The Schedule report form appears.

    Report scheduling form

  3. In the General section of the Schedule Report form:

    1. Check the Run the report at the following time box.

    2. Select a Day and time to set the frequency of publication. The publication schedule can be set to run everyday, or on a specific day of the week or month.

    3. Check the Publish to OData Server box and select the scope if use for the published report from the dropdown options. The option you select determines whether the published report data is available for use with business intelligence tools connected to your OpenAir OData feed, or for export to NetSuite using OpenAir NetSuite Connector, or exclusively for use with User Scripting. See Published Report Scope of Use.

      Report scope of use dropdowm list

    4. You can refresh published reports twice on the same day. To do so, check the Refresh at box and select a second publication time for your report.

      Second refresh time selection for published report.

    5. If your role permissions allow you to share your published reports with owner’s permissions, and if you are publishing a shared report, choose a Permission setting for OData Server. The option you choose determines whether others have access to your published report data in the OpenAir OData service. For more information about sharing permissions, see Sharing Published Reports With Other Employees in Your Company.

      Important:

      When publishing a report for export to NetSuite using NetSuite Connector, the leading practice is to keep the default Do not share permission setting. The owner of the report must be the account administrator managing the NetSuite Connector configuration.

  4. Click Save.

Related Topics