There are several features in defaults tab. Let's examine each of these and how they affect BI PLUS.
Active Connection Max Time(Minute): All active connections to datasources will be reset once the time limit is reached. A new connection is made again when a report based on that database connection is run. You can view logs for this, it will appear as 'Creating new connection' in the log.
Admin SQL Color Threshold: Set the maximum characters where BI Plus will highlight key verbs and items in SQL. Once the SQL exceeds this threshold, it will all appear monochrome. Be careful of setting this too high as it has performance implications.
Allow Category Mapping for Callable Report Mapping: This feature allows you to set Categories and their child reports as Callable Report Mapping. By default this feature is disabled, allowing you to map individual reports only for the Callable Mapping embeddable interface.
Auto Fit Column Width: Auto Fit Column Width feature adjusts all columns width according to screen size area. You can enable this feature from the Defaults tab for all reports, also for individual report from the Table Properties tab in table reports by setting its value to 'TRUE'. Once the report is executed, you can enable/disable it dynamically from right click pop-up menu ⇒ Layout ⇒ Auto Fit column Width.
Auto Load SQL Helper: This specifies whether you want to automatically load SQL helper in SQL editor or not. If you set this to True, then for every selected report, the SQL helper will be automatically opened.
Automatic License Update: If this is set to 'True', then after license key expiry, BI PLUS will search for new license key on SMD website server. If a new license key is already generated for the customer's environment, then BI PLUS automatically picks up that license from the seemoredata.com server and applies it to the environment.
Business Week Start: This feature allows you to set business week start either from Monday or Sunday.
Chart Max Rows: This allows you to set maximum number of rows to be displayed in a single page of different types of chart report. This setting determines how many domain values are displayed on bar charts, plot charts, etc.
Chart Series Color Count: You can increase color series limit in Admin ⇒ Report Themes ⇒ Chart Report tab. These color series are further used in chart reports. The default colors series limit is 10.
Create Connection Timeout(Second): This feature tries to establish connection with the repository for the duration stipulated (in seconds). Once the time limit is reached, BI PLUS gives up trying to connect.
Database Server Time Enabled:
Database Server Time Offset:
Datasource SQL Allowed: Enabling this allows you to enter SQL in the datasource connection. SQL are entered in datasource properties. (Admin ⇒ Datasources ⇒ Modify ⇒ Properties ⇒ Type as SQL). Typically this might affect sessions, like 'alter session set schema = 'AP''
Default Evaluate SQL Rows: Allows you to set default number of rows to be returned when 'Evaluate Query' operation is clicked in the report editor.
Default Help Text: Allows you to enable/disable 'Report Help' feature. You can view 'Report Help' feature after run report operation is performed. Information for report help is added from Information tab ⇒ Help.
ETL Logging Enabled: Enable/disable ETL related logging.
ETL Run Exclusive: Specifies whether you want to run ETL tasks in parallel mode or in exclusive mode. In exclusive mode, the ETL tasks run one after another.
Email As for Scheduler: Allows you to set default output type for schedule reports. When a user schedules a report then the default file format for that scheduled report is set here. If you set this value to 'PDF', then in the scheduler ⇒ Schedule Report for USER ⇒ Recipient ⇒ Email As you will see PDF as the default type.
Export Token: Allows you to export a Token-Delimited File format. A CSV file uses a comma as the separating token, but you might want a pipe delimiter, tilde or something else.
Failed Login Reset Time: After several failed login attempts, BI PLUS locks that user. Here you set the duration (in minutes) that the user is locked out for.
Failed Login Threshold: Set number of failed login attempts allowed by BI PLUS. Once the limit is reached, that user is locked for specified amount of time.
Financial Year Start Month: Financial year start month is different for each country. Here you can set financial year start month according to your country.
Hyperlink Override: Discontinued
Image Base: Specify the relative path to load the images that are used in reports for icons, logos, etc..
Import Report Hierarchy: Every exported report is exported with its parent hierarchy. So when a report is imported, it can be imported in a specific category OR it can be automatically imported in a category according to its parent hierarchy. By default this feature is disabled and allows you to import the report object in any category.
Inactive Connection Clean Frequency(Minute): Specify time(in minutes) to remove inactive datasource connections.
Inactive Connection Max Time(Minute): Once the time limit is reached then all inactive connection will be removed.
Internal Database: BI PLUS supports HSQLDB and Oracle as internal databases for its repository. Default internal database is HSQLDB.
JNLP Memory Size(MB): Specify the JNLP maximum memory in
MB. JNLP memory is used for client side operations.
JNLP Window Height: Set default height of the JNLP window when BI PLUS is started.
JNLP Window Width: Set default width of JNLP window when BI PLUS is started.
Java Cache Dir: This is a custom setting and can often not be set for enterprise customers.
Keep Alive Enabled: Discontinued
Keep Alive Frequency: Discontinued
Keep Alive Max Time: Discontinued
Look & Feel: This changes look and feel of the entire BI PLUS application. The default value is Standard. It also accepts Classic to show classic look & feel. The Standard look & feel is recommended.
Maximum Row to Client: Specify the maximum number of rows should to display on a single page.
Messenger Autostart: If both 'Messenger Enabled' and 'Messenger Autostart' features are enabled, then BI PLUS users are logged into the chat menu automatically.
Messenger Enabled: Making this 'True' displays 'Chat' feature in Reports menu. This does not login to the chat application automatically.
Number Format Decimal Separator: This is generally a period, except in certain countries.
Number Format Group Separator: the thousands separator used. This is generally a comma
Offline Task End Time: Set the time to end offline tasks. Default time is 6.00 AM.
Offline Task Start Time: Set the time to start offline tasks. Default time is 10.00PM.
Parameter Report Column Count: When you have multiple parameters in a single report, you can set how many you want in a single line (to save screen real estate).
Password Case Sensitive: Enable/Disable case sensitivity of passwords. If the password sensitive is enabled then password 'ADMINPASS' and 'adminpass' are interpreted differently.
Pivot Popup Timeout: Set the duration (in seconds) of a pivot pop-up dialog before it disappears.
Recent Report Enabled: Enable displaying the list of recently executed reports in reporter interface.
Recent Run Reports: Set number of reports to be displayed in Recent Report Enabled:
Report Cache Memory Size: Specify the maximum memory size (in
MB) of report cache to be stored in memory.
Report Cache in Memory Expire Time: Specify expiry time for report cache in memory. Once the duration limit is reached, the cache will be deleted.
Report Data Date Format: This is the date format used to display date type in reports.
Report Data Compression Size: Set the minimum dataset size for enabling compression. When running over slow networks, compressing and uncompressing saves a lot of time in data transmission. You will get no noticeable performance gains before 40 KB is reached.
Report Data Compression Size Enabled: Enables/Disable report data compression feature.
Report Data Encryption: Specifies encryption used for Report data. Valid values are 'DES' and 'DESede'.
Report Data Encryption Enabled: Enable/Disable report data encryption. By default encryption is disabled.
Report Data Encryption KeySize: Specifies the keysize for report data encryption.
Report Disk Cache Type: Specify what kind of caching mode the users are to use. 'None' does not cache anything at all. 'Compressed' stores compressed cache on disk. 'Uncompressed' stores cache on disk without any compression.
Report Drag & Drop Enabled: Allows you to Drog & Drop reports in report tree. By default this feature is enabled.
Report History Frequency: Specify the time duration for the reports to stay in report history.
Report History Max Reports: Specify the maximum number of reports to keep in the reports history buffer.
Report History Max Time: Specify the maximum idle time for report history.
Reporter Show User Menu: Enables/Disables visibility of the 'User' menu inside BIPLUS.
Repository Backup Export Passwords: Allows you to export the password (like datasource, users) with repository backup.
Repository Backup Location: Define the path / location to save repository backups.
Reset Password Enabled: Enable/Disable visibility of the 'Forgot Password' feature on the login page.
Run Log Retain Days: Set number of days that the log should be retain by BI PLUS. This run log information in stored in BI PLUS repository's RPT_RUN_LOG table.
Run Report Click Count: Set number of mouse click needed to execute a report. This feature is applicable in reporter interface.
Run Report in New Tab: Every report executed will be opened in new tab so that you can analyze multiple reports. This feature is applicable in reporter interface.
SMD Calendar Back Year: Discontinued
SMD Calendar Forward Year: Discontinued
SMD Date Format: The Java date format to show date type values in the reporter interface.
SMD Function Date Format: Discontinued
SQL Start Allowed: SQL query for Data Manipulation commands (like INSERT, DELETE, UPDATE) are blocked in BIPLUS. If you want to start your SQL query other than 'SELECT' statement then mention that keyword here. Words like 'WITH', 'EXEC', 'EXECUTE' and 'DECLARE' give you more control and flexibility.
Scheduler Max Concurrent Reports: Maximum numbers of scheduled reports that can be run simultaneously.
Send Change Alert: An alert email is send to the Admin user when a report is checked-in by a user. Email information contains User_Name, Report_ID, UID and Comments.
Show Count: Shows record count returned after SQL query execution. Record counts are displayed at the top of each report.
Show Email Warning: Enable/Disable visibility of 'Warning Message' before sending a mail.
Show Environment: Shows environment name of your installed BI PLUS application in the title bar. Default environment name is 'BIPlus'.
Show Grid: Set the default value of 'Show Grid' feature in 'Flow Chart Properties' tab. Setting this to true enables grids for all flow chart reports.
Show Java Help: Discontinued
Show Language Selection: Setting this to 'true' displays language selection drop-down list on login page.
Show Loader: When you open BI PLUS in a browser, it displays the loading bar with the title 'Please wait while BI PLUS loads'. By default BI PLUS displays this loader. You can disable this loader with this setting.
Show Report Date & Time: Displays current Date and Time in report header.
Show Report Timer: Displays timer for report execution which specifies the time taken to execute a particular report.
Show SAP Datasources: Setting this to true displays SAP data-source at 'Admin ⇒ Datasource ⇒ Modify ⇒ Type ⇒ Write-back' location.
Stats Collection: making this to 'true' sends anonymous stats.
Table Row Style Count: Increase the Table Row Style color limit in Admin ⇒ Report Themes ⇒ Table Row Style tab. These color series are further used in Table reports. Default colors series limit is 9.
Tomcat Service Name: This name will be used when BI PLUS is updated to new version and tomcat service needs a restart.
Tree Sorting Order: Set Reports Tree sorting order. Sequence and Name are the values supported. Sequence sorts all reports according to the sequence they were created. Name sorts reports in alphabetical order.
Unsafe Extension: List the file extensions to be blocked from selected list. Multiple file extensions are seperated by ',' (comma) symbol.
Use Server Timezone for Clients: Enables server time-zone for clients.
Writeback Report Enabled: Enables datasource type for write-back report. By default this feature is disabled. Once you enable this feature you will be able to see Write-back at 'Admin ⇒ Datasource ⇒ Modify ⇒ Type ⇒ Write-back' location.
BIPLUS configuration settings are saved in the biplus.xml file. This file is found at C:\BIPLUS\Tomcat7\webapps\BIPLUS\configuration which is the default location. Open this XML file in WordPad or Notepad or in your favourite editor.