Changing the Advanced Properties for a Data Provider - Reporting Dashboards - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - external

Reporting Dashboards
Platform
OnBase
Product
Reporting Dashboards
Release
Foundation 23.1
License

The Advanced tab of the Properties dialog box is where you can change parameters that may affect dashboard and report performance.

Note:

Users must have the rights to create new data providers in order to access the Advanced tab. User rights and permissions are configured in the OnBase Configuration module.

To access the properties of a data provider in the Administration area:

  1. Select Data Providers in the left pane under Configuration Items. The data providers configured are listed in the right pane.
  2. Select a data provider to change in the right pane and click Properties in the Data Provider ribbon group or right-click it and select Properties from the right-click menu.

    The Properties dialog box is displayed.

  3. Select the Advanced tab.
  4. Enter a whole number in the Maximum number of result rows to return to limit the data set returned to the client to the number of rows configured, even if more rows than the maximum are returned by the database. The row limit is displayed in the dashboard viewer if the number of rows included in the dashboard is less than the number returned.

    To return all rows to the client, enter 0.

    The Maximum number of result rows to return setting is overridden if a global value for all data providers has been configured in the Reporting Dashboards Settings dialog box in the Configuration module.

    Note:

    The Maximum number of result rows to return should only be changed from 0 if performance issues in the environment are identified. Dashboards should always be configured using parameters that will only return a limited number of rows with relevant data.

  5. Enter a whole number in the Cache duration (minutes) field to cache the data returned for the number of minutes entered. Other users who access the same data source using the same Application Server will return the cached data for the duration of the cache time limit. Data is cached at the data source level. Enter 0 to not cache data.

    The Cache duration setting is overridden if a global value for all data providers has been configured in the Dashboards Report Settings dialog box in the Configuration module.

    Tip:

    Enabling caching may improve system performance and dashboard responsiveness, especially in systems where multiple users are accessing the same dashboard at the same time.

  6. Click OK to save your changes and close the Properties dialog box.