Dataset

The properties of a dataset object in a library component are:

Property Name	Description
General
Class Type	Indicates the class type of the object. This property is read only.
Data Name	Shows the name of the query or business view in use. It can be null. When it is null, the available resources for the dataset are parameters and constant level formulas in the data source.
Data Source Name	Specifies the name of the data source. This property is read only.
Is Query	It is true when the dataset is based on a query or false when based on a business view.
Others
Data Driver	Specifies the cached query result file as the data resource. Usually used for support purpose. The input format for cached query result file is as follows: jrquery:/jet.universe.resultfile.UResultFileResultSet;Fullpath_of_cached_query_result Data type: String
Maximum Records	Specifies the maximum number of records you want to display for all of the data components using this dataset. The default is to display all the records. Data type: Integer
Security
Security Policy Name	Specifies the name of the data source security imported from the catalog. Choose a security policy from the value drop-down list. Data type: String Note: Column-level security (CLS) is not supported on library component at present, so for a library component, only the data source security policies which have not been defined with CLS will be available in the value list.
Data Buffer
Maximum Page Number	Specifies the maximum number of pages in the data buffer. Data type: Integer
Records per Page	Specifies the number of records in each page in the data buffer. Data type: Integer

Property Name

Description

General

Class Type

Indicates the class type of the object. This property is read only.

Data Name

Shows the name of the query or business view in use. It can be null. When it is null, the available resources for the dataset are parameters and constant level formulas in the data source.

Data Source Name

Specifies the name of the data source. This property is read only.

Is Query

It is true when the dataset is based on a query or false when based on a business view.

Others

Data Driver

Specifies the cached query result file as the data resource. Usually used for support purpose.

The input format for cached query result file is as follows: jrquery:/jet.universe.resultfile.UResultFileResultSet;Fullpath_of_cached_query_result

Data type: String

Maximum Records

Specifies the maximum number of records you want to display for all of the data components using this dataset. The default is to display all the records.

Data type: Integer

Security

Security Policy Name

Specifies the name of the data source security imported from the catalog. Choose a security policy from the value drop-down list.

Data type: String

Note: Column-level security (CLS) is not supported on library component at present, so for a library component, only the data source security policies which have not been defined with CLS will be available in the value list.

Data Buffer

Maximum Page Number

Specifies the maximum number of pages in the data buffer.

Data type: Integer

Records per Page

Specifies the number of records in each page in the data buffer.

Data type: Integer

Notes:

The properties should be set according to different databases, namely, different databases may have different configurations of data buffer.
If the library component runs in a different environment, the properties should be specified again.
As tested, if enough physical memory is available, and you know the total number of records in the dataset, then you can set Records per Page approximate to the total number of records to achieve better performance. Maximum Page Number is related to the library component, and should not be very large.
The size of data buffer should be less than the available physical memory.
The Heap Size should be set when the data buffer is quite large.