Determines whether the query limit can extend to 60 minutes to accommodate the occasional, longer running query.

• On — The query limit can be extended to 60 minutes.

• Off — The Maximum Query Limit setting on this page is used and never extends.

Default: Off

Edition: Professional and Enterprise

Specifies the frequency at which the Data Watch service must scan the server for changes based on the frequency of changes in your data sources.

The default is 240 (4 hours). You can disable this service by changing this setting frequency to 0 or by toggling the Mobile Watch Service Enabled setting to off.

Valid Values: 0-10139

Default: 240

Edition: Professional and Enterprise

Specifies whether to enforce strict checking for date and time data types and whether to reject queries that contain incompatibilities in date and time data types.

• On — Enforces strict checking for date and time data types.

• Off — Relaxes strict checking for date and time data types. However, invalid queries or queries with severe date and time incompatibilities may still be still rejected. For example, date and time incompatibilities might be rejected if your relational database uses strict checking for those data types.

Default: On

Edition: Professional and Enterprise

Specifies if semantic models load using multiple threads. If you find that your large datasets load slowly and impact system processing times, enabling this option may improve performance.

Default: Off

Edition: Enterprise only

Specifies whether the Auto Insights feature is available when datasets are created or modified.

• On — The Enable Insights option is available in the Dataset Inspect dialog and insights are automatically generated and available for workbooks that use datasets with the Enable Insights option selected.

• Off — Auto Insights and its related features are disabled.

Default: On

Apply Change Required: No, but when you change this setting, it may take a few minutes to take effect.

Specifies whether to display available dashboard content immediately or wait until all the dashboard content is ready.

Default: Off

Edition: Enterprise only

Specifies if the Data Watch service is active.

• On — The Data Watch service is active and all mobile users can specify the threshold value for bring backs.

• Off — The Data Watch service is inactive.

Default: On

Edition: Professional and Enterprise

Specifies who can issue database functions: EVALUATE, EVALUATE_ANALYTIC, EVALUATE_AGGR, and EVALUATE_PREDICATE.

By default (0), the EVALUATE database functions are disabled.

Valid Values: 0, 1, 2

Default: 0

Edition: Professional and Enterprise

Specifies whether the Database Analytics node is displayed in data flows.

Default: On

Edition: Professional and Enterprise

Restricts the maximum number of rows users can export or deliver by email in formatted and unformatted content. Data export and delivery limits depend on the size of your service.

Valid Values: Maximum - no restriction, 90% of Maximum, 80% of Maximum, 70% of Maximum, 60% of Maximum, 50% of Maximum, 40% of Maximum, 30% of Maximum, 20% of Maximum, 10% of Maximum, Minimum - 1000 rows

Default: Maximum - no restriction

Edition: Professional and Enterprise

Specifies the maximum length of time a single query can run before it's canceled and users see a timeout message. The default is 660 seconds (11 minutes).

Valid Values: 60-660

Default: 660

Edition: Professional and Enterprise

Specifies whether brushing is enabled by default for workbooks that use data from subject areas.

Users can override this setting in the workbook and canvas properties.

Default: On

Edition: Enterprise only

• On — Data caching is enabled.
• Off — Caching is disabled.

Default: On

Edition: Professional and Enterprise

Specifies whether brushing is enabled by default for workbooks that use dataset data.

• On — Brushing is on by default for workbooks that use dataset data.

• Off — Brushing is off by default for workbooks that use dataset data.

Users can override this setting in the workbook and canvas properties.

Default: On

Edition: Professional and Enterprise

Specifies how to encode MIME email parameters. By default, RFC 2047 is used.

• On — Use RFC 2231 to encode MIME email parameter values. RFC 2231 supports multi-byte languages. Select On if you deliver emails that contain multi-byte characters and use an email server that supports RFC 2231, such as Microsoft Outlook for Office 365 or Google Gmail.

• Off — Use RFC 2047 to encode MIME email parameter values.

Default: Off

Edition: Enterprise only

Specifies whether to include the names of email recipients in the To: or Bcc: line. By default, email recipients are added to the Bcc: line.

• On — Add email recipients to the Bcc: line. Names of email recipients are hidden.

• Off — Add email recipients to the To: line. Everyone who receives the email sees the recipient list.

Default: On

Edition: Enterprise only

If you want to restrict the email domain that Oracle Analytics can send emails to, enter the name of the domain. For example, examplemaildomain.com.

Use a comma to separate multiple domain names. For example, exampledomain1.com,exampledomain2.com. By default, there are no restrictions.

Edition: Enterprise only

Specifies the maximum number of recipients allowed in the To: or Bcc: line for a single email.

You can set the maximum number of email recipients to avoid some SMTP servers from filtering out these emails as spam. If the recipient list exceeds the set limit, the list is split into smaller lists with the maximum number of allowed recipients in each list.

Valid Values: 0-1024

Default: 0 (unlimited number of email recipients)

Edition: Enterprise only

Specifies the maximum size (KB) of a single email.

If you set a maximum email size, you can avoid situations when SMTP servers reject emails that are too large, and in the event that an email exceeds the set limit, the email recipients receive an error message instead of the agent failing and just alerting the email author.

Valid Values: 0-20480

Default: 0 (unlimited email size)

Edition: Enterprise only

Specifies if a detailed message is displayed during data load processing.

• On — Detailed loading messages are hidden and a simplified message Loading... is displayed instead.

• Off — Detailed loading messages are displayed.

Default: Off

Edition: Professional and Enterprise

Specifies the path of the dashboard page that's displayed by default when users sign in to . For example, /shared/<folder>/_portal/<name>.

You can specify a single path for all users and multiple paths by user role, for example {"application role 1":"catalog dashboard path 1","application role 2":"catalog dashboard path 2","default":"catalog dashboard path 3"}.

This setting applies to all users, but users can override it after they've signed in.

You can enter a maximum of 5,000 characters in this field.

Edition: Enterprise only

Specifies if sub-requests to source databases are executed separately as standalone queries or executed together. By default, sub-requests are shipped separately which can improve performance if you execute complex reports with a large group of sub-requests, that is, you prefer to ship the sub-requests separately in multiple simplified queries rather than ship a large single complicated query all at once.

In Oracle BI Enterprise Edition, the default is set to NO. If you used Oracle BI Enterprise Edition and want to retain the previous default behavior, set this property to NO to continue executing database sub-requests together.

• Default — Database sub-requests are shipped separately. This is the same as the value YES.
• YES — Database sub-requests are shipped separately.
• NO — Database sub-requests are shipped together, all at once.

Default: Default

Edition: Professional and Enterprise

Applies to content migrated from Oracle BI Enterprise Edition.

After you migrate content from your Oracle BI Enterprise Edition environment to , you may experience different sorting behaviors in analyses.

For example, if you look at a migrated analysis in Polish, the upper case and lower case letters might sort based on the default locale, not the original Oracle BI Enterprise Edition locale. To preserve the Oracle BI Enterprise Edition sort behavior in , change this setting to Polish.

Edition: Professional and Enterprise

Applies to content migrated from Oracle BI Enterprise Edition.

After you migrate content from your Oracle BI Enterprise Edition environment to , you may see a different language in messages, dates, or currencies within analyses.

For example, if you look at a migrated analysis in Polish, the currencies or dates might display based on the default locale, not the original Oracle BI Enterprise Edition locale. To preserve the Oracle BI Enterprise Edition currencies and dates in , change this setting to Polish.

Edition: Professional and Enterprise

Determines whether action links that users add to analyses and dashboards can invoke any URL or only URLs that administrators specify in the safe domains list.

• On — Don't allow actions to invoke any URL that's not in the safe domain list.

• Off — Allow actions to invoke any URL, even if the URL isn't listed as a safe domain.

Default: On for a brand new service and Off for an existing service.

Apply Change Required : No

Edition: Enterprise only

Specifies whether to enforce strict recursive data type checking for comparisons between identical data types (for example, integer to integer) or non-compatible data types (for example, integer to short integer) on all data sources or with all datasets.

• On — Enforces strict recursive checking for identical or non-compatible data types on all data sources or datasets.

• Off — Relaxes strict recursive checking for date and time data types on all data sources or datasets. However, if there are too many data type inconsistencies, you may want to change the data types to be compatible or use constants of the correct data type when comparing a column to a value. For example, after you migrate content from Oracle BI Enterprise Edition to , you might start seeing this type of check error in your reports because eary versions of Oracle BI Enterprise Edition didn't enforce strict checks:

  [nQSError: 22024] A comparison is being carried out between non-compatible types <type1> and <type2>.

Default: On

Edition: Professional and Enterprise

Specifies whether cells that span rows and cells that span columns are repeated when exporting tables and pivot tables to Excel.

• On — If switched on, cells that span rows and cells that span columns are repeated, regardless of the Value Suppression setting in the Analysis editor.
• Off — If switched off, the Value Suppression setting in the Analysis editor is honored and cells that span rows and cells that span columns don't repeat when exporting tables and pivot tables to Excel.

Default: Off

Edition: Enterprise only

Specifies whether to sort NULL values before other values (On) or after (Off). Select the value that matches your database. If this setting doesn't match your database setting, then the database setting takes precedence.

• On — Sorts NULL values before other values.
• Off — Sorts NULL values after other values.

Default: Off

Edition: Professional and Enterprise

Specifies whether the automatic removal of trailing spaces from varchar columns is enabled (Off) or disabled (On). For example, when this property is enabled (Off), when a user starts entering values in a field, the filter dialog automatically trims any trailing spaces.

• On — Preserves trailing whitespaces in varchar columns. If you primarily use Oracle Database sources, you might want to keep the default Oracle Database behavior of preserving trailing whitespaces rather than removing them. When you toggle this property on, you avoid the overhead of trimming spaces, and this can improve performance.

  If you disable this property (set it to On) and you construct a filter such as PRODUCT_DESCRIPTION = 'My Product '), you must make sure the amount of trailing whitespace used exactly matches the varchar column value. If you don't, the filter won't correctly match the data values.

• Off — Trims trailing whitespaces in varchar columns when processing queries. This is the default for . For example, if a user enters the text 'My Product ', it trims it to 'My Product'.

Default: Off

Edition: Professional and Enterprise

Specifies the Oracle Analytics Cloud URL format that's used to share links to workbook visualizations in scheduled emails. If your organization set up a vanity URL for your system, enter the existing vanity URL that you want to use in the format: https://myvanity.com/ui/

Alternatively, leave the setting blank to use the standard URL format in emails. See Share Visualizations Using Workbook Email Schedules.

Edition: Professional and Enterprise

Specifies whether the geometry data type is available for data columns.

• On — Enables you to use geometry columns in map visualizations and spatial geometry calculations.

• Off — Disables the geometry data type.

Default: Off

Apply Change Required: Yes

Edition: Enterprise only

Specifies if mobile application push notifications are enabled (on) or disabled (off).

• On — Enables mobile application push notifications to receive alerts and messages.

• Off — Disables mobile application push notifications to stop receiving alerts and messages.

Default: Off

Edition: Professional and Enterprise

To help people identify workbook content, Oracle Analytics can display thumbnail images for workbooks on the Home page. The information that’s shown in these thumbnails is blurred to protect sensitive data from being exposed to users that don't have the same access as data authors.

This setting overrides any Save thumbnails value set in the Workbook Properties dialog at the individual workbook level.

• On — Display blurred workbook thumbnails on the Home page. If this setting enabled (on), workbook owners can hide the thumbnail for individual workbooks if they need to.

• Off — Don’t display any workbook thumbnails on the Home page. Instead, show the standard icon for all workbooks.

Default: On

Edition: Professional and Enterprise

Specifies the number of minutes users are inactive before their browser or mobile connection must be re-authenticated.

• Valid Values: 5 - 480
• Default: 60
• Edition: Professional and Enterprise

Specifies whether to automatically sign out users after the inactivity timeout is reached.

• On — Users are automatically signed out when the inactivity timeout is reached.
• Off — Users remain signed in even if the inactivity timeout is reached.
• Default: Off
• Edition: Professional and Enterprise

Specifies if leading apostrophes are added when data is exported to CSV or tab-delimited files, so all fields are treated as text.

• On — Leading apostrophes are automatically added to CSV and tab-delimited files during exports.

• Off — Data is exported to CSV files as-is.

  Caution:

  When Off, opening exported CSV files may invoke unwanted formulas.

Default: Off

Edition: Professional and Enterprise

Specifies the URL for the JavaScript file containing custom Browser Script Actions.

Edition: Enterprise only

Determines whether users can apply and save HTML, JavaScript, and CSS markup in various text fields for analyses and dashboards, and how any previously saved markup is used.

• Always — Enables users to apply markup. Displays the Contains HTML/JavaScript/CSS Markup option in dialogs where additional formatting might be useful. For example:

  • For analyses: Various dialogs in the analysis editor, Analysis Properties dialog, Column Properties (Column Format) dialog, Edit Column Formula dialog, Narrative dialog, Ticker dialog, Static Text dialog, and New Calculated Measure dialog.
  • For dashboards: Various dialogs in the dashboard editor, Text Properties dialog, and Edit Header and Edit Footer dialogs (under Print and Export Options).

• Never — Prevents users from applying markup. Hides the Contains HTML/JavaScript/CSS Markup option. Users can only enter plain text. Oracle Analytics ignores any markup that users previously entered and saved for their analyses and dashboards.

• HTML Only — Enables users to apply HTML markup. Displays the Contains HTML/JavaScript/CSS Markup option in dialogs where additional formatting might be useful but only safe HTML is allowed (no JavaScript or CSS). When an analysis or dashboard opens, Oracle Analytics sanitizes any markup that users have entered and applies only the HTML markup.
• On Open — Prevents users from applying additional markup (existing markup is retained). Hides the Contains HTML/JavaScript/CSS Markup option so users can enter only plain text. Any previously saved markup for analyses and dashboards continues to be applied.

  Note: The On Open option was previously named "Off".

Edition: Enterprise only

Specifies how data scrolls in tables, pivots, heat matrix, and simple and advanced trellis visualizations.

• On — Data displays with a fixed header and content scrolling controls for users to browse the data.

• Off — Data displays with content paging controls for users to browse the data.

Default: On

Edition: Enterprise only

Specifies whether the Display/Hide Running Sum option is selected by default in the Analysis Properties dialog: Interactions tab.

• On — The Display/Hide Running Sum option is selected by default in the Analysis Properties dialog: Interactions tab.

• Off — The Display/Hide Running Sum option isn't selected by default in the Analysis Properties dialog: Interactions tab.

Default: Off

Edition: Enterprise only

Specifies whether the Display/Hide Sub-totals option is selected by default in the Analysis Properties dialog: Interactions tab.

• On — The Display/Hide Sub-totals option is selected by default in the Analysis Properties dialog: Interactions tab.

• Off — The Display/Hide Sub-totals option isn't selected by default in the Analysis Properties dialog: Interactions tab.

Default: Off

Edition: Enterprise only

Specifies whether the Drill (when not a primary interaction) option is selected by default in the Analysis Properties dialog: Interactions tab.

• On — The Drill (when not a primary interaction) option is selected by default in the Analysis Properties dialog: Interactions tab.

• Off — The Drill (when not a primary interaction) option isn't selected by default in the Analysis Properties dialog: Interactions tab.

Default: Off

Edition: Enterprise only

Specifies whether the Include/Exclude Columns option is selected by default in the Analysis Properties dialog: Interactions tab.

• On — The Include/Exclude Columns option is selected by default in the Analysis Properties dialog: Interactions tab.

• Off — The Include/Exclude Columns option isn't selected by default in the Analysis Properties dialog: Interactions tab.

Default: On

Edition: Enterprise only

Specifies whether the auto-complete functionality uses matching to find the prompt value that the user enters into the prompt field. This setting doesn’t apply if the user accesses the Search dialog to locate and specify a prompt value.

• StartsWith — Searches for a match that begins with the text that the user types. For example, the user types M and the following stored values are displayed: MicroPod and MP3 Speakers System.

• WordStartsWith — Searches for a match at the beginning of a word or group of words. For example, the user types C and the following values are displayed: ComCell, MPEG Camcorder, and 7 Megapixel Digital Camera.

• MatchAll — Searches for any match within the word or words.

Valid Values: StartsWith, WordStartsWith, MatchAll

Default: MatchAll

Edition: Enterprise only

Specifies whether the Add/Remove Values option is selected by default in the Analysis Properties dialog: Interactions tab.

• On — The Add/Remove Values option is selected by default in the Analysis Properties dialog: Interactions tab.

• Off — The Add/Remove Values option isn't selected by default in the Analysis Properties dialog: Interactions tab.

Default: Off

Edition: Enterprise only

Specifies whether workbook editors can add dataset enrichments to a visualization directly from the Data Panel. This setting enables enrichments in workbooks for all users. Workbook editors who own a dataset or have editing privileges for it can enable or disable knowledge enrichments for that dataset using the Enable Knowledge Enrichments option.

• On — Workbook editors can drag and drop enrichment based data elements to visualization canvases.

• Off — Knowledge enrichments are not available for datasets.

Default: On

Edition: Professional and Enterprise

Specifies whether the Create/Edit/Remove Calculated Items option is selected by default in the Analysis Properties dialog: Interactions tab.

• On — The Create/Edit/Remove Calculated Items option is selected by default in the Analysis Properties dialog: Interactions tab.

• Off — The Create/Edit/Remove Calculated Items option isn't selected by default in the Analysis Properties dialog: Interactions tab.

Default: Off

Edition: Enterprise only

Specifies the maximum number of rows you want displayed for content paging in table and pivot table views in analyses and dashboards.

The minimum number of rows you can specify to display is 100.

Valid Values: 100-5000

Default: 5000

Edition: Enterprise only

Specifies whether the Move Columns option is selected by default in the Analysis Properties dialog: Interactions tab.

• On — The Move Columns option is selected by default in the Analysis Properties dialog: Interactions tab.

• Off — The Move Columns option isn't selected by default in the Analysis Properties dialog: Interactions tab.

Default: On

Edition: Enterprise only

Specifies whether the Sort Columns option is selected by default in the Analysis Properties dialog: Interactions tab.

• On — The Sort Columns option is selected by default in the Analysis Properties dialog: Interactions tab.

• Off — The Sort Columns option isn't selected by default in the Analysis Properties dialog: Interactions tab.

Default: On

Edition: Enterprise only

Specifies whether users can personalize workbooks.

• On — Content designers can enable or disable personalization options (Filter and Parameter) in their workbooks.

• Off — Personalization options aren't available for workbooks.

Default: On

Edition: Professional and Enterprise