View or modify configuration settings
- View or modify configuration settings
- Example settings
- New or updated settings
- See also
You can view or modify configuration settings in Dundas BI through an administration screen, so there's no need to access the Dundas BI server directly.
2. View or modify configuration settings
To view or modify configuration settings in Dundas BI, go to the main menu and click the Admin button.
Click Setup on the left. From the dropdown list of items, click Config.
The configuration settings are displayed in a table on the right.
2.1. Advanced settings
By default, advanced settings (such as App DB Query Timeout) are hidden. To see the complete list of settings, select the Show Advanced Settings checkbox in the top-right corner. Advanced settings are displayed in italics.
2.2. Filter by category or search for settings
Use the Search box or the Category dropdown to easily find the setting(s) you need.
For example, if you want to see only email-related settings, set the Category dropdown to Email. The table of settings will be filtered accordingly.
2.3. Setting scope
For scalability, Dundas BI supports server groups (i.e., multiple servers) for handling application or data processing. This means that while each configuration setting may have a built-in default value, you can override each setting on different levels such as globally, per-server group, or per server. The override system works as follows:
- A configuration setting may have a built-in default value.
- A Global value for a configuration setting will override the corresponding default value.
- A Server group value for a configuration setting will override the corresponding global value.
- A Server value for a configuration setting will override the corresponding server group value.
Use the Setting Scope dropdown to view or modify the configuration setting values at the Global, Server group, or Server levels. If you don't provide a setting value at a certain level, it will just inherit the setting value from the lower priority level. For example, if you're at the Global scope and you don't specify the value for the Default Culture setting, it will just inherit the default value of en-US.
2.4. Source for a configuration setting
While you're viewing a particular setting scope (such as Global), you'll see a colored rectangle/icon beside each configuration setting. These icons indicate the source of the setting value that you're seeing. You can hover over one of the icons to get a tooltip that indicates the source of the value.
- Default - The setting value is the default, built-in value.
- Local - The setting value is set directly in the current setting scope.
- Inherited - The setting value is inherited from another scope.
2.5. View the details for a configuration setting
Click the information icon beside a configuration setting to see the details for that setting:
- A description of the setting.
- The default value of the setting (if any).
- Whether the setting is set in the current scope or not, and its value if it is set.
- The effective value of the setting and its source.
2.6. Modify a configuration setting
To edit/modify a configuration setting, make sure you are in the proper setting scope, and then click the Edit icon beside the configuration setting.
A dialog appears on the left, allowing you to reset the value back to default or to change it in the current scope. The actual options in the dialog will be different depending on the configuration setting.
3. Example settings
Automatic Windows Log On, otherwise known as Single Sign On (SSO), allows users to log on once on their workstation, and gain access to multiple systems without being prompted to log on again at each of the systems.
By default, Automatic Windows Log On is turned off in the Dundas BI configuration settings.
Before enabling this option, first ensure that the Log On Modes configuration setting is set to All or Windows.
Then set the Automatic Windows Log On configuration setting to True.
Note that Windows authentication must be enabled in IIS as well. For more details, see this Microsoft article: Configure Windows Authentication (IIS 7).
Once SSO is enabled, automatic logon will occur for all URLs that do not require explicit authentication. For example, navigating to http://yourinstance/ will take you directly to the home screen, whereas http://yourinstance/LogOn/ will still show the Log On screen.
3.2. Multiple Domain Support
This setting enables Dundas BI to work with multiple Active Directory domains. Activating the Multiple Domain Support setting lets you set up cross domain authentication by adding windows accounts and windows groups from another domain.
Under Category, select Authentication.Active Directory, select Edit Value, and tick the checkbox.
If your Active Directory domain controllers are not configured to support simple bind connections using Secure Sockets Layer (SSL), you have to disable the Simple Bind SSL Supported setting.
This configuration setting lets you set the page that appears when a user logs on to Dundas BI. It applies to all users application-wide as long as their Default View is set to Home (i.e., the user has not set a specific default view).
The setting value must be a relative URL like the one you get when you open a dashboard:
Or, it can be a relative URL like the one you get when you use the Share Link option:
Email settings must be configured for certain features to work, including notifications and password reset from the Log on screen.
Click the Category dropdown and set it to Email to see the available email settings. Note that some of the settings are advanced so you'll also need to select the Show Advanced Settings checkbox to see them.
The following table describes the various email settings. Dundas BI supports sending email via an SMTP server. Or, you can have the email messages delivered as files to a network share folder.
|Email Delivery Type||
The email delivery type to be used by the application:
|Email Pickup Directory||Email pickup directory location (applies when the email delivery type is Drop Folder). For example, set this to a network share folder.||\\server1\share|
|Sender Email Address||The sender of the email messages sent by the email firstname.lastname@example.org|
|SMTP Enable SSL||If enabled, SSL will be used when connecting to the SMTP server.||true/false (default)|
|SMTP Server||The SMTP server (applies when the email delivery type is SMTP). An optional port may be specified here as well (e.g. "smtp.example.com:25").||smtp.example.com|
|SMTP Server Password||The password for SMTP server authentication.||Leave empty if authentication is not required.|
|SMTP Server Username||The username for SMTP server authentication.||Leave empty if authentication is not required.|
There are a couple of ways to test the email settings after you've set them.
The first way is to go to the System Health admin section and click Test Email Settings. You'll be asked to enter an email address to receive a test email.
A second way to test is to create a Note-based notification and then add a note to a chart data point. Next, check your inbox or drop folder for the notification message. If you don't see the message, view the Dundas BI Log for any email-related errors (e.g., search for "Email"). If you get errors when using the Drop Folder delivery type, it may be due to permissions on the network share folder.
3.5. Internal Application URL
The Internal Application URL setting must be configured properly for scheduling-related features such as scheduled notifications to work properly. This URL is used by the Dundas BI Scheduler Service.
3.6. Log Filter
The Log Filter configuration setting lets you control the filtering of log messages. For each log channel (application area), you can independently set the level of logging you want (such as log only Critical messages or do Verbose logging). Use the scrollbar to see all of the available log channels.
If you change the level for a channel, you'll see it listed in the Live Preview section.
For example, if you set Query Audit to an Information level, every query sent to the database for data retrieval will be included in the log.
The Rserve Connection settings let you specify the details for connecting to an external R server. This is required in order to use the R language transforms such as R Data Generator.
If you have installed Rserve for Windows on your Dundas BI server for testing purposes, then the default Rserve Connection settings should suffice.
3.8. Additional Export Command Line Arguments
The exporting application in Dundas BI relies on the Chrome Embedded Framework (CEF), which sometimes requires additional arguments. The Additional Export Command Line Arguments setting lets you specify any a extra command line arguments required for the exporting application.
The following table describes the various CEF arguments supported in Dundas BI.
|--proxy=address:port||Specifies the proxy server to use (e.g. --proxy=192.168.1.42:8080).|
|--proxy-type=[http|socks5|none]||Specifies the type of the proxy server. The default server type is set to http.|
|--proxy-auth||Specifies the authentication information for the proxy server (e.g. --proxy-auth=username:password).|
List of new or updated settings in Dundas BI.
|Warehouse Bulk Insert Batch Size||Data||Specifies the batch size to use for SQL bulk insert operations. If zero, bulk insert operations take place in a single transaction. If non-zero, records are batched and each batch is committed in a separate database transaction. This setting affects only systems using SQL Server for the warehouse database.||0|
|Allowed Export Providers||Export||A list of allowed export providers. If empty, any export provider may be used. Otherwise, users will only be able to use the specified providers from the list. System administrators are not subject to this limitation.||None|
|Concurrent Export Thread Count||Export||The number of exports that can run concurrently. A value of 0 will turn off the queuing and allow unlimited exports to run (not recommended). The maximum value is 100.||5|
|Export Result File Lifetime||Export||The length of time a file will remain available for download after it has been created. The minimum value is 30 minutes.||7 days|
|Auto-Generate View Thumbnails||General||Specifies whether thumbnails should be automatically generated for Dashboards, Reports, and Scorecards whenever they are checked in.||True|
|Path To JDBC Drivers||Java VM||The path to a folder that contains JAR files with JDBC drivers.||None|
|JVM Library Path||Java VM||The path libraries that are used by the JDBC drivers.||None|
|Allow Custom Email Recipients||Notifications||Indicates whether users are allowed to specify custom email addresses as notification recipients. If disallowed, only accounts already existing in the application can be chosen as recipients.||True|
|Email Address Domain Whitelist||Notifications||A comma-separated, case-insensitive list of email address domains (e.g. example.com). Any notification recipients with user-specific email addresses must match at least one of the domains in the list. If left empty, there is no domain restriction on notification recipients with user-specified email addresses. If custom email addresses for notifications are disallowed via the Allow Custom Email Recipients configuration setting, then the whitelist has not effect.||None|
5. See also
- Notifications (alerts)
- Configuring notifications and other scheduling features
- Viewing logging information
- How to reset the admin password
- Log on to Dundas BI
- Installing Dundas BI
- R Data Generator
- How to enable anonymous log on
- Setting a default theme for controls
- Turn off automatic saving for views