This property when enabled helps you to run SQL queries at Database server end to get aggregated data while creating chart, matrix or using group by in summarized grid view. This helps to achieve faster response time to render the aggregated data in Intellicus.
Default: Enable
Example: SQL_AGGREGATION=Enable
Additional PropertiesManual Configurations
Additional properties that can be manually configured under ReportEngine.properties file are:
This is the location where the output report file will be generated
Syntax: OUTPUT_DIRECTORY=[Output Directory Path] (String)
Default:../reports
Example: OUTPUT_DIRECTORY=../reports
To specify the number of user requests that can be served simultaneously.
Syntax: USER_THREADS= [5] (int)
Default: 5
Example: USER_THREADS=5
This property is to enable/disable data caching. When a SQL is fired, report server caches result-set. This increases turnaround time for the report generation for the 1st time. The cached data is used for further generation requests for the same report (for example, re-running an ad hoc report using different filters). This is effective for all the reports using same SQL and same data connection.
Default: Disable
Example: DATA_CACHING=Disable
This property defines maximum size of the data cache. It can be set per user, per organization or as total cache size for all the organizations (including their users). Specify zero (no limit on cache size) or a positive integer and postfix it with M (MB) or K (KB)/ORG (organization) or USER (user) as the case may be. To specify it as total cache size (considering all org), omit ORG and USER.
Default=50M
Example: DATA_CACHE_TOTAL_SIZE=50M
This property is defined to enable/disable the SAAS based sub licensing
Syntax: SAAS_SUB_LICENSING= [enable/disable](String)
Default: Disable
Example: SAAS_SUB_LICENSING=Disable
This is to enable/disable printer listing.
Syntax: GET_PRINTER_LIST= [enable,disable] (string)
Default: Enable
Example: GET_PRINTER_LIST=Enable
Default values
In any of the following cases report server will consider default properties:
- Port Engine properties is not found at the right location.
- A property being checked by report server is not set at all.