My Oracle Support Banner

OBIEE 11.1.1.9 : New Features (Doc ID 2010034.1)

Last updated on JANUARY 30, 2020

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.9.0 and later
Business Intelligence Server Enterprise Edition - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Details

On : Oracle Business Intelligence Enterprise Edition

 

These are the some of the new features available with OBIEE 11.1.1.9

Answers and Dashboards

Scorecard and Strategy Management

This release provides the ability to specify the number of decimal places to include in scores.

Dashboards

This release provides the ability to create custom export layouts for exporting dashboard content to Excel.

Managing Accounts

This release provides enhancements that enable you to replace account entries in the Access Control List (ACL) and to manage Unresolved Accounts.

Selection Steps

This release provides the ability to use variables to override values in selection steps.

Export Functionality

This release includes the following enhancements to the export functionality:

  1. New and changed components in the "Print & Export Options dialog," including:
    1. New options in the Orientation component to specify the orientation for PDF and Powerpoint.
    2. New options to specify whether to include charts, images and formatting.
    3. New option to specify whether to wrap text in columns.
    4. New option to limit column width.
    5. The default value for the Print Rows component has changed to All.
  2. The page break options have been renamed to Each member of all columns (previously Innermost Column) and Each member of first column (previously Outermost Column in the "Section Properties dialog" and the "Sections Formatting dialog: Display Options tab."
  3. When you export a column that includes an image to Excel, the extra blank column that previously appeared will no longer appear.
  4. The Format component in the "Agent editor: Delivery Content tab" now includes the Excel 2007+ value.
  5. The Export menu no longer includes the Excel 2003 and Powerpoint 2003 options.
  6. When you export a column whose data format is set to Percentage, the column is now exported as a percent format. (In previous releases, the column was exported as a custom format. Then, in Excel, when you changed the format from custom to percentage, Excel multiplied the value by 100 and displayed the result with a percent symbol, which changed the data.)
  7. You can now specify a limit to the number of rows downloaded to CSV format.  The default is 65000.

Enhancements to Analyses

This release provides, for analyses, the ability to:

  1. Initiate a search within the subject areas that are displayed in the Subject Areas pane. See "Subject Areas pane."
  2. Save columns to the Oracle BI Presentation Catalog for reuse in other analyses.

For more information on all these features, see the section entitled New Features for Oracle BI EE 11g Release 1 (11.1.1.9) () in the Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition.

Storage of Calculations in the Web Catalog

You can store reusable calculations in the web catalog use use in variables.

Metadata Repository Builder

Whole Rpd Checkout Option Added to Multiuser Menu

If you need to check out an entire repository rather than using projects for multiuser development, you can use the Whole Rpd Checkout option.

Improvements to Aggregate Persistence

This release provides the following aggregate persistence improvements:

  1. The Oracle BI Summary Advisor wizard now includes the Use Surrogate Keys field which is selected by default. Selecting this option improves the performance of surrogate key creation and allows aggregate persistence to create aggregates for levels with non-unique level keys.
  2. Aggregate persistence auto-corrects, or hardens, level keys that are not unique.
  3. Aggregate persistence creates aggregates for logical dimensions with unbalanced (ragged) and skip-level hierarchies.
  4. Aggregate persistence generates chronological keys for time levels without chronological keys for which aggregates are to be created. When the chronological keys are generated, a new column is added to the physical dimension aggregate table to store the chronological key values. A new logical column is created in the logical table of the time dimension.
  5. The delete aggregates statement has been enhanced to delete the logical key and logical column created when chronological keys are generated by aggregate persistence.
  6. Aggregate persistence can now store actual column values counted on distinct values, which allows aggregates with count distinct measures to serve queries for these measures at higher grains. The Aggregate Persistence wizard now included the Persist 'Count Distinct' measures as raw values option which when selected appends the as_raw_values clause to all valid count distinct measures specified.
  7. The Summary Advisor command line utility (nqaggradvisor) is available to generate an aggregate specification script that you can then run to create the aggregates. The nqaggradvisor utility is only available if you are running Oracle Business Intelligence on the Oracle Exalytics Machine.

Initialization Block Written in JSON Syntax

This release provides the ability to use variables to override values in selection steps. A variable used to override selection steps must use an initialization block with its initialization string written in JSON syntax.

Translation Keys

Translation keys have been added to all presentation objects. The translation key is automatically populated and by default it matches the presentation object's name; however, you can modify the translation key. When you externalize display names in the Presentation layer and run the Externalize String utility, the results contain the translation key.

New Administration Tool Options

Two new Administration Tool options have been added: Display Translation Key in the presentation tree and Edit presentation names.

Script Added to Upgrade DataDirect Drivers

Customers using DataDirect drivers and upgrading to Oracle BI EE 11g Release 11.1.1.9 must use the new script to upgrade to the DataDirect drivers required by Oracle BI EE 11.1.1.9. This upgrade must be done on each server running DataDirect with Oracle BI EE.

Cloudera Impala Supported

Oracle BI EE now supports Cloudera Impala as a database. The DataDirect Connect ODBC driver needed to connect to Impala is now provided.

Access to Hyperion Planning Data Sources

Oracle BI EE now supports Hyperion Planning as a data source.

Expanded Oracle 12c Database Support

This release provides support for the following Oracle databases: Oracle 12c Database In-Memory, Oracle 12c Database on Exadata, and Oracle 12c Database In-Memory on Exadata. This release also provides Oracle BI Server support for the compression, Exadata Hybrid Columnar Compression (EHCC), and in memory Oracle database features.

For more information on Metadata repository new features, see the section entitled New Features for Oracle BI EE 11g Release 1 (11.1.1.9) in the Oracle® Fusion Middleware Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition

New features for System Administration

New Properties for Full-Text Search

New properties have been added to enhance full-text searching.

New or Enhanced Configuration Elements

New or enhanced configuration elements for the instanceconfig.xml file are available:

  1. Configuring Export — The following elements are available to configure for export:
    1. Orientation
    2. DataValue
  2. Configuring for Graphs and Gauges — The DefaultWebImageType element now supports the html5 format for rendering images.
  3. Configuring Settings for Fetching Data for Table Views, Pivot Table Views, and Trellis Views — The DefaultFreezeHeadersWidth and Default FreezeHeadersHeight elements are available to specify the default width and height of table views, pivot table views, and trellis views that use scrolling as the method to browse data.
  4. Enabling the Ability to Export Dashboard Pages to Oracle BI Publisher — The EnableDashPageExport element has been enhanced to include the ability to export dashboard pages to BI Publisher for custom export layouts as well custom print layouts.

New NQSconfig.INI Settings

The following configuration parameters have been added to the NQSconfig.INI file.

Debugging Agents Using Fusion Middleware Control

Agent log entries are now written to the scheduler log file, and are visible using Fusion Middleware Control.

For more information on System Administration new features, see the section entitled New Features for Oracle BI EE 11g Release 1 (11.1.1.9) in the Oracle® Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition

Usage Tracking Features

The following features have been added or improved in usage tracking:

  1. millisecond precision
  2. initialization block execution (s_nq_initblock)
  3. user session IDs
  4. physical query hash

New Features for Security

New Privileges

The following new privileges were added to the Presentation Services Administration page:

For more information on new security features, see the section entitled New Features for Oracle BI EE 11g Release 1 (11.1.1.9) in the Oracle® Fusion Middleware Security Guide for Oracle Business Intelligence Enterprise Edition

New Features for Integration

SchedulerService Web Service

Oracle Business Intelligence includes a SchedulerService Service.
Methods were added for this new web service.

For more information on the new integration features, see the section entitled New Features for Oracle BI EE 11g Release 1 (11.1.1.9) in the Oracle® Fusion Middleware Integrator's Guide for Oracle Business Intelligence Enterprise Edition 

Actions

 

Contacts

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Details
 Answers and Dashboards
 Scorecard and Strategy Management
 Dashboards
 Managing Accounts
 Selection Steps
 Export Functionality
 Enhancements to Analyses
 Storage of Calculations in the Web Catalog
 Metadata Repository Builder
 Whole Rpd Checkout Option Added to Multiuser Menu
 Improvements to Aggregate Persistence
 Initialization Block Written in JSON Syntax
 Translation Keys
 New Administration Tool Options
 Script Added to Upgrade DataDirect Drivers
 Cloudera Impala Supported
 Access to Hyperion Planning Data Sources
 Expanded Oracle 12c Database Support
 New features for System Administration
 New Properties for Full-Text Search
 New or Enhanced Configuration Elements
 New NQSconfig.INI Settings
 Debugging Agents Using Fusion Middleware Control
 Usage Tracking Features
 New Features for Security
 New Privileges
 New Features for Integration
 SchedulerService Web Service
Actions
Contacts
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.