Page History
| Table of Contents | ||
|---|---|---|
|
Overview
In addition to the UI configuration options within Yellowfin, a number of SQL-provoked settings exist, outlined below.
Enforce a global language
...
| Code Block |
|---|
INSERT INTO Configuration VALUES (1, "SYSTEM", "OVERRIDE_LANGUAGE", "zh_CN"); |
In this sample, “zh_CN” refers to the Java language locale code for the language you wish to enforce.
Also in this sample, 1 denotes the primary/default organization. This is a system-wide setting that cannot be enabled for specific client organizations; Therefore, this value must always be set to 1.
| Anchor | ||||
|---|---|---|---|---|
|
...
| Code Block |
|---|
INSERT INTO Configuration(IpOrg, ConfigTypeCode, ConfigCode, ConfigData) values(<IP_org>, 'SYSTEM', 'REPORTLOWMEMORYEXPORT', 'ON'); |
Remember to set your value for <IP_org> to either the primary org (1) or a client org.
Disable outer join check
During the creation of views, you can configure outer joins to be treated as inner joins when creating View relationships in the database.
...
In this sample, 1 signifies the primary/default organization.
| Anchor | ||||
|---|---|---|---|---|
|
Force Yellowfin to use legacy RC4 128 PDF encryption
When set to TRUE, this forces Yellowfin to use legacy RC4 128-bit encryption for PDFs rather than the default of AES 256-bit encrypted PDFs.
Use the following SQL to do so:
|
In this sample, 1 signifies the primary/default organization.