Configure Advanced Options

You can set several advanced options for Oracle Analytics Cloud through the Console.

About Advanced Configuration

Administrators can set more advanced, service-level options through the Systems Settings page.

Performance and Compatibility Options

You use these options to configure performance and compatibility settings between Oracle BI Enterprise Edition and Oracle Analytics Cloud. For example, you can set the maximum temporary file size.

System Setting More Information
Cache Enable

Specifies whether data query caching is enabled or disabled.

  • enabled — Data caching is enabled.

  • disabled — Caching is disabled.

Default: Enabled

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obis.CACHE_ENABLE

Evaluate Support Level

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

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

  • 1 — Service administrators only. Users with the BI Service Administrator application role can invoke EVALUATE database functions.

  • 2 — Anyone. Any user who signs in to Oracle Analytics Cloud can invoke EVALUATE database functions.

  • 0 (or any other value) — No one. All EVALUATE database functions are disabled in Oracle Analytics Cloud.

Valid Values: 0, 1, 2

Default: 0

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obis.EVALUATE_SUPPORT_LEVEL

OBIEE Compatibility Release

Specifies the on-premises Oracle BI Enterprise Edition version number for feature compatibility. This only applies if you upgrade from Oracle BI Enterprise Edition to Oracle Analytics Cloud, and you want to use a feature from a specific on-premises release in Oracle Analytics Cloud.

Valid Values: 11.1.1.9, 11.1.1.10, 11.1.1.11, 12.2.1.0, 12.2.1.1, 12.2.1.3, 12.2.1.4, 12.2.2.0, 12.2.3.0, 12.2.4.0, 12.2.5.0, DV_EXTN_11.1.1.9

Default: No value.

Restart Required: Yes

Name in Oracle BI Enterprise Edition:obis.COMPATIBLE_RELEASE

Maximum Working File Percent Size

Specifies that the temporary file doesn't exceed a specified percentage of the global work directory size limit.

The size limit defaults for temporary files is 5% (of 100 GB), equivalent to 5 GB. The file limit applies individually to each temporary file, while the size specified for the total global work directory applies collectively to all temporary files created.

You can increase or decrease this value within the range of 5% to 50%. This enables temporary file sizes between 5GB and 50GB. Raising this setting above 50% limits concurrency for large operations.

Valid Values: 5-50

Default: 5

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obis.MAX_WORK_FILE_SIZE_PERCENT

Strong Datetime Checking

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.

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

  • No — 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: Yes

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obis.STRONG_DATETIME_TYPE_CHECKING

Analysis, Dashboard, and Pixel-Perfect Report Options

You use these options to set defaults and customizations for dashboards, analyses, and reports. For example, you can configure the analysis editor to open by default to the Criteria tab or the Results tab.

System Setting More Information
Custom Links XML

Specifies the XML code containing Classic Home page header customizations.

You can use this XML code to customize the global header and the Get Started section of the Home page to better meet the needs of your users. For example, you can disable certain links or add custom ones.

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obips.CustomLinksXml

Writeback Template XML

Defines the XML configuration for performing writeback on data elements.

For example, you can use an XML template to enable users of a dashboard page or an analysis with the ability to modify, or write back, the data that they see in a table view.

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obips.WriteBack.TemplateXML

Answers Subject Area Sort Order

Sets the default sort order for subject area content trees. Users can override this default setting in the My Account: Subject Area Sort Order dialog.

  • asc — Sorts A to Z.

  • desc — Sorts Z to A.

  • rpd — Uses the subject area sort order specified in the original analyses.

Valid Values: asc, desc, rpd

Default: rpd

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obips.SubjectAreaTreeOrder

Answers Editor Start Tab

Specifies whether the analysis editor opens by default to the Criteria tab or the Results tab.

This setting applies when users click an Edit link for an analysis from a dashboard, the Home page, or the Catalog page.

Users can override this default setting by specifying the Full Editor option in the My Account dialog.

  • answerResults — Opens the analysis editor by default to the Results tab.

  • answerCriteria — Opens the analysis editor by default to the Criteria tab.

Valid Values: answerResults, answerCriteria

Default:answerResults

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obips.AnalysisEditorStartTab

BIP Reporting Toolbar Mode

Configures an alternate toolbar for pixel-perfect reports that are included in a dashboard.

  • 1 — Don't display a toolbar for pixel-perfect reports.
  • 2 — Displays the URL to the report without the logo, toolbar, tabs, or navigation path.
  • 3 — Displays the URL to the report without the header or any parameter selections. Controls such as Template Selection, View, Export, and Send are still available.
  • 4 — Displays the URL to the report only. No other page information or options are displayed.
  • 6 — Displays parameter prompts for the report in a toolbar.
Valid Values: 1, 2, 3, 4, 6

Default: 1

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obips.AdvancedReporting.ReportingToolbarMode

Usage Tracking Options

You use these options to specify how you want to monitor system usage. For example, you can set the number of rows that you want stored in the usage tracking tables.

System Setting More Information
Usage Tracking Logical Query Logging Table

Specifies the name of the database table you want to use to store logical query details. For example, <database name>.<catalog name >.<schema name >.<table name> or <database name>.<schema name >.<table name>.

Default: No value.

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obis.UT.PHYSICAL_TABLE_NAME

Usage Tracking Physical Query Logging Table

Specifies the name of the database table you want to use to store physical query details. For example, <database name>.<catalog name >.<schema name >.<table name> or <database name>.<schema name >.<table name>.

Default: No value.

Restart Required: Yes

Name in Oracle BI Enterprise Edition:

obis.UT.PHYSICAL_QUERY_TABLE_NAME
Usage Tracking Connection Pool

Specifies the name of the connection pool you created for your usage tracking statistics database. For example, <database name>.<connection pool name>.

Default: No value.

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obis.UT.CONNECTION_POOL

Usage Tracking Max Rows

Indicates the number of rows allowed in usage tracking tables, with a value of 0 indicating an unlimited number of rows.

Valid Values: Any positive number (up to 64-bit integer)

Default: 0

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obis.UT.UT_MAX_NUM_ROWS

Usage Tracking File Encoding

Specifies the file encoding type used for usage tracking. The type depends upon which database loader you're using. For example, to support multilingual repositories for database loaders used by Oracle Database, use UTF8.

Valid Values: ANSI, ASCII, UTF8, UNICODE

Default: UTF8

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obis.UT.CODE_PAGE

Usage Tracking Initialization Block Table

Specifies the name of the fully-qualified database table you use for inserting records that correspond to the initialization block statistics, as it appears in the physical layer of your data model file (RPD). For example, <database name>.<catalog name >.<schema name >.<table name> or <database name>.<schema name >.<table name>.

Default: No value.

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obis.UT.INIT_BLOCK_TABLE_NAME

Prompt Options

You use these options to configure prompt behavior. For example, you can enable search results to automatically display as highlighted when users enter search parameters, without the need to click Search.

Note:

These options apply only to analyses and dashboards. They're not supported for Data Visualization.
System Setting More Information
Support Auto Complete

Enables or disables the auto-complete functionality available in prompts.

  • Enabled — Enables auto-complete, which means that the Prompts Auto-Complete field is displayed and set to On in the My Account dialog and in the Dashboard Properties dialog.

  • Disabled — Disables auto-complete, which means that the auto-complete fields in the My Account and Dashboard Properties dialogs aren't available.

Default: Disabled

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obips.Prompts.AutoCompletePromptDropDowns.SupportAutoComplete

Case Insensitive Auto Complete

Specifies whether, when a user enters a prompt value in analyses and dashboards, the auto-complete functionality is case-insensitive.

  • Enabled — Case isn't considered when a user enters a prompt value such as "Oracle" or "oracle."

  • Disabled — Case is considered when a user enters a prompt value, so the user must enter "Oracle" and not "oracle" to find the Oracle record.

Default: true

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obips.Prompts.AutoCompletePromptDropDowns.CaseInsensitive

Show Null Value When Column Is Nullable

Specifies whether to show the term "NULL" at runtime in the column prompt above the column separator in the drop-down list when the database allows null values.

  • always — Always shows the term "NULL" above the column separator in the drop-down list.

  • never — Never shows the term "NULL" in the drop-down list.

  • asDataValue — Displays the data value in the drop-down list, not the term "NULL" above the separator in the drop-down list.

Valid Values: always, never, asDataValue

Default: always

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obips.Prompts.ShowNullValueWhenColumnIsNullable

Auto Apply Dashboard Prompt Values

Enables the option to hide the Apply button so that prompt values can be applied without clicking any button.

If this is property is Enabled:

  • Displays the Show Apply Button and Show Reset Button fields in the Edit Page Settings dialog.

  • Displays the Prompts Apply Buttons and Prompts Reset Buttons fields in the Dashboard Properties dialog.

  • Displays the Prompt Buttons on Current Page option on the dashboard builder's Tools menu.

Default: Enabled

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obips.Prompts.AutoApplyDashboardPromptValues

Auto Search on Prompt Value Search Dialog

Enables search results to automatically display and highlight when users enter search parameters, without the need to click Search.

Default: Enabled

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obips.Prompts.AutoSearchPromptDialogBox

Format Options

You use these options to configure default currency and time zone settings.

System Setting More Information
Currencies XML

Defines the default currency that's displayed for currency data in analyses and dashboards. For example, you can change from American dollars ($) to Euros (E).

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obips.CurrenciesXml

User Currency Preferences XML

Determines whether users see a Currency option in their My Account preferences dialog and the list of currencies available to them. If you provide the Currency option, users can select in which currency they prefer to view columns of currency data in analyses and dashboards.

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obips.UserCurrencyPreferencesXml

Default Data Offset Time Zone

Specifies a time zone offset of the original data that users see in analyses and dashboards. Enter an offset value that indicates the number of hours away from Greenwich Mean Time (GMT) time.

For example, to display values in United States Eastern Standard Time (EST), which is Greenwich Mean Time (GMT) - 5 hours, enter the value GMT-05:00 or the equivalent value in minutes -300.

If you don't set this option, no time zone conversion occurs because the value is "unknown".

If you want to specify a different offset value for each user, enter the session variable DATA_TZ.

Example: GMT-05:00 or -300 , which means minus 5 hours.

Example: DATA_TZ

Default: No value. Equivalent to Greenwich Mean Time (GMT), 0 offset).

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obips.TimeZone.DefaultDataOffset

Default User Preferred Time Zone

Specifies a default preferred time zone that users see in analyses and dashboards before they select their own in the My Account Preferences dialog.

If you don't set this option, then the value is the local time zone from Oracle BI Presentation Services.

Enter one of the time zones specified in the TimeZones.xml file.

If you want to specify a different preferred time zone for each user, enter the session variable TIMEZONE.

Example: (GMT-08:00) Pacific Time (US &amp; Canada); Tijuana

Example: TIMEZONE

Default: No value.

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obips.TimeZone.DefaultUserPreferred

View Options

You use these options to configure default search and viewing settings for users.

Note:

These options apply only to analyses and dashboards. They're not supported for Data Visualization.
System Setting More Information
Prompt Auto Complete Matching Level

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: MatchAll, StartsWith, WordStartsWith

Default: MatchAll

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obips.Prompts.AutoCompletePromptDropDowns.MatchingLevel

Default Scrolling Enabled
Specifies how data scrolls in these views: table, pivot table, heat matrix, and simple and advanced trellis views.
  • Enabled — Data displays with a fixed header and content scrolling controls for users to browse the data.

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

Default: Enabled

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obips.Views.GridViews.DefaultScrollingEnabled

View Interactions: Include/Exclude Columns

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

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

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

Default: Enabled

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obips.Analysis.InteractionProperties.InclExclColumns

View Interactions: Display/Hide Running Sum

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

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

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

Default: Disabled

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obips.Analysis.InteractionProperties.RunningSum

View Interactions: Create/Edit/Remove Groups

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

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

  • Disabled — The Create/Edit/Remove Groups option is not selected by default in the Analysis Properties dialog: Interactions tab.

Default: Disabled

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obips.Analysis.InteractionProperties.GroupOperations

View Interactions: Move Columns

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

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

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

Default: Enabled

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obips.Analysis.InteractionProperties.MoveColumns

View Interactions: Sort Columns

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

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

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

Default: Enabled

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obips.Analysis.InteractionProperties.SortColumns

View Interactions: Display/Hide Sub-totals

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

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

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

Default: Disabled

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obips.Analysis.InteractionProperties.ShowHideSubTotal

View Interactions: Drill

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

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

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

Default: Enabled

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obips.Analysis.InteractionProperties.Drill

View Interactions: Add/Remove Values

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

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

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

Default: Disabled

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obips.Analysis.InteractionProperties.AddRemoveValues

View Interactions: Create/Edit/Remove Calculated Items

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

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

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

Default: Disabled

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obips.Analysis.InteractionProperties.CalcItemOperations

Connection Options

You use these options to configure connection defaults. For example, you can specify how often to synchronize the database connections defined in Console.

System Setting More Information
Connection Externalization Enabled

Specifies whether to externalize any database connections that administrators configured for data models in Oracle Analytics Cloud, using Console.

When you externalize the connection information, anyone who uses Oracle Analytics Developer Client Tool to edit data models can refer to the database connections “by name” rather than re-entering the connection details in full (connection pool settings). See Connect to a Data Source using a Connection Defined Through Console.

  • Enabled — Externalize the database connections that administrators define for data models through Console.

  • Disabled — Don't externalize database connections details. Anyone using Oracle Analytics Developer Client Tool to edit data models must enter the database connection information in the Connection Pool dialog.

Default: Enabled

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obis.CONNECTION_EXTERNALIZATION.ENABLED

Connection Externalization Polling Interval

Specifies how often Oracle Analytics Cloud synchronizes database connections defined in Console. Enter a suitable polling interval, in seconds. By default, database connections are synchronized every 180 seconds.

This property is used only when Connection Externalization Enabled is set to yes.

Valid Values: 60-3600

Default: 180

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obis.CONNECTION_EXTERNALIZATION.POLLING_INTERVAL

Security Options

Use Security options to control how users can perform specific actions.

Note:

These options apply only to analyses and dashboards. They don't apply to data visualizations.
System Setting More Information
Allow HTML Content

Determines whether the Contains HTML Markup option is displayed in various dialogs and editors where you can apply formatting. This option allows users to format content with valid HTML markup.

  • Enabled — Display the Contains HTML Markup option in various dialogs where additional formatting might be useful. For example:

    • For analyses: In the analysis editor, Analysis Properties dialog, Column Properties dialog, New Calculated Measure dialog.
    • For dashboards: In the Dashboard Properties dialog.
  • Disabled — Hide the Contains HTML Markup option. Users can enter only plain text.

Default: Disabled

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obips.Security.EnableSavingContentWithHTML

URL for Browser Script Actions

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

Default: No value.

Restart Required: Yes

Name in Oracle BI Enterprise Edition: obips.ActionFramework.UserScriptsURL

Set Advanced Options for the Service

Use Console to set advanced options for Oracle Analytics Cloud.

  1. In Oracle Analytics Cloud, click Console.
  2. Click System Settings.
  3. Update the Property Value.
  4. If required, click Restart and then click OK to confirm.
    Wait a few moments for the changes to refresh through the system.