Performance and Compatibility Options

You use these options to configure performance and compatibility settings between Oracle BI Enterprise Edition and Oracle Analytics.

System Setting More Information
Query Limit Extension

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

Mobile Data Watch Service Frequency

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

Strong Datetime Type 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.

  • 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

Load Semantic Models Using Multiple Threads

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.

  • On — Semantic models load in parallel.

  • Off — Semantic models don't load in parallel.

Default: Off

Edition: Enterprise only

Enable Auto Insights on Datasets

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.

Edition: Professional and Enterprise
Enable Immediate Dashboard Rendering

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

  • On — Display dashboard content immediately even if some content is unavailable.

  • Off — Wait for all the dashboard content to be ready before displaying content.

Default: Off

Edition: Enterprise only

Mobile Data Watch Service Enabled

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

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 can invoke EVALUATE database functions.

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

Valid Values: 0, 1, 2

Default: 0

Edition: Professional and Enterprise

Enable Database Analytics Node in Data Flows

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

  • On — The Database Analytics node is available in data flows so that data flow designers can apply database analytics functions to the data.

  • Off — The Database Analytics node isn't available in data flows. This prevents data flow designers from generating a potentially high number of SQL statements and slowing database performance.

Default: On

Edition: Professional and Enterprise

Restrict Data Export and Delivery

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 Oracle Analytics 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

Maxiumum Query Limit (seconds)

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

Brushing Enabled for Subject Areas

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

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

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

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

Default: On

Edition: Enterprise only

Cache Enable Specifies whether data query caching is enabled or disabled.
  • On — Data caching is enabled.
  • Off — Caching is disabled.

Default: On

Edition: Professional and Enterprise

Brushing Enabled for Datasets

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