BackPrevious Page Next PageNext

Business View

A business view object in a catalog contains the following properties:

Property Name Description
Description Specifies the description of the business view.

Data type: String

Display Name Specifies the display name of the business view.

Data type: String

Maximum Duration Specifies the maximum elapsed time allowed to fetch data from the data source when the business view runs, measured in seconds. If the value is set to zero or is blank, it means the time will be unlimited.

For usage about the property, see Limiting the query run time and number of records.

Data type: Integer

Maximum Rows Specifies the maximum number of rows that will be fetched from the data source when the business view runs. If the value is set to zero or is blank, it means the number will be unlimited.

For usage about the property, see Limiting the query run time and number of records.

Data type: Integer

Prefetch When the property is true, JReport will fetch all the columns from the raw database that are referenced by the business view into cache and reuse them afterwards when end users run web reports or dashboards that use the business view. This reduces the querying and connecting times to the database and can help improve the runtime performance. However Prefetch=true does not work when scheduling to run web reports, therefore you may get different report results when running the same web report in different ways.

When the property is false, JReport will query data on demand. When several business view elements are based on the same columns, they will reuse the columns.

The property also affects the following:

  • When it is true, the List<ColumnInfo> parameter in the implementation class of the QueryOptimizer interface will include all columns in the business view, otherwise it will only include columns used by the report or dashboard.
  • When it is true, all the parameters used by the business view will be prompted in the dialog for specifying the parameter values at runtime, otherwise only the parameters referenced by data objects that are used in the report or dashboard will be prompted.

Data type: Boolean

BackPrevious Page Next PageNext