Page History

...

INSERT INTO Configuration VALUES (1, "SYSTEM", "SKIPUSERDELETELICENCEREFRESH", "TRUE");

Disable Long File Name handling for AS400 Databases 

Version 9.11 introduced a change to handle long file names on AS400 databases. This impacted some Views created on AS400 data sources prior to 9.11. To enable those Views to work correctly, the long file name handling logic needs to be disabled. This can be done with the following configuration change:

INSERT INTO Configuration VALUES ( 1, 'SYSTEM', 'USE_LEGACY_AS400_TABLE_NAMING', 'TRUE');

Enable Millisecond logic for Oracle databases

This setting, when true, enables milliseconds to be correctly handled in Oracle, however turning it on can impact the performance of queries. If you do not need milliseconds in your reports, it is recommended to not set this or set it to FALSE. TO_DATE functionality will be the default if ENABLEMILLISECONDLOGIC logic is unset or FALSE. TO_TIMESTAMP functionality is enabled when ENABLEMILLISECONDLOGIC is TRUE.

INSERT INTO Configuration VALUES ( 1, 'SYSTEM', 'ENABLEMILLISECONDLOGIC', 'TRUE');

Enable the Access Filter Toggle in a Client Org

Version 9.11 introduced a change to automatically disable the ability for anyone building a report in a client organisation against a Primary Org Data Source to enable or disable any Access Filter applied to that report. This behaviour can be reverted to pre-9.11 behaviour using the following:

INSERT INTO Configuration VALUES ( 1, 'SYSTEM', 'ENABLECLIENTORGACCESSFILTERTOGGLE', 'TRUE');