Previous Topic
Business View Properties
This topic lists the properties of a Business View object in a catalog.
| Property Name | Description |
|---|---|
| Auto Add Prefix in Display Names | Similar to the data source property Use Mapping Name Prefix which controls whether the table names will be prefixed as "tablename_" in the default mapping names of their columns, this property decides whether to automatically append the same prefix in the default display names of the view elements in the business view when adding view elements based on the columns. The two properties work independently from each another, which means you can have column names prefixed with corresponding table names in a data source automatically by setting Use Mapping Name Prefix to true, but choose not to have the prefix for view elements by setting Auto Add Prefix in Display Names to false.
By default the property is false. In this case, when a column's mapping name contains the "tablename_" prefix which however is not automatically generated but user customized and you add a view element based on the column, the prefix will still be removed from the display name of the view element. You can also set this property via the same-name menu option in the Business View Editor. Data type: Boolean |
| 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, Logi Report 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 result when running the same web report in different ways.
When the property is false, Logi Report 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:
Data type: Boolean |