Previous Topic
Business View Properties
This topic describes 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 to add "tablename_" as the prefix of the table names in the default mapping names of their columns, this property determines whether to automatically append the same prefix in the default display names of the view elements in the business view when you add view elements based on the columns. The two properties work independently from each another, meaning, you can set Use Mapping Name Prefix to "true" to automatically prefix column names with corresponding table names in a data source, 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, Designer still removes the prefix from the display name of the view element. You can also set this property via the same-name menu command 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. By default, the property value is blank, meaning the time is unlimited. For more information, see Limiting the Query Run Time and Number of Records. Data type: Integer |
| Maximum Rows | Specifies the maximum number of rows to be fetched from the data source when the business view runs. By default, the property value is blank, meaning the number is unlimited. For more information, see Limiting the Query Run Time and Number of Records. Data type: Integer |
| Prefetch | When this property is "true", Logi Report Engine fetches all the columns from the raw database which the business view references into cache and reuses them afterwards when users run web reports and dashboards that apply the business view at runtime. This reduces the querying and connecting times to the database and can help improve the runtime performance. However, "Prefetch=true" does not work when users schedule to run web reports, therefore they may get different results when running the same web report in different ways.
When this property is "false", Logi Report Engine queries data on demand at runtime. When several business view elements are based on the same columns, they reuse the columns. This property also affects the following:
Data type: Boolean |